OraFAQ Forum: Backup & Recovery » Recovery through RMAN 10g

Home » RDBMS Server » Backup & Recovery » Recovery through RMAN 10g (Oracle 10g, AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Recovery through RMAN 10g [message #584087]

Wed, 08 May 2013 09:46

TRaj
Messages: 82
Registered: September 2006

Member

Hi,

Is it possible to recover files from backup tapes which are gone obsolete (as per retention policy)?

Thanks.

Report message to a moderator

Re: Recovery through RMAN 10g [message #584088 is a reply to message #584087]

Wed, 08 May 2013 10:05

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

Yes if you have the complete physical files required for the restore.

[Updated on: Wed, 08 May 2013 11:58] by Moderator

Report message to a moderator

Re: Recovery through RMAN 10g [message #584090 is a reply to message #584088]

Wed, 08 May 2013 10:18

TRaj
Messages: 82
Registered: September 2006

Member

Appreciate if you can share the steps for the same.

Thanks.

Report message to a moderator

Re: Recovery through RMAN 10g [message #584095 is a reply to message #584090]

Wed, 08 May 2013 11:39

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

Use the "CATALOG" command to re-catalog the backup files and then follow the recovery instructions in the fine
Oracle® Database Backup and Recovery Advanced User's Guide.

[Updated on: Wed, 08 May 2013 11:58] by Moderator

Report message to a moderator

Re: Recovery through RMAN 10g [message #584097 is a reply to message #584095]

Wed, 08 May 2013 11:50

TRaj
Messages: 82
Registered: September 2006

Member

Thanks a lot!

Report message to a moderator

Previous Topic:	Delete Obsolete Files backed up to Tapes using RMAN
Next Topic:	Restore & Recover controlfile after its deletion from a Backup Set

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 23 21:59:17 CDT 2023