Thursday, May 01, 2008

RMAN Catalog

CONNECT catalog Database:

$sqlplus / as sysdba

SQL> create tablespace TBS_RMAN datafile '+DATA' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;

SQL> create user rman identified by rman default tablespace TBS_RMAN ;

User created.

SQL> alter user rman quota unlimited on TBS_RMAN;

User altered.

SQL> grant connect, resource, recovery_catalog_owner to rman;

Grant succeeded.


Create catalog on TBS_RMAN tablespace:

$rman catalog rman/rman@catalog

RMAN> create catalog tablespace 'TBS_RMAN';

recovery catalog created


Register Database to Catalog:

$rman catalog rman/rman@catalog target /
RMAN> register database ;

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


...

1 comment:

Patrick said...

Good one...P-