Help in Recovery
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-lReceived on Sat Oct 18 2008 - 13:05:04 CDT