Retention of Data - how long before archive
Date: Wed, 18 Aug 1999 14:39:37 -0400
From: "Benjamin, Sue" benjamis@toysrus.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: Archive - Retention of Data
We are looking for information on how long other companies keep transactions
and balances in Oracle. Specifically, for the GL, Assets, and Payables
modules.
Also, if you have experienced any problems with the Archive & Purge as
delivered from Oracle, please let us know. We are on 10.7 character.
Thanks for your reply!
Sue Benjamin
Financial Systems
Store Support Center/ Montvale
201-802-5012
Date: Wed, 18 Aug 1999 15:47:16 -0300
From: Melanie Perry Melanie.Perry@moncton.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Archive - Retention of Data
Hi Sue
I have created a script that removes the archive log files after 5 days
online. We do nightly cold backups of all our DB instances including all
the archive files too. Fortunately, we have not had a scenario where we had
to resort to the archive files but according to Oracle, the layout we have
is just fine.
As far as the Archive and Purge utility, we had lots of problems. I believe
we are fine now after lots of issues and problems. We need to purge 7 years
of data from our test system. The users are still in the process of purging
this data and after they complete what they want to purge, then I have to go
in and export all the tables that were being purged and re-import them in
order to free up the unused tablespace.
Melanie Perry
SSA \ DBA
The City of Moncton
Moncton, NB
Canada
Archived log size
From: Rudy Wahab [SMTP:rudy@fcm.ed.fujitsu.co.jp]
Sent: 04 April 1999 05:51
Subject: Archived log size??
Hi,
At the moment my production database is running under nonarchived mode
and I plan to to change it to archive mode.
I wonder the size of the archive file everytime it is being created.
The size of my redo log file is 2M each. I have 3 groups of log files
with
2 members each. Can someone help me?
regards,
*************************************************************************
Rudy Wahab Phone: 07-454 2111 ext 211/313/218
System Analyst email: rudy@fcm.ed.fujitsu.co.jp
Information Services Section 20
Fujitsu Components (M) Sdn. Bhd.
Batu Pahat, Johor.
Malaysia
*************************************************************************
Date: Sun, 4 Apr 1999 11:07:03 +0100
From: Graham Duggan gjduggan@mail.com
Subject: RE: Archived log size??
Each file when written out will be the size of the online redo log.
check the v$loghist view for information on how many log files will be
written out in any given period as log switches are recorded here.
Although you are running mirrored redo logs only one copy will be
written out with each switch.
Graham.
Date: 4 Apr 99 18:33:49 EDT
From: Dinesh Chandra dchandra@usa.net
Subject: Re: [Archived log size??]
Hi Rudy,
For normal activity of database, you should have 32MB, redo file. 2MB is
too
small for archive log. Your database operations may wait for archiving. W
ith
2MB redo files, you will have so many arch files and you may have managem
ent
problem.
If activity is high, you should have 64MB redo file size.
Thanks
Dinesh Chandra
Archive facility of gl_interface_history
Date: Tue, 31 Aug 1999 12:50:20 -0600
From: "Gauna, Ramona T" rtgauna@sandia.gov
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: GL_INTERFACE_HISTORY
Has anyone used the archive facility of GL_INTERFACE_HISTORY?
Ramona Gauna
Oracle Applications Development (04801)
Sandia National Laboratories
Albuquerque, NM 87185-1146
(505)845-9275
(505)844-4780 (FAX)
rtgauna@sandia.gov
Archive PA records
Date: Thu, 2 Sep 1999 11:17:46 -0700
From: "Haseeb, Mohamed" Mohamed.Haseeb@Jacobs.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: PA: Archive data
Our PA data tables are huge - running into millions of rows. We are planning
to archive the data, removing transactions for some of the projects which
are completed in all sense.
Has anyone done this ? Faced any problems ?
Any ideas or suggestions on this would be greatly appreciated.
Regards... Haseeb
Date: Fri, 03 Sep 1999 00:36:29 +0300
From: "Dina Rotem (h)" dinar@rafael.co.il
To: Ora OraApps-L@cpa.qc.ca
Subject: RE: PA: Archive data
Haseeb
I think Oracle had promised to release a new functionality for purge &
archive that could be installed on top of release 10.7 and higher. It
was supposed to be released during Y99. You may want to check with
them before customizing.
Dina