Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hi,
it looks like your database was not really OFFLINE when you backed it up... or your did not restore your files properly. check origlog/mirrlog date and time stamps. compare with data files date/time.
finally, I would gibe you the path to origlog* files 1 by 1 until you receive message "Media recovery complete".
| | | ---------------Original Message---------------
From: vishal_basis
Sent: Friday, November 26, 2010 6:00 PM
Subject: Not able to recover QAS from PRD offline snapshot
Hi,
We are trying to restore R/3 QAS system(DB refresh) from offline snapshot of R/3 PRD system. We are able to start the database in nomount and mount mode ,while opening database in OPEN mode it is asking for more redolog files for recovery to be consistent. We have applied few redolog files and it kept asking for more redolog files and we are not able to start the database in OPEN mode. Actually it should not ask for redolog files or recovery if we are doing it from offline snapshot. We use SNAPSHOT manager to take the backup of database.
We have performed the same steps on our BW systems and we were able to restore BW QAS from BW PRD offline snapshot. It has not asked for any redolog files to start the database. The only difference between R/3 and BW systems is R/3 is in clustered environment while BW is not clustered.
R/3 PRD system ; R/3 QAS system (R/3 4.7, Oracle 10.2 and Windows server 2003)
BW PRD system ; BW QAS system( BW 3.5 , Oracle 10.2 and Windows server 2003)
Why the system would ask for redo logs if we are using offline snapshot?
- problem with the cluster resources and database is not really shutdown properly
- problem with the snapshot of a cluster
The following is the R/3 QAS recover log. Any inputs would be appreciated.
SQL> startup;
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2067104 bytes
Variable Size 1090520416 bytes
Database Buffers 1040187392 bytes
Redo Buffers 14708736 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
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: 'G:\ORACLE\RQ2\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 1003472115 generated at 11/20/2010 13:30:29 needed for thread
1
ORA-00289: suggestion : K:\ORACLE\RQ2\ORAARCH\RQ2ARCH\1_32286_667603572.DB F
ORA-00280: change 1003472115 for thread 1 is in sequence #32286
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log
'K:\ORACLE\RQ2\ORAARCH\RQ2ARCH\1_32286_667603572.DB F'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-00308: cannot open archived log
'K:\ORACLE\RQ2\ORAARCH\RQ2ARCH\1_32286_667603572.DB F'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
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: 'G:\ORACLE\RQ2\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'
I have applied the required redolog files ,but it kept asking more redolog files. Actually it should not ask redolog files for offline snapshot restore.
Regards,
Vishal |
| __.____._ Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  Snowy
SAP Basis Enthusiast
Contributed 1,000 posts in a group to earn a Gold Achievement Related Content Most Popular White Papers
In the Spotlight  _.____.__ |
Mark as helpful
