Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 882
  • Last Modified:

Recover database vs. recover database until cancel

Dear experts,

could you please explain the difference between the two oracle commands "recover database" and "recover database until cancel"?

As far as I know, "recover database" applies all archive-logs that are registered in the database. If they are missing for some reason, the recovery will finish incomplete. Applying "recover database until cancel" in turn is applying all archivelogs and if not found will prompt for the archivelog destination to guarantee a complete media recovery.

Are these assumptions true?

Thanks for your explanations!

  • 2
1 Solution
HuaMinChenBusiness AnalystCommented:
skahlert2010Author Commented:
Still don't know the axact difference but I suppose my suggestion is correct after having had a look at Burleson's site.

slightwv (䄆 Netminder) Commented:
If you are missing archived redo logs recovery will be incomplete with either recovery.  Its note really 'failed'.  Just incomplete.

Recover database brings the database back to the point of failure.

Recover until cancel brings the database back to the point you cancel it which will be prior to the point of failure.
skahlert2010Author Commented:
Thank you slightwv for that excellent and short explanation!

I appreciate it!

Best regards,


Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now