Catalog Start with

337. You has lost all your RMAN backup set pieces due to a disk failure. Unfortunately.

Automated Cross-check script that also does a delete expired backupset command. You are restored all

The backup set pieces from tape. What command would your use to get those backup set pieces

Registered in the recovery catalog and the control file of the database again?

A. Register Database

B. Recover Catalog

C. Load Backupset

D. Synch metadata

E. Catalog start with

Answer:e

The answer resolves:

Reference: http://blog.csdn.net/rlhua/article/details/13169205

You can use the catalog command to recover backup fragments and control file copies from tape.

Catalog start with: Use this command to re-include all available backups in the directory.

The Atalog Ccan be used to catalog existing backup files that are no longer listed in the control file.

61 This allows RMAN to use these files during a restore operation.

61 Use the Catalog command to add the following types of backup files to the recovery directory:

– Control File Copy

– Copy of the data file

– Backup fragments

– Archive redo log files

If you have additional control file copies, data file copies, backup fragments, or archived redo log files on the disk, you can use the Catalog command to include them in the recovery directory. If some backups are already purged from the control file because of time, they can be included in the directory so that Rman uses them during the restore operation.

START WIth option

Use the start WIth option to include all files found in the specified directory tree in the directory. Provides a prefix for representing a directory and a possible file prefix for lookups. You cannot use wildcards and provide only one prefix.

All types of backup files found in the specified directory and subdirectories are listed in the directory. Assume that there are multiple backup files in the/tmp/arCh_logs directory. The following command lists all files in the directory:

Rman> catalog START WITH '/tmp/arCh_logs/';

Suppose you want to include only files in the/tmp directory that begin with the string bset. The following commands are available for this purpose:

rman> Catalog START WITH '/tmp/bset ';

This command also lists all backup files found in the directory tree beginning with/tmp/bset.

C The Atalog command can be used without connecting to the recovery directory.

Catalog Start with