OraFAQ Forum: Backup & Recovery » complete recovery through rman

Home » RDBMS Server » Backup & Recovery » complete recovery through rman (oracle 9i ) (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

complete recovery through rman [message #380742]

Tue, 13 January 2009 03:25

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

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

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

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

Michel Cadot
Messages: 68648
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 03 02:56:23 CDT 2024