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

Report message to a moderator

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: 68786
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
RMAN> restore tablespace X;
RMAN> recover tablespace X;

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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: 68786
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Oct 03 16:26:10 CDT 2026
.:: Forum Home :: Wiki Home :: Contact :: Privacy ::.