Re: help recovering archives when all files in sync

If you lose your control files when everything blows up, you would restore from tape(hopefully offsite or they would no doubt burn in the resulting blaze). You would have to restore control files in this case. As a result, the best you could hope for would be to recover to the timestamp in the control files. This isn't too far different than what you would have as a result of a cold backup. The moral of the story is don't let your control files blow up.

PS, even if you didn't lose the control files, since the place blew up, you wouldn't have any archive logs other than what was backed up, so you couldn't recover any further anyhow. I suggest that you get in the habit of praying to the disaster recover god every morning before you check the alert logs. Sacrificing your first born son couldn't hurt either(except your son might feel some pain).
Oh, and never let anyone into the datacenter if they are carrying briefcases.

--
Dave A


"Syltrem" <syltrem_at_videotron.ca> wrote in message
news:noZH5.3492$5I.65909_at_weber.videotron.net...


> Hello!

>

> I was following this conversation and it raised a question:

>

> If I always do online backups (never offline), how do I restore my entire

> database (let's say the whole place blew up)?

>

> Specifically:

> Do I need to restore my redo log files from tape, or will the ALTER

 DATABASE


> OPEN RESETLOGS create them?

> Do I need to recreate the controlfile from a script (create controlfile

> reuse...) or should I use the actual controlfiles that I saved to tape

> during the backup?

>

> Thanks!

>

>

> "Howard J. Rogers" <howardjr_at_www.com> wrote in message

> news:39f057ef$1_at_news.iprimus.com.au...

> > Yes, don't restore the Control Files or online Redo Logs.

> >

> > If you restore everything from a cold backup, you have a perfectly

> > synchronised database as at the time of the cold backup.

> >

> > What prompts the application of Archives is when SMON spots that the

> > timestamps on the Control Files don't agree with the timestamps on

> > everything else.  So make sure you leave the Control Files at the point

 in


> > time in the future, and bring back only the 'old' datafiles.  The same

 goes


> > for the Redo Logs (since you'll need their content to bring the database

> > bang up to date -overwrite them with last night's backup, and you've

 just


> > lost data).

> >

> > The rules of backup and recovery are really very simple -and the

 simplest
 of


> > them all is, if you have archives, you only ever restore the files which

 are


> > causing the problem, not the whole lot.

> >

> > Regards

> > HJR

> > --

>

> --------------------------------------------------------------------------

> > Opinions expressed are my own, and not those of Oracle Corporation

> > Oracle DBA Resources:

 http://www.geocities.com/howardjr2000


>

> --------------------------------------------------------------------------

> >

> > "Joe Gulla" <jgulla_at_erols.com> wrote in message

> > news:8siobp$nb7$1_at_bob.news.rcn.net...

> > >   I was trying to recover data from point of a full cold backup to a

 time
 in


> > > future. I have all archives

> > > but since I replace all of database files from time of backup when I

 do
 a


> > > recover all instance is in ssync.

> > >         Is there a way around this?

> > >                 Joe G

> > >

> > >

> >

> >

>

>