Re: Different backup procedure.

If you have lost everything, including the control files, you need to use: 'RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;' Then Oracle knows that the stop SCN's recorded in the restored control file is not
valid and it keeps applying redo logs until you reply CANCEL.

You don't cancel until it applies all available logs.

If the un-archived redo logs were also lost, then the last archived log is as far as you can go; you lose whatever transactions were in the lost log(s).

If the un-archived redo logs are still available, these will be applied after the archived logs and no transactions will be lost. This why you need to mirror the on-line redo logs.

When the recovery is done, you then must: ALTER DATABASE OPEN RESETLOGS; Devinder Pal Singh wrote:

> Dear Robert Prendin
> Saw your article over the net and found it very interesting. I have some
> confusion regarding the hot backup and archivelog mode backup.Please
> bear with me.
> If your database is running in archive log mode, thenis it necessary to
> take hot backup also or achive log along with cold backup will suffice.
> Let us say we take cold backup on sunday and backup of offline redolog
> files everyday. If on tuesday or wednesday (assume) whole of the system
> crashes ( you lose every datafile, every control file) and you have to
> roll forward you database from scratch. The onvious thing would be to
> put the cold backup into the machine and apply your redo logs. But (the
> catch) when you put cold backup and mount your database and give recover
> database command, wont it say that no recovery required. Since
> everything is in sync, the control file, datafiles etc, they have the
> same time stamp, same SCN. Can you enlighten me on this thing, I tired
> and failed to roll forward the databse.
> I am having great hopes and anticipations from your side, please do
> reply.
> Reagrds
> Devinder
Received on Mon Aug 10 1998 - 22:31:36 CDT