How to Create a Recovery Catalog in 10g
Posted by mnsinger on September 13, 2006
Create a database with dbca called rcat
C:\> sqlplus SYS/pass@rcat AS SYSDBA
SQL> CREATE SMALLFILE TABLESPACE catalog_tbs DATAFILE ‘F:\ORACLE\..\cat_tbs.dbf’ SIZE 20M AUTOEXTEND ON NEXT 5M UNLIMITED LOGGING 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:\> rcat 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 12 21:21:27 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: RCAT (DBID=373135761)
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;
John DeStefano said
Thanks. I think the ‘C:\> rcat’ above should be ‘C:\> rman’?
Bik0 said
good and easy steps . . but u should put some desc about the database that will be recovered (orcl). .
thanks