Home » RDBMS Server » Backup & Recovery » restore rman backup 10 days ago (merged 5) (AIX6 / Oracle 10.2)
restore rman backup 10 days ago (merged 5) [message #444669] Tue, 23 February 2010 07:38 Go to next message
ijsselg
Messages: 13
Registered: April 2005
Location: Netherlands
Junior Member
Hi,

In my ksh script, retention policy is set to 'redundancy 1'. Every night we take a rman backup. Obsolete backups are deleted after running backupscript with this command 'delete noprompt obsolete;'.

Restoring or recovering databases from yesterday is ok. Now my problem: how to restore/recover a database of 10 days ago, or maybe 10 month ago? Alle backupfiles, archives are on tape backup.

Gerard
Re: restore rman backup 10 days ago [message #444679 is a reply to message #444669] Tue, 23 February 2010 08:06 Go to previous messageGo to next message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Simply put them back on disk and recatalog them with RMAN CATALOG command.

Regards
Michel
Re: restore rman backup 10 days ago [message #444702 is a reply to message #444679] Tue, 23 February 2010 10:21 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


As per Mr Michel, Use

CATALOG BACKUPPIECE '?/oradata/01dmsbj4_1_1.bcp';


- Babu
Re: restore rman backup 10 days ago (merged 5) [message #444768 is a reply to message #444669] Wed, 24 February 2010 01:15 Go to previous messageGo to next message
ijsselg
Messages: 13
Registered: April 2005
Location: Netherlands
Junior Member
I'll try it. Thanks!! Smile
Re: restore rman backup 10 days ago (merged 5) [message #444835 is a reply to message #444768] Wed, 24 February 2010 07:45 Go to previous message
ijsselg
Messages: 13
Registered: April 2005
Location: Netherlands
Junior Member
Laughing It works! Thanks again!
Previous Topic: Database could not open
Next Topic: Archive logs too big in size
Goto Forum:
  


Current Time: Thu Sep 29 15:59:36 CDT 2016

Total time taken to generate the page: 0.07127 seconds