Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: what are in these archived redofiles?
Hi ,
The archived log files as the name suggests is a copy of the redo log
files , copied by the ARCH process. The number of files generated depends
on the log swiftches that are taking place.
The idea of having the redo log files archived is for recovery of databases
in case of database crash problems etc.
Depending on your backup strategy you can delete the unwanted archived log
files periodically , preferable after taking a backup of these files.
The log files contain the details of all the transactions that are taking place in your database.
Regards
Anbu
Michel Gauthier <qgmi1_at_qbc.clic.net> wrote in article
<01bd2bf4$7dbfac50$b26054c7_at_qcqgmi1>...
> Hi there,
> We are implementing a new apps with Oracle 7.2.3. Some of our programs
seem
> to fill in the redofiles very quickly. Since we turned on automatic
> archiving, we produce an important amount of archived redofiles. Is there
a
> way, an Oracle product, a third party product or anything else to see
what
> the archived redofiles contain. It would help us to identify which
> programs/transactions are so log-productive.
> Thanks.
> --
> Michel Gauthier
> qgmi1_at_qbc.clic.net
> Produits Forestiers Donohue Inc.
> The ideas expressed/language used reflect those of the author,
> Not necessarly those of Donohue Inc.
>
Received on Thu Jan 29 1998 - 00:00:00 CST