RE: Help in Recovery
- From: "Johnson, William L (TEIS)" <WLJohnson@xxxxxxxxxxxxxxxxxxx>
- To: <nagaraj.chk@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 18 Oct 2008 14:14:11 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Nagaraj S
Sent: Saturday, October 18, 2008 2:05 PM
To: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
