We have added search box. Key in SAP issue keyword to search
Home
About
Site Archive
SAP Chat
Contact
TopBottom

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

Re: [sap-basis] Not able to recover QAS from PRD offline snapshot

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

0 Comments

Posted by rptiwari (Sr. Executive)
on Nov 27 at 9:29 AM 		Mark this reply as helpfulMark as helpful
run this from sql prompt


sql> STARTUP MOUNT

sql> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

Path of generated fie is /oracle/<SID>/saptrace/usertrace

sql> RECOVER DATABASE UNTIL CANCEL


Thanks
Rajesh Tiwari

---------------Original Message---------------
From: Snowy
Sent: Friday, November 26, 2010 8:23 PM
Subject: Not able to recover QAS from PRD offline snapshot

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".
__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Related Content
Most Popular White Papers
In the Spotlight
Attend IBM Webcasts, Engage Peers, and More! Visit IBM Smart Products Virtual Briefing Center
_.____.__

 

0 comments:

Post a Comment

Post a Comment

Subscribe to: Post Comments (Atom)

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