Shulou(Shulou.com)06/01 Report--

337.You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have an

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

The backup set pieces from tape. What command would you 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

Answer analysis:

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

To recover backup fragments and control copies of files from tape, you can use the CATALOG command.

Catalog start with: use this command to re-catalog all available backups.

61 CATALOG can be used to catalog existing backup files that are no longer listed in the control file.

In this way, RMAN can use these files during the restore operation.

61 use the CATALOG command to add the following types of backup files to the recovery directory:

-Control copy of the file

-copy of the data file

-backup fragments

-Archive redo log files

If there are copies of other control files, data files, backup fragments, or archive redo log files on disk, you can use the CATALOG command to list them in the recovery directory. If some backups are cleared from the control file too long ago, they can be cataloged so that RMAN can use them during a 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 that represents a directory and possible file prefixes for lookup. Wildcards cannot be used, only a prefix is provided.

All types of backup files found in the specified directory and subdirectories are included in the directory. Suppose you have 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 only want to include files in the / tmp directory whose names begin with the string bset. The following commands do this:

RMAN > CATALOG START WITH'/ tmp/bset'

This command also catalogs all backup files found in the directory tree that starts with / tmp/bset.

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.