| 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?
|
|
|
|
| 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
|
|
|
|
|
|
| Re: complete recovery [message #164322 is a reply to message #164259] |
Wed, 22 March 2006 23:15 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
| vijaychauhan wrote on Wed, 22 March 2006 22:30 |
recover database until cancel and then open it with, alter database open and it will work?
|
Why Recover database until cancel ??
I believe Recover database is enough.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
