Home » RDBMS Server » Backup & Recovery » ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below [message #341314] Mon, 18 August 2008 05:55 Go to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
I am using Oracle 10.2.0.2 Standard edition on Oracle Enterprise Linux 4.1.1.

I was trying to roll foward a database at the DR site using an older snapshot(control file and data file) taken at the Live site..

So the control files and the data files are in synch and they are a couple of hours older and I have the archived logs which are up-to date.
Both the backups were snapshots taken at the Live site and the archived log snapshot was taken every half an hour and the datafile and controlfile snapshots were taken every 2 hours.

I tried rolling foward the database using the following commands but the recovery was not successful.

oracle@itour-db3:~:$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Aug 18 10:59:20 2008

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup mount  
ORACLE instance started.

Total System Global Area 1543503872 bytes
Fixed Size                  2071384 bytes
Variable Size             469763240 bytes
Database Buffers         1056964608 bytes
Redo Buffers               14704640 bytes
Database mounted.
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 23048113 generated at 08/13/2008 12:43:58 needed for thread 1
ORA-00289: suggestion : +DG_ARCH
ORA-00280: change 23048113 for thread 1 is in sequence #196


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
+DG_ARCH/BDGLIVE/ARCHIVELOG/2008_08_16/thread_1_seq_196.609.662940039
ORA-00279: change 23048113 generated at 08/13/2008 12:36:19 needed for thread 2
ORA-00289: suggestion : +DG_ARCH
ORA-00280: change 23048113 for thread 2 is in sequence #13


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
+DG_ARCH/BDGLIVE/ARCHIVELOG/2008_08_17/thread_2_seq_13.610.663019223
ORA-00279: change 23302599 generated at 08/16/2008 22:00:38 needed for thread 1
ORA-00289: suggestion : +DG_ARCH
ORA-00280: change 23302599 for thread 1 is in sequence #197
ORA-00278: log file
'+DG_ARCH/BDGLIVE/ARCHIVELOG/2008_08_16/thread_1_seq_196.609.662940039' no
longer needed for this recovery


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: '+DG_DATA/bdglive/system01.dbf'


ORA-01112: media recovery not started

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: '+DG_DATA/bdglive/system01.dbf'



Let me know what needs to be done?
Re: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below [message #341341 is a reply to message #341314] Mon, 18 August 2008 07:32 Go to previous messageGo to next message
icdb023
Messages: 2
Registered: August 2008
Junior Member
You will need to apply more logfiles before the database becomes consistent; you cannot "open resetlogs" a database before all datafiles are consistent with each other in terms of SCN's

Hans
Re: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below [message #341342 is a reply to message #341314] Mon, 18 August 2008 07:33 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Apply more redolog to sync with system datafile.

Did you switch last redolog after backup was taken.
Previous Topic: Backup of Oracle Portal
Next Topic: Startup Failing
Goto Forum:
  


Current Time: Sun Dec 11 05:58:36 CST 2016

Total time taken to generate the page: 0.09107 seconds