Members   Search   Help    Register    Login   Home
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: 28
Registered: October 2008
Location: Mumbai
Junior 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: 29419
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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: Mon Nov 30 23:31:20 CST 2009

Total time taken to generate the page: 0.20916 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.