OraFAQ Forum: Backup & Recovery » HOT BACKUP RESTORE

Home » RDBMS Server » Backup & Recovery » HOT BACKUP RESTORE

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

HOT BACKUP RESTORE [message #265913]

Fri, 07 September 2007 17:33

harry07
Messages: 61
Registered: June 2007
Location: now york

Member

Hi Forum

I have to restore & recover a database from hot backup in oracle 9.2.0.7 on solaris 5.9. Can anyone please tell the steps to do that.

Thanks a lot in advance.

Report message to a moderator

Re: HOT BACKUP RESTORE [message #265919 is a reply to message #265913]

Fri, 07 September 2007 20:19

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

if you have controlfiles.

rman target/
startup mount;
run
{
restore datebase;
recover database;
};

if dont have controlfiles then

startup nomount;
restore controlfile from autobackup or backuppiece 'path';
alter database mount;
and same step as above

Report message to a moderator

Re: HOT BACKUP RESTORE [message #265929 is a reply to message #265913]

Sat, 08 September 2007 00:24

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

At first need to know how you took backup?

Rman or user -managed? Based on that take necessary steps.

Report message to a moderator

Previous Topic:	Backup doubt (archivelogs)
Next Topic:	Recovery Issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 02:29:16 CDT 2024