| ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below [message #341314] |
Mon, 18 August 2008 05:55  |
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?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
