Register Database in RMAN Catalog
                                                 Last update (2013-03-29 09:36:52)
                                                                                                                   Date added (2008-09-11 11:39:06)

Summary
Here are the simplest steps to register a database in an existing RMAN catalog database.

1. First you must put an alias entry in the $TNS_ADMIN/tnsnames.ora file for the RMAN database. For example if the RMAN catalog database runs on the bserver host, port 1521 and SID=RMAN put the following in your tnsnames.ora
RMAN =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = bserver)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = RMAN)
    )
  )
2. Check that you have setup the path of rman executables in the $PATH
export PATH=$ORACLE_HOME/bin:$PATH:$ORACLE_HOME/OPatch:/bin
3. From the command prompt execute:
$rman target / catalog rman/*****@RMAN
in case you get rman: can't open target then make sure that $ORACLE_HOME/bin is at the very beginning of $PATH in your environment or give the command with the full path to the rman executable
$ORACLE_HOME/bin/rman target / catalog rman/*****@RMAN
4. Register the database with the command:
RMAN>register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN> 
Reviews
Categories
Oracle DBA-> (147)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (19)
  Database files (6)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Exp-Imp Datapump (6)
  Jobs (2)
  Mview (2)
  Networking (3)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles - Grants (2)
  Rollback - Undo (8)
  Segments (3)
  Sequences (2)
  Sessions (14)
  SGA (14)
  Tables (10)
  Tablespaces (10)
  Temp (4)
  Toad (5)
  Transactions (1)
  Upgrade (2)
  Users (3)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)
Filters
Search