Topic : Recovery Catalog

What is the difference between using recovery catalog and control file?


Answer :

When new incarnation happens; the old backup information in control file will be lost. It will be preserved in recovery catalog.
In recovery catalog we can store scripts.
Recovery catalog is central and can have information of many databases.

Show Answer Discuss

Can we use same target database as catalog?


Answer :

No; The recovery catalog should not reside in the target database (database should be backed up); because the database can?t be recovered in the mounted state.

Show Answer Discuss

How many times does oracle ask before dropping a catalog?


Answer :

The default is two times one for the actual command; the other for confirmation.

Show Answer Discuss

How to put manual/user-managed backup in RMAN (recovery catalog)?


Answer :

By using catalog command.
RMAN> CATALOG START WITH '/tmp/backup.ctl';

Show Answer Discuss

In catalog database; if some of the blocks are corrupted due to system crash; How will you recover?


Answer :

Using RMAN BLOCK RECOVER command
Steps to be followed:
1) Create connection string at catalog database.
2) At catalog database create one new user or use existing user and give that user a recovery_catalog_owner privilege.
3) Login into RMAN with connection string
a) export ORACLE_SID
b) rman target catalog @connection string
4) rman> create catalog;
5) register database;

Show Answer Discuss