Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 7596845Received on Tue Sep 22 1998 - 00:00:00 CDT