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!

Who is Participating?
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.
HuaMin ChenSystem 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.

skahlert2010Author Commented:
Thank you slightwv for that excellent and short explanation!

I appreciate it!

Best regards,

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.