oracle@venu1> ps -ef|grep smon
-- create catalog database
oracle@venu1> cd /u01/app/oracle/product/11.2.0/db_home/network/admin
oracle@venu1 admin> ls
oracle@venu1 admin> vi tnsnames.ora
TO_HRMS=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=venu2.oracle.com) (PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=HRMS)))
oracle@venu2> ps -ef|grep smon
oracle@venu2> cd /u01/app/oracle/product/11.2.0/db_home/network/admin
oracle@venu2 admin> ls
oracle@venu2 admin> vi listener.ora
LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=venu2.oracle.com) (PORT=1521))))
ADR_BASE_LISTENER=/u01/app/oracle
SID_BASE_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=hrms)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_home)))
oracle@venu1> export ORACLE_SID=catdb
oracle@venu1> sqlplus / as sysdba
SQL> select name,open_mode,log_mode from v$database;
SQL> select instance_name,status from v$instance;
SQL> select name from v$datafile;
SQL> create tablespace rman_ts
datafile '/u03/app/oracle/catdb/rman_ts01.dbf' size 10m autoextend on;
SQL> create user rmanuser identified by rmanuser default tablespace rman_ts;
SQL> grant connect,resource,recovery_catalog_owner to rmanuser;
SQL> conn rmanuser/rmanuser
rmanuser> select count(*) from tab;
rmanuser> exit;
oracle@venu1> rman catalog rmanuser/rmanuser
RMAN> create catalog;
RMAN> exit
oracle@venu1> sqlplus / as sysdba
SQL> conn rmanuser/rmanuser
rmanuser> select count(*) from tab;
rmanuser> select * from tab;
rmanuser> select * from rc_database;
rmanuser> exit
oracle@venu2> cd $ORACLE_HOME/dbs
- Configurations to be done at target size.
oracle@venu2 dbs> orapwd file=orapwhrms password=rac entries=3 force=y
- Configurations to be done at catalog side.
oracle@venu1> export ORACLE_SID=catdb
oracle@venu1> rman catalog rmanuser/rmanuser target sys/rac@to_hrms
RMAN> register database;
RMAN> list db_unique_name all;
RMAN> exit
oracle@venu1> sqlplus rmanuser/rmanuser
rmanuser> select * from rc_database;
rmanuser> exit
oracle@venu1> export ORACLE_SID=catdb
oracle@venu1> rman catalog rmanuser/rmanuser target sys/rac@to_hrms
RMAN> show all;
RMAN> spool log to rman.log
RMAN> show all;
RMAN> spool off;
RMAN> exit
oracle@venu1> vi rman.log
configure retention policy to redundancy 2;
configure backup optimization on;
configure controlfile autobackup on;
configure device type disk parallelism 2 backup type to backupset;
configure channel 1 device type disk connect 'sys/rac@to_hrms';
configure channel 2 device type disk connect 'sys/rac@to_hrms';
oracle@venu1> rman catalog rmanuser/rmanuser target sys/rac@to_hrms
RMAN> @rman.log
RMAN> host 'clear';
oracle@venu2> cd $ORACLE_HOME/dbs
oracle@venu2> cd /u01/app/oracle/fast_recovery_area/venu
RMAN> backup database plus archivelog;
oracle@venu2 venu>ls
oracle@venu2> cd $ORACLE_HOME/dbs
oracle@venu2 dbs> ls
oracle@venu2> cd /u01/app/oracle/fast_recovery_area/venu
oracle@venu2> ls
