Tuesday, January 22, 2013

Create the Oracle RMAN Catalog

orarac2poc:ORCL2:/home/oracle> env |grep ORA
ORACLE_UNQNAME=ORCL
ORACLE_SID=ORCL2
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_2
orarac2poc:ORCL2:/home/oracle> export ORACLE_SID=RCAT
orarac2poc:RCAT:/home/oracle> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 28 09:52:49 2012

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options


SYS@RCAT> select file_name from dba_data_files;

FILE_NAME
------------------------------------------------------------------------------------------------------------------------------------
+DGRCAT/rcat/datafile/system.261.803153779
+DGRCAT/rcat/datafile/sysaux.262.803153789
+DGRCAT/rcat/datafile/undotbs1.263.803153795
+DGRCAT/rcat/datafile/users.265.803153807

SYS@RCAT> create tablespace rman_tbs datafile '+DGRCAT/rcat/datafile/rman_tbs01.dbf' size 100m ;

Tablespace created.



SYS@RCAT> create user rman identified by rman123 default tablespace rman_tbs temporary tablespace temp;

User created.


orarac2poc:ORCL2:/home/oracle> rcat
orarac2poc:RCAT:/home/oracle> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 28 10:49:40 2012

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SYS@RCAT> select * from dba_sys_privs where grantee='CONNECT';

GRANTEE                        PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
CONNECT                        CREATE SESSION                           NO

SYS@RCAT> grant create session, resource, recovery_catalog_owner to rman;

Grant succeeded.

SYS@RCAT> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
orarac2poc:RCAT:/home/oracle> cd $ORACLE_HOME
orarac2poc:RCAT:/u01/app/oracle/product/11.2.0/db_2> tnsping RCAT

TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 28-DEC-2012 10:51:05

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orarac2poc)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RCAT)))
OK (10 msec)
orarac2poc:RCAT:/u01/app/oracle/product/11.2.0/db_2> sqlplus rman/rman123@RCAT

SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 28 10:51:21 2012

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

RMAN@RCAT> exit



orarac2poc:RCAT:/home/oracle> rman catalog rman/rman123@RCAT

Recovery Manager: Release 11.2.0.2.0 - Production on Fri Dec 28 10:54:40 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to recovery catalog database

RMAN> create catalog;

recovery catalog created

RMAN> exit


Recovery Manager complete.
orarac2poc:RCAT:/home/oracle> sqlplus  rman/rman123@RCAT

SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 28 10:55:13 2012

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

RMAN@RCAT> select object_name from user_objects;

OBJECT_NAME
--------------------------------------------------------------------------------------------------------------------------------
DB
DB_P
DB_U1
RMAN_SEQ
NODE
NODE_P
...
VPC_USERS_V
VPC_DATABASES_V
CFS_V
BCR_V

252 rows selected.

RMAN@RCAT> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
orarac2poc:RCAT:/home/oracle> sqlplus  rman/rman123@RCAT

SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 28 10:56:04 2012

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

RMAN@RCAT> select * from rc_database;

no rows selected

RMAN@RCAT> exit

References:

Creating an RMAN Recovery Catalog