REGISTER

Syntax

Text description of the illustration register.gif

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.

See Also: Oracle9i Recovery Manager User's Guide, "CREATE CATALOG"

Restrictions and Usage Notes

• Execute this command only at the RMAN prompt.

• You must be connected to the target database and recovery catalog database.

• You can register multiple databases in the same recovery catalog, but the database identifiers of the databases must be unique.

• You can only register a database once in a given recovery catalog.

• The target database must be mounted or open.

• You should not register a standby database.

• The REGISTER DATABASE command fails when RMAN detects duplicate DBIDs. This situation can arise when databases are created by copying files from an existing database rather than by using the DUPLICATE command.

  If this failure occurs, then you can create a second recovery catalog in the same database but in another user's schema by executing CREATE CATALOG and 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 DBID, be careful to always specify the correct recovery catalog schema when invoking RMAN.

Example

Registering a Database: Example

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

% rman TARGET / CATALOG rman/rman@rcat
STARTUP MOUNT;
REGISTER DATABASE;
CATALOG DATAFILECOPY '/oracle/dbs/tbs_11.f';
ALTER DATABASE OPEN;