CONFIGURE OF CATALOG IN ORACLE 11G FOR RMAN
Target Database Side(hrms)
Catalog Database Side(catdb)
$export ORACLE_SID=hrms
$sqlplus / as sysdba
sql>startup
sql>archive log list
(should be enabled)
create listener.ora file manually
[oracle@mac1 admin]$ cat listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)(HOST = mac1.oracle.com)(PORT = 7777))
#(ADDRESS =
(PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST=
(SID_DESC=
(SID_NAME=hrms)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
)
)
ADR_BASE_LISTENER = /u01/app/oracle
:wq
$lsnrctl start LISTENER
create password file
$cd $ORACLE_HOME/dbs
$orapwd file=orapwhrms password=sys force=y
Catalog Database Side
=====================
$export ORACLE_SID=catdb
$sqlplus / as sysdba
sql>startup mount;
sql>alter database archivelog;
sql>alter database open;
Create tnsnames.ora file manually
+++++++++++++++++++++++++++++++++++++++
[oracle@lnx02 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
TO_HRMS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)(HOST = lnx01.oracle.com/or ip address of target database)(PORT = 7777))
)
(CONNECT_DATA =
(SERVICE_NAME =
hrms)
)
)
$tnsping to_hrms
sql>create tablespace rmantbs datafile '/u01/app/oracle/catdb/rmantabs.dbf'
size 100m;
sql>create user rmanu identified by rmanu;
sql>alter user rmanu default tablespace rmantbs;
sql>grant connect,resource,recovery_catalog_owner to
rmanu;
sql>exit
$rman catalog rmanu/rmanu
rman>create catalog;
rman>exit
sql>conn rmanu/rmanu
sql>select count(*) from tab;
$rman catalog rmanu/rmanu target sys/sys@to_hrms
rman>register database;
rman>backup database;
