Cancel-based RECOVERY is a user managed incomplete recovery where a user can apply the UNTIL CANCEL clause to perform recovery until the user manually cancels the recovery process. The process can be cancelled when the user is SURE that no more recovery is possible. Cancel-based recovery is PERFORMED when there is a requirement to recover up to a particular archived redo log file. It allows a user to control the recovery process because the user can provide names of archive log files to be used for recovery. Cancel-based recovery can be performed USING the following statement:
SQL>RECOVER DATABASE UNTIL CANCEL

Cancel-based recovery is a user managed incomplete recovery where a user can apply the UNTIL CANCEL clause to perform recovery until the user manually cancels the recovery process. The process can be cancelled when the user is sure that no more recovery is possible. Cancel-based recovery is performed when there is a requirement to recover up to a particular archived redo log file. It allows a user to control the recovery process because the user can provide names of archive log files to be used for recovery. Cancel-based recovery can be performed using the following statement:
SQL>RECOVER DATABASE UNTIL CANCEL