Re: Recovery question

From: JHY <jhy_at_earthling.net>
Date: Mon, 29 Jun 1998 21:09:39 -0400
Message-ID: <6n9dsc$dpg@bgtnsc01.worldnet.att.net>

Try backing up your current control file when you backup your archive logs.

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 Mon Jun 29 1998 - 20:09:39 CDT