oracle@venu1> export ORACLE_SID=catdb
oracle@venu1> sqlplus / as sysdba
oracle@venu1> startup
SQL> conn rmanuser/rmanuser
rmanuser> select * from rc_database;
oracle@venu1> ssh venu2
oracle@venu2> su - oracle
oracle@venu2> ps -ef|grep smon
oracle@venu2> export ORACLE_SID=hrms
oracle@venu2> sqlplus / as sysdba
SQL> startup
SQL> exit
oracle@venu2> cd /u01/app/oracle/product/11.2.0/db_home/network/admin
oracle@venu2 admin> ls
oracle@venu2 admin> vi listener.ora
-start two listeners.
oracle@venu1 admin> ls
oracle@venu1 admin> vi tnsnames.ora
oracle@venu1> tnsping to_sales
oracle@venu2> cd $ORACLE_HOME/dbs
oracle@venu2 dbs> orapwd file=orapwsales password=rac entries=3 force=y
oracle@venu1> export ORACLE_SID=catdb
oracle@venu1> rman catalog rmanuser/rmanuser target sys/rac@to_sales
oracle@venu2> export ORACLE_SID=sales
oracle@venu2> sqlplus / as sysdba
oracle@venu1> rman catalog rmanuser/rmanuser target sys/rac@to_sales
RMAN> register database;
RMAN> list db_unique_name all;
RMAN> exit
oracle@venu1> export ORACLE_SID=catdb
oracle@venu1> sqlplus / as sysdba
SQL> select name from v$datafile;
SQL> create tablespace vpts
datafile '/u01/app/oracle/catdb/vpts01.dbf' size 4m autoextend on;
SQL> create user vp identified by vp default tablespace vpts;
SQL> grant connect,resource,recovery_catalog_owner to vp;
SQL conn vp/vp
vp> select * from tab;
vp> conn rmanuser/rmanuser
rmanuser> select * from rc_database;
rmanuser> exit
oracle@venu1> rman catalog rmanuser/rmanuser
RMAN> grant catalog for database sales to vp;
RMAN> exit
oracle@venu1> rman catalog vp/vp
RMAN> create virtual catalog;
RMAN> list db_unique_name all;
RMAN> exit
oracle@venu1> rman catalog rmanuser/rmanuser
RMAN> list db_unique_name all;
RMAN> exit
oracle@venu1> rman catalog vp/vp target sys/rac@to_sales
RMAN> exit
oracle@venu1> vi rmanparameters.rcv
run
{
allocate channel c1 device type disk connect 'sys/rac@to_sales';
allocate channel c2 device type disk connect 'sys/rac@to_sales';
backup database plus archivelog;
release channel c1;
release channel c2;
}
:wq!
-We need to release the channel if we allocate, no need when we configure.
oracle@venu1> rman catalog vp/vp target sys/rac@to_sales
RMAN>@rmanparameters.rcv
RMAN> exit
oracle@venu1> ps -ef|grep smon
oracle@venu1> export ORACLE_SID=catdb
oracle@venu1> sqlplus / as sysdba
SQL> alter database enable block change tracking using file '/home/oracle/trace.sql';
SQL> !ps - ef|grep smon
SQL> !ps - ef|grep ora
SQL> exit
oracle@venu1> rman catalog vp/vp target sys/rac@to_sales
RMAN> backup incremental level 0 database;
RMAN> exit
