Re: Redo logs backup??

We ran into a similar situation.
we had a cold backup except the redologs. We lost on drive which had data files. we did not loos the redo logs, also we had a backup of the redo logs just before the backup .

When we restored the all the datafiles and the controlfile. Oracle found out it needed media recovery, but when you say 'recover database' then it says 'control file older than data file'.

Now we know redo log is the culprit, if we can some shut up the redo log we should be fine (since it is cold backup , with the database in noarchivelog mode) with that backup.

Here is what i did.

1. startup mount.
2. alter database backup controlfile to trace;
3. edit the trace file (this creates a new control file).
4. mv the existing control file.
5. _at_trace_file
6. shutdown normal
7. Startup, we were back in business. This may look dangerous but what the heck, we lost it any way we are just trying to recover. Take a backup of the existing stuff before attempting this so that you wont blame me for suggesting this.

Ref bulletin board: 1012929.6

If you have ARCHIVELOG on then probably you can to a point in time recovery..

BOTTOM LINE: PROTECT YOUR REDO LOGS AS THOUGH THEY ARE CONTROLFILES. Steve Long wrote:
>
> Back them up on tape.
>
> Steve
> 804-262-6332
>
> -----------------------------------
>
> In <4p4s02$8de_at_news.inforamp.net> lokp_at_tdbank.ca (Peggy Lok) writes:
> >
> >
> >I was reviewing our backup and recovery strategy the other day, and
> >while going down the checklist I noticed that I didn't put in any
> >plans to protect our redo logs. So... with a copy of the 'Oracle 7.2
> >Admin Guide' besides me, I decided to do some testing in our TEST
> >database and found out I couldn't recover (complete or incomplete) the
> >database if there is a hardware problem and we lost ALL the redo logs.
> >Even worst, what if other than the redo logs, it also took away some
> >of the datafiles then how are we going to do a recovery from our
> >online backups....
> >
> >
> >Could anyone please let me know what I should do ( before a real hit
> >to our redo logs ) ....
> >
> >Thanks in advance...
> >
> >Peggy Lok
> >
  Received on Thu Jun 06 1996 - 00:00:00 CEST