'Mount' vs 'Mount Standby' Database

1)

startup_clauses

The startup_clauses let you mount and open the database so that it is accessible to users.

MOUNT Clause

Use the MOUNT clause to mount the database. Do not use this clause when the database is already mounted.

MOUNT STANDBY DATABASE

You can specify MOUNT STANDBY DATABASE to mount a physical standby database. The keywords STANDBY DATABASE are optional, because Oracle Database determines automatically whether the database to be mounted is a primary or standby database. As soon as this statement executes, the standby instance can receive redo data from the primary instance.

startup mount is the same as startup nomount; alter database mount.

2) 'Recover database until cancel using backup controlfile'

Begin cancel-based recovery by issuing the following command:

RECOVER DATABASE UNTIL CANCEL


If you are using a backup control file with this incomplete recovery (Like , re-creating controlfile), then specify the USING BACKUP CONTROLFILE option in the RECOVER command.

RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE