Recovery question

From: Gilberto Casiraghi <edipi_at_candy.it>
Date: Mon, 15 Jun 1998 12:38:14 +0200
Message-ID: <3584F996.41C0DC9B@candy.it>

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 Mon Jun 15 1998 - 05:38:14 CDT