Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

Re: database recovery help

From: BN <>
Date: Tue, 6 Mar 2007 09:16:46 -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;
> 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.
> 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.


I think you should post the following info for better replies :

  1. Complete error message
  2. Oracle & OS Details, Verison, etc.,
  3. Size of the Database
Regards & Thanks

Received on Tue Mar 06 2007 - 08:16:46 CST

Original text of this message