Home » RDBMS Server » Backup & Recovery » Recover db manually (oracle,10.2.0.4,linux)
Recover db manually [message #431740] Thu, 19 November 2009 06:12 Go to next message
replicated
Messages: 31
Registered: July 2009
Member
hi

Our daily RMAN refresh from Prod to UAT failed.It was in the last stages of recovering the db,but couldt find some archivelogs files,as the backup peice was missing.Is it possible that if i transfer the archivelogs required for recovery from PROD to UAT manually and then recover the db frm sql prompt.



Re: Recover db manually [message #431744 is a reply to message #431740] Thu, 19 November 2009 06:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Yes and even with RMAN.

Regards
Michel
Re: Recover db manually [message #431765 is a reply to message #431740] Thu, 19 November 2009 06:50 Go to previous messageGo to next message
replicated
Messages: 31
Registered: July 2009
Member
I copied manually the archivelogs over to test ..But while doing
recovery it kept asking for more archivelogs..I also did cancel based recovery.But while opening db using resetlogs.it still wanted more archives to recover system datafile.

and how do i do that with RMAN
Re: Recover db manually [message #431772 is a reply to message #431765] Thu, 19 November 2009 07:10 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
The same way than other recover.

Regards
Michel
Previous Topic: message in alert.log
Next Topic: Control file backup using Rman? (merged 4)
Goto Forum:
  


Current Time: Fri Nov 22 01:32:55 CST 2024