Recovery Manager Command Syntax, 30 of 50

register

Syntax

Purpose

To register the target database in the recovery catalog so that RMAN can access it. RMAN obtains all information it needs to register the target database from the target database itself.

Note:
If you perform a RESETLOGS operation on a database and later register it in the recovery catalog, the catalog records the DB_NAME for the old incarnations as UNKNOWN because the old incarnations were not previously registered. You should not try to remove these records.

Requirements

Execute this command only at the RMAN prompt.
You can only register a database once in a given recovery catalog.
You must be using a recovery catalog.
The target database must be mounted.

The register database command fails when RMAN detects duplicate database identifiers. This situation can arise when databases are created by copying files from an existing database rather than using the duplicate command.

If this failure occurs, you can create a second recovery catalog in another user's schema by executing create catalog (see "createCatalog") using a different user id. Then, register the database with the duplicate database identifier into the newly created recovery catalog in the new schema.

Note:
If you are using RMAN with different target databases that have the same database name and identifier, be extremely careful to always specify the correct recovery catalog schema when invoking Recovery Manager.

Examples

Registering a Database

This example registers the target database, catalogs an existing datafile copy, then opens the database for use:

connect target / catalog rman/rman@rcat;
startup mount;
register database;
catalog datafilecopy '/vobs/oracle/dbs/foo.f';
sql 'alter database open';