Home » RDBMS Server » Backup & Recovery » recover database until cancel
recover database until cancel [message #573458] Fri, 28 December 2012 13:19 Go to next message
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 #573459 is a reply to message #573458] Fri, 28 December 2012 13:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Fri, 28 December 2012 20:18
Database Backup and Recovery Basics
...


Database Backup and Recovery Advanced User's Guide

Regards
Michel
Re: recover database until cancel [message #575949 is a reply to message #573458] Tue, 29 January 2013 13:12 Go to previous messageGo to next message
robert0380
Messages: 2
Registered: January 2013
Junior Member
maninderkrb wrote on Fri, 28 December 2012 14:19
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?



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

Re: recover database until cancel [message #575951 is a reply to message #575949] Tue, 29 January 2013 13:32 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
He above all should read the documentation.

Regards
Michel
Previous Topic: Need help with rman backup script
Next Topic: OS Backup
Goto Forum:
  


Current Time: Thu Mar 28 09:37:01 CDT 2024