Wednesday, September 24, 2008

How to create RMAN catalog in 10g

Create a rcat - recovery catalog database with database configuration assistant

C:\> sqlplus SYS/pass@rcat AS SYSDBA

SQL> CREATE SMALLFILE TABLESPACE catalog_tbs DATAFILE ‘C:\ORACLE\10.2\datafile\cat_tbs.dbf’ SIZE 100M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

SQL> CREATE USER rcat IDENTIFIED BY rcat DEFAULT TABLESPACE catalog_tbs QUOTA UNLIMITED ON catalog_tbs;

SQL> GRANT recovery_catalog_owner TO rcat;

SQL> Grant connect, resource to rcat;

SQL> exit

C:\> rman catalog rcat/rcat@rcat

RMAN> create catalog;

RMAN> exit

C:\>rman target orcl catalog rcat/rcat@rcat

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Sep 24 21:21:27 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: RCAT (DBID=376666761)
connected to recovery catalog database

RMAN> register database;

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

RMAN> report schema;

No comments: