Help in Recovery

From: Nagaraj S <nagaraj.chk_at_gmail.com>
Date: Sat, 18 Oct 2008 23:35:04 +0530
Message-ID: <e921f8570810181105u326569ccp9472854a465fd06@mail.gmail.com>


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
Received on Sat Oct 18 2008 - 13:05:04 CDT

Original text of this message