RE: Help in Recovery

Check your alert log for the time frame when the backup was running. If you cut archive logs during the time frame the backup ran (start until finish inclusive), you must have them to recover the database. I don't believe the database will open if you cut logs during the hot backup and don't have them for the recovery. (What happened with your archive logs?)  

If you have not done anything in this database since your backup, and no new archive logs were cut, you may get lucky and be able to use your on-line redo logs as the logs that it wants for the recovery.    

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nagaraj S Sent: Saturday, October 18, 2008 2:05 PM To: oracle-l_at_freelists.org
Subject: Help in Recovery  

I need to restore the QC hot backup to development database. I restored all the datafiles that were backed up in hotbackup. But i could able to restore the archive files that were backed during my hot backup. Once the database has been restored in development server,i have recreated control file and brought the database in mount stage. When i issue reset logs it gives me the below error. Also i don't have any archive files.. it is possible to open my database. Kindly help me

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/u01/oracle/data01/system00.dbf'

Also when i issue recover database command it ask me the below archice file

SQL> recover database using backup controlfile until cancel; ORA-00279: change 5402817860687 generated at 10/04/2008 20:14:22 needed for
thread 1
ORA-00289: suggestion : /u01/oracle/arch/archGAYA47771664133887.log ORA-00280: change 5402817860687 for thread 1 is in sequence #4777

Specify log: {<RET>=suggested | filename | AUTO | CANCEL} cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/u01/oracle/data01/system00.dbf'  

Regards,

Nagaraj

--
http://www.freelists.org/webpage/oracle-l