|Oracle® Database Backup and Recovery Reference
11g Release 2 (11.2)
Part Number E10643-03
See Also:Oracle Database SQL Language Reference for
DATABASEsyntax and semantics
Execute this command either within the braces of a
RUN command or at the RMAN prompt. The target instance must be started.
||Mounts the database without opening it. Issuing the command with this option is equivalent to the SQL statement
||Opens the database (see Example 2-13). When you open the database after
||Archives the current online redo log files (or up to the last redo record before redo corruption if corruption is found), clears the contents of the online redo log files, and resets the online redo log to log sequence 1. The RMAN command
If you use a recovery catalog, then RMAN issues an implicit
Example 2-13 Making a Consistent Database Backup
Assume that the database is open and you want to make a consistent backup of the whole database. This example shuts down the database consistently, mounts the database, makes a consistent whole database backup, and then opens the database.
SHUTDOWN IMMEDIATE; STARTUP MOUNT; BACKUP DATABASE PLUS ARCHIVELOG; # Now that the backup is complete, open the database. ALTER DATABASE OPEN;
Example 2-14 Mounting the Database After Restoring the Control File
This example restores the control file, mounts it, and performs recovery. Finally, the example resets the online redo log.
STARTUP FORCE NOMOUNT; RESTORE CONTROLFILE FROM AUTOBACKUP; ALTER DATABASE MOUNT; # You must run the RECOVER command after restoring a control file even if no # datafiles require recovery. RECOVER DEVICE TYPE DISK DATABASE; ALTER DATABASE OPEN RESETLOGS;