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
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: 63804
Registered: March 2007
Location: Nanterre, France, http://...
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
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
Previous Topic: RMAN convert used for user managed backup
Next Topic: Recovery from Previous Backups(RMAN)
Goto Forum:
  


Current Time: Mon Sep 26 17:56:07 CDT 2016

Total time taken to generate the page: 0.05478 seconds