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.

Report message to a moderator

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: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes and even with RMAN.

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The same way than other recover.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 16:25:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.