Home » RDBMS Server » Backup & Recovery » how to restore datafile from multiple backup pieces (oracle 10g)
how to restore datafile from multiple backup pieces [message #428052] Tue, 27 October 2009 00:44 Go to next message
gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai
Member
Hi,

In RMAN, i have bacukp of last 3 days that i confirmed by using:
RMAN> list backup of datafile 5;

Now suppose i want 2 days before table data that reside in that datafile 5, how can i approach.

Can i fire command like :
RMAN> recover datafile 5 from tag='abcd';

Thanks

Report message to a moderator

Re: how to restore datafile from multiple backup pieces [message #428055 is a reply to message #428052] Tue, 27 October 2009 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You cannot have a inline file that is not at the same that the other ones.
If you want to recover a table you have to use to create another database with your backup.

Regards
Michel

Report message to a moderator

Re: how to restore datafile from multiple backup pieces [message #428975 is a reply to message #428052] Sat, 31 October 2009 05:50 Go to previous message
gkl0818
Messages: 2
Registered: September 2009
Junior Member
NO,but i think Point-In-Time Recovery will meet you

Report message to a moderator

Previous Topic: RMAN convert used for user managed backup
Next Topic: Recovery from Previous Backups(RMAN)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 12 08:24:36 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.