It is a holiday and no transactions are being performed on the database. You took a consistent
backup of your database without using Recovery Manager (RMAN). How would you make use of this
consistent backup in RMAN?
A.
cannot be used in RMAN
B.
by starting up the database again
C.
by using the CATALOG command of RMAN
D.
by using the RECOVER CATALOG command in RMAN
E.
by re-creating the target control file to rebuild the RMAN repository
Explanation:
RMAN never recognize non RMAN backup
The answer is C
The explanation given here is incorrect, which is unfortunate. Should’nt one do some checking before entering an “Explanation”?
Check this out…..(source oracle docs http://docs.oracle.com/cd/E25054_01/backup.1111/e10642/rcmmaint.htm)
Cataloging User-Managed Datafile Copies
Use the CATALOG command to propagate information about user-managed copies to the RMAN repository. After the files are cataloged, you can run LIST or query V$BACKUP_FILES to confirm.
To create and catalog a user-managed copy of a datafile:
Make a datafile copy with an operating system utility. ALTER TABLESPACE BEGIN/END BACKUP is necessary if the database is open and the datafiles are online while the backup is in progress. This example backs up an online datafile, using the SQL*Plus HOST command to issue an operating system command.
SQL> ALTER TABLESPACE users BEGIN BACKUP;
SQL> host cp $ORACLE_HOME/oradata/trgt/users01.dbf /tmp/users01.dbf;
SQL> ALTER TABLESPACE users END BACKUP;
Start RMAN and connect to a target database and recovery catalog.
Run the CATALOG command.
For example, enter the following command to catalog a user-managed datafile copy:
CATALOG DATAFILECOPY ‘/tmp/users01.dbf’;
Peace to all
A consistent backup occurs when the database is in a consistent state.
A database is in a consistent state after being shut down with the SHUTDOWN NORMAL, SHUTDOWN IMMEDIATE, or SHUTDOWN TRANSACTIONAL commands.
A consistent shutdown guarantees that all redo has been applied to the datafiles. If you mount the database and make a backup at this point, then you can restore the database backup later and open it without performing media recovery.
A backup set is an RMAN-specific proprietary format, whereas an image copy is a bit-for-bit copy of a file. By default, RMAN creates backup sets.
If RMAN cannot back up some certain files, then we use some non-RMAN backup solution for any files not in the preceding list.