Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: database recovery help

Re: database recovery help

From: Paul Drake <>
Date: Tue, 6 Mar 2007 09:04:50 -0500
Message-ID: <>

On 3/6/07, Godwin vincent <> wrote:
> Hi all,
> Something went wrong and now i have corruption in my database and
> it wont start at all. All I have is a backup which is 5 days old. As part of
> the backup, i have a hot backup of all the datafiles, control file and
> archive redo log files, which are all 5 days old. Now, i want to recover my
> database using this backup (even though i loose a week worth of data). I
> have never done a recovery ( either user-managed or using RMAN) and would
> like to request some help in this regard. The database is able to mount but
> is is not able to open, so im assuming that there is no problem with the
> control file. Im running Oracle 8 on Solaris. So, from my understanding, i
> have to perform a restore and recovery and to do that will the following
> work? and is this the standard way of restore and recovery
> 1. Restore the datafiles backup.
> cp /u08/backup/datafilebackup1.dbf /u02/oradata/DB1/datafile1.dbf
> cp /u08/backup/datafilebackup2.dbf /u04/oradata/DB1/datafile2.dbf
> ............... restore all the datafiles backups to the original
> datafile location..........
> 2. startup mount
> SQL> startup mount;
> 3. Recover
> SQL> recover database until cancel;

So you did not replace the existing controlfiles (aka current controlfiles) with a backup controlfile created during the creation of the hot backup set?

I would have used

SQL> recover database until cancel using backup controlfile;

> When prompted give the path and file name of the archived
> redo log to apply until it gives
> "Media Recovery Complete", if it still asks for archived logs
> when there are no archive
> logs left to give, then give the location of the latest
> active online redo log file.

That's because the current controlfile wants to have the current online redo log applied for complete recovery. You were attempting incomplete recovery, but used the current controlfile and did not instruct oracle during recovery to perform incomplete recovery.

Sorry if this is not clear, I'm not yet caffeinated.


> 4. open the database
> SQL> aler database open resetlogs;
> Is the above process standard way of recovering a database with the backup?
> 1.Im still not clear on this control file, In this case, do i have to
> restore the 5 days old control file to recover the database? or can i use
> the current control file ( because there is no problem with the current
> control file as the database is mounting)?
> 2. Where does the RECOVER DATABASE UNTIL CANCEL command look for archived
> redo log files by default? can i restore the backup arch logs to the archive
> log destination?
> Any information would be of a great help.
> Thanks,
> Godwin.

-- ALTER SESSION SET EVENTS 'immediate trace name hanganalyze level 4';
Received on Tue Mar 06 2007 - 08:04:50 CST

Original text of this message