recover database until cancel [message #573458] |
Fri, 28 December 2012 13:19 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/d12cd5a0688c38a7bb8f253b0611fdb2?s=64&d=mm&r=g) |
maninderkrb
Messages: 41 Registered: August 2012 Location: India
|
Member |
|
|
our dbs are in noarchive log mode
sometimes when we restart the db.
it needs recovery
my dba fires recover database until cancel
and then fire cancel .
what actualy happend with it?
|
|
|
|
Re: recover database until cancel [message #575949 is a reply to message #573458] |
Tue, 29 January 2013 13:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/c3615a14bf7b5da1bd870434639cf00f?s=64&d=mm&r=g) |
robert0380
Messages: 2 Registered: January 2013
|
Junior Member |
|
|
maninderkrb wrote on Fri, 28 December 2012 14:19our dbs are in noarchive log mode
sometimes when we restart the db.
it needs recovery
my dba fires recover database until cancel
and then fire cancel .
what actualy happend with it?
You should try to figure out why you're needing to recover after a shutdown. Are you shutting down the database cleanly? All you're doing with a recover until cancel followed by a "cancel" is mimicking an incomplete recovery which allows you to reset the logs and open the database. (alter database open resetlogs).
[Updated on: Tue, 29 January 2013 13:18] Report message to a moderator
|
|
|
|