Home » RDBMS Server » Backup & Recovery » complete recovery through rman (oracle 9i )  () 1 Vote
complete recovery through rman [message #380742] Tue, 13 January 2009 03:25 Go to next message
jatoi123
Messages: 2
Registered: January 2009
Location: rwp
Junior Member

I backed up my oracle 9i database at 7:00 A.M in the morning through rman

RMAN> backup database plus archivelog

At 5:30 P.M on the same day I lost one of my datafile (transaction) .

My system is already running in archive log mode and i have all the archived

redo logs intact till the last rman backup (7:00 A.M of the same day ).


Now i want to recover my database till 5:30 P.M. Is it possible,if so then please
tell me how i will apply the archived redo logs and on line redo logs.

Thanks in advance

Jatoi
Re: complete recovery through rman [message #380744 is a reply to message #380742] Tue, 13 January 2009 03:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
RMAN> restore tablespace X;
RMAN> recover tablespace X;

Regards
Michel

Re: complete recovery through rman [message #380745 is a reply to message #380744] Tue, 13 January 2009 03:45 Go to previous messageGo to next message
jatoi123
Messages: 2
Registered: January 2009
Location: rwp
Junior Member

but i want to recover the whole database rather tablespace
Re: complete recovery through rman [message #380748 is a reply to message #380745] Tue, 13 January 2009 03:53 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you want to restore the whole database if you just lose one datafile.
You can even use restore/recover on this single file.

You can use "restore/recover database", it does not matter, Oracle will only restore and recover what need to be restored and recovered, just it will have less work to do and take less time if you specify what it has to restore/recover.

Regards
Michel
Previous Topic: ORA-16032
Next Topic: Can't see my archived file.
Goto Forum:
  


Current Time: Thu Dec 08 12:06:32 CST 2016

Total time taken to generate the page: 0.08772 seconds