Re: oracle disaster recovery

Hello John,

the sequence is just fine, but suppose you get an error during archived redo log applying (as i got, in fact). The kind of error is most inexpressable - internal ora-0600 error with a bunch of numeric information.

I assumed that certain archived log is corrupted in a nasty way, so RECOVER UNTIL CHANGE was done, to bring the database to the time just before that archived log was created.

And after i issue ALTER DATABASE OPEN RESETLOGS i get that message:

alter database open resetlogs
*
ORA-01195: online backup of file 1 needs more recovery to be consistent ORA-01110: data file 1: '/oracle/SYSTEM_f00.dbf'

I have full online database backup, backup controlfile (created by appropriate sql statement), archived redo logs (with one impassable). And i cannot bring database in working state.

Thank you for attention,
Sincerely,
Igor

John P. Higgins wrote:
>
> No problem.
>
> Restore all your files from your latest hot backup.
> Restore all the archived redo log files since the start of that
> backup.
> Startup mount.
> Recover database until cancel.
> Cancel after last log is applied.
> Alter database open resetlogs.
> Take a hot/cold backup now!
>
> Since your old machine is 'toast', you have lost whatever was in the
> lost online log file and any archived log files that were never backed
> up.
>
> If you take a hot backup after the restore, you get the system back to
> the users sooner. If the hot backup is successful, you never need a
> cold backup.
>
> But, there is a risk here -- if you crash again before the backup is
> complete, you must repeat the prior restore/recovery and lose the
> updates that had occurred since then.
>
> This is a business decision: is the slight risk of lost work worth
> waiting for a cold backup?
>
 

-- 
Igor Sereda         sereda_at_rus.net
Internet Technology Center, Russia
+7-812-3272860         icq 7596845