Recovery with three days old backup

From: Sreejith Nair <sreejithsna_at_gmail.com>
Date: Sat, 20 Dec 2014 12:14:59 +0530
Message-Id: <FADDA18E-F2D2-4179-B87D-556BFCB39ABE_at_gmail.com>

Dear List

Here is the scenario.

I have a 10.2.0.5 database single instance in Oracle Solaris 10 ( no ASM ).

We stored data files in mount points and three days back one of the mount point crashed.

We have three days old INCREMENTAL LEVEL 0 backup and ARCHIVELOG backups available. But CONTROL FILE AUTOBACKUP was not set to ON and we ended up having a backup with no control file auto backups.

We have restored the backup from tape. The database at present can be mounted as the mount point where controlfile is residing is still available.

Is it possible to recover the database if I take a control file backup now after changing AUTOBACKUP to ON. Can we use the controlfile backup from today ( after the data files are lost ) to recover the database from three days old data file and ARCHIVELOG backups.

Kindly suggest if I have any other recovery strategy available.

Regards
Sreejith

Sent from my iPhone --
http://www.freelists.org/webpage/oracle-l Received on Sat Dec 20 2014 - 07:44:59 CET

This message: [ Message body ]
Next message: Maureen English: "Re: ORA-7445 and system completely unavailable"
Previous message: Seth Miller: "Re: ORA-7445 and system completely unavailable"
Next in thread: Sreejith Nair: "Re: Recovery with three days old backup"
Maybe reply: Sreejith Nair: "Re: Recovery with three days old backup"
Maybe reply: Seth Miller: "Re: Recovery with three days old backup"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message