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!