CREATING NEW RMAN CATALOG
Database name to store catalog – RMAN10CAT
1. Create Tablespace for catalog owner in catalog database
Login to RMAN10CAT database as sysdba
SQL> create tablespace rman10 datafile ‘/u03/oradata/rman10cat/rman10.dbf’ size 200m autoextend on;
Create catalog owner in Catalog database
create user rman10 identified by rman default tablespace rman10 temporary tablespace temp;
Issue required grants to catalog owner
grant create session,resource to rman10;
grant recovery_catalog_owner to rman10;
alter user rman10 quota unlimited on rman10;
At this point the catalog owner exists in the database but there is no catalog created –
To test this –
SQL> conn rman10/rman
Connected.
SQL> select name from rc_database;
select name from rc_database
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> exit
This is because the RECOVERY CATALOG has not yet been created in the database.
CREATE CATALOG
Login as sysdba into database RMAN10CAT and also as catalog owner.
rman10cat:/u01/oracle> rman target / catalog rman10/rman
Recovery Manager: Release 10.2.0.4.0 – Production on Mon Jul 13 12:42:15 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: TESTDB (DBID=2469552796)
connected to recovery catalog database
RMAN> create catalog;
recovery catalog created
RMAN> exit
Recovery Manager complete.
rman10cat:/u01/oracle> sqlplus rman10/rman
SQL> select name from rc_database;
no rows selected
Catalog exists and the sql statement above will show results once databases are registered in this catalog .
Arjun Raja
