We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-basis] Not able to recover QAS from PRD online backup

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Posted by JHFVLK
on Mar 21 at 10:19 PM
@David : It was a online_split backup, not a consistent online backup.

@Snowy : We are not able to apply redologs only, when we are giving this command :
Recover database using backup controlfile until cancel;
Its asking for very old redolog which has nothing to do with the restored backup.

I guess latest SCN number was not updated in the data files.

Anything could be done in this case?

---------------Original Message---------------
From: JHFVLK
Sent: Monday, March 21, 2011 6:47 AM
Subject: Not able to recover QAS from PRD online backup

Hi All,

We are refreshing our QAS from PRD.

We have restored the PRD database to QAS, using an online backup.

After that, we created control file and brought the database in mount state.

But, when we trying to recover the database, its giving follwoing error :

ORA-00308: cannot open archived log
'/saparch/RC4/PC4arch1_290393_614926552.dbf'
ORA-27037: unable to obtain file status
HP-UX Error: 2: No such file or directory
Additional information: 3

It's craving for some redolog file, which has nothing to do with the backup, used for restore.
All the logs, generated during the online backup, have been placed in the respective folder i.e. /saparch/RC4/.

Why is it asking for the some other log file?


Thanks

__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
Most Popular White Papers

In the Spotlight
Get Fast, Reliable Enterprise-Class Storage. Learn About IBM Storwize v7000
_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language