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

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Simply put them back on disk and recatalog them with RMAN CATALOG command.

Regards
Michel

Report message to a moderator

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: 1736
Registered: December 2005
Location: NJ
Senior Member

As per Mr Michel, Use

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


- Babu

Report message to a moderator

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

Report message to a moderator

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!

Report message to a moderator

Previous Topic: Database could not open
Next Topic: Archive logs too big in size
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 20:52:17 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.