Re: Recovery question

Oracle thinks no recovery is required because the SCN's in all the file headers match the SCN in the control files. This is what you always get when you restore the control files from the same backup as the data files.

To get around this, you must add 'using backup controlfile' to your recover database command.

Gilberto Casiraghi wrote:

> Hello all!
> Imagine this scenario: I have a db running in archive mode. I do
> a physical (offline) backup avery week (e.g. Saturday) and every
> day I save the archived redo log (suppose every hour). All these
> files are archived to tape.
> Now suppose a disaster happens and I lose ALL the physical files
> of my database.
> The only chance I have it is to recover the files from the weekly
> backup and then apply all the archived redo log saved to tape.
> But after I start (mount) the db and I give the 'recover database'
> command the system return this error: ORA-00264: no recovery required.
> (maybe becouse the weekly backup is consistent !)
>
> How is it possible to recover the database till the last saved redo
> log ? Or I have to do a different weekly backup ?
> PS: I am running Oracle Server 7.2.
>
> Thanks in advanced.
> Bye.
> Gilberto Casiraghi.
Received on Thu Jun 18 1998 - 22:42:55 CDT