Difference between using backup controlfile and until cancel

1. recover database using backup controlfile

2. recover database until cancel

3. recover database using backup controlfile until cancel;

4. recover database until cancel using backup controlfile;

Differences:

1. If the current control file is lost, use the control file in the cold backup to restore it. It is used to tell Oracle not to use the scn in controlfile as the recovery end point;

2. If current/active redo is lost. Specify the end point manually.

3. If the current controlfile is lost and both current and active redo are lost, the archive log will be automatically applied first to achieve maximum recovery;

4. If the current controlfile is lost and both current and active redo are lost, use the scn in the old redo as the recovery endpoint. Because no application archives logs, all data will be lost.