Re: Problems applying archived redologs

Piotr Kolodziej (pkol_at_otago.gda.pl) wrote:

: How did you backup control files? BTW - is that cold or hot backup ?

The best way is to "alter database backup controlfile to trace;"

This will drop an ASCII version of the control file into your udump area, which can be edited to rebuild the control file in case of emergency.

Do this every night and this will ensure any database structure changes (eg added datafiles) will be reflected automatically in the latest trace.

--

rgds
Stephen Received on Tue Feb 16 1999 - 04:59:16 CST