OraFAQ Forum: Backup & Recovery » complete recovery

Home » RDBMS Server » Backup & Recovery » complete recovery

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

complete recovery [message #164056]

Tue, 21 March 2006 09:25

vijaychauhan
Messages: 106
Registered: December 2005

Senior Member

I have a oracle 9i database on windows 2000, I have the database in noarchivelog mode, I shut down the database and took the whole database backup, and then started the database. Now my database crashed, but the redo logs were not overwriteen, now I, want to make complete recovery. I restored the datafiles, now how can I, apply the redo logs?

Report message to a moderator

Re: complete recovery [message #164128 is a reply to message #164056]

Tue, 21 March 2006 23:01

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

If you have restored correctly and as you said "redo logs are not overwritten" then Oracle will apply the redo logs automatically.

cheers

Report message to a moderator

Re: complete recovery [message #164259 is a reply to message #164128]

Wed, 22 March 2006 11:00

vijaychauhan
Messages: 106
Registered: December 2005

Senior Member

You mean to say that after restoration, I give the command, recover database until cancel and then open it with, alter database open and it will work?

Report message to a moderator