Re: Redo's with cold backup

Adrian Beane wrote:
>
> In message <33781184.3380_at_gzs.de>
> Detlev Goebel <detlev.goebel_at_gzs.de> writes:
>
> > > If I had all the relevant redo logs on archive but had to use a cold
> > > backup of the tablespaces with, say the current control file, what
> > > would be the problems?
 

> > if you have all redo logs there's no problem to do your backup. You are
> > in need of all redo logs since the backup you like to create.
> > If there is a lack of redo logs you will have a problem.
>
> So I could restore an offline backup of the database and then apply
> the redo logs to the restored database? I always thought I needed a
> hot backup to use the redo logs.
>
> --
> Adrian Beane
> ajbeane_at_zetnet.co.uk
>
> "Hey, these opinions aren't even mine"

Trying to describe the in’s and out’s of backup and recovery as bits and pieces in a news thread is playing with fire. You “MUST” take the time to read the Oracle7 Server Concepts guide chapters 22->24 , the Oracle Press Backup & Recovery book published by Osborne, and practice-practice-practice.

I can’t describe all the tips and tricks here but to try to answer your question, NO. If you have the control file from/at the time of crash or the right type of controlfile backup, you can roll forward to the current from the last cold/hot using the (if you have all of them) archives.

Some key things to read about are the commands “alter database backup controlfile to trace” and “alter database backup controlfile to ‘filename’”.

Also, understand that if you know your stuff, you can get to the point that a cold backup is not necessary. You can do recovery using only hot backups providing you have all the pieces (think 7X24).

brian.maclean_at_teldta.com Received on Tue May 13 1997 - 00:00:00 CDT