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 re-creating the target control file to rebuild the RMAN repository
C.
by using the RECOVER CATALOG command in RMAN
D.
by starting up the database again
E.
by using the CATALOG command of RMAN
Answer E.
Cataloging User-Managed Datafile Copies
Use the CATALOG command to propagate information about user-managed (image) copies to the RMAN repository. After the files are cataloged, you can (then) run LIST or query V$BACKUP_FILES to confirm.
To create and catalog a user-managed (image) 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; — necessary if the database is open and the datafiles are online while the backup is in progress
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’; — to catalog the datafile image copy
hope this helps….