Summary of rman catalog Configuration

Rman catalog configuration brief note Server Configuration:

[sql] SQL> create tablespace tbs_rman datafile 'H:\oradata\test\tbs_rman.dbf' size 20m autoextend on;     Tablespace created     SQL> create user rman identified by oracle default tablespace tbs_rman temporary tablespace temp;     User created     SQL> alter user rman quota unlimited on tbs_rman;     User altered     SQL> grant recovery_catalog_owner to rman;     Grant succeeded  

 

Client Configuration:

[sql] # tnsname.ora  rmandb =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.128.1)(PORT = 1521))      (CONNECT_DATA =        (SERVER = DEDICATED)        (SERVICE_NAME = test)       )     )  

 

Client Login:

[sql] [oracle@rhel5 admin]$ rman target / catalog rman/oracle@rmandb    Recovery Manager: Release 10.2.0.1.0 - Production on Tue Aug 6 14:42:32 2013    Copyright (c) 1982, 2005, Oracle.  All rights reserved.    connected to target database: ORCL (DBID=1349938074)  connected to recovery catalog database    RMAN>