Hello,
I have a 4-node RAC setup and I want to be able to backup from all the 4 nodes simultaneously. For this I want to explicitly connect to each instance from RMAN instead of connecting to the DBSID. What is the way for me to achieve the same ? I am not able to connect to the particular instances from SQLplus/TNSPING as well as I think SCAN IP is only able to resolve to the DB SID rather than the instance ID. When I don’t specify the connect string, there is no failure as it allocates channels automatically to instances ( only to 2 instances and 2 nodes are inactive and do not participate in the backup).
- - What are the steps that I have to do to achieve the below for being able to connect to particular instances from SQLplus ?
- - Which NetCA should I be using to configure TNS/Listener --- Database or Grid ?
- - Any steps that I need to take on all nodes instead of just one node ?
Any help is welcome!
RMAN> RUN {
2> ALLOCATE CHANNEL ch00 TYPE DISK connect 'sys/oracle@realdb_1' FORMAT '\\192.168.2.11\test\DF_CH00_%U';
3> ALLOCATE CHANNEL ch01 TYPE DISK connect 'sys/oracle@realdb_2' FORMAT '\\192.168.2.11\test\DF_CH01_%U';
4> ALLOCATE CHANNEL ch02 TYPE DISK connect 'sys/oracle@realdb_3' FORMAT '\\192.168.2.11\test\DF_CH02_%U';
5> ALLOCATE CHANNEL ch03 TYPE DISK connect 'sys/oracle@realdb_4' FORMAT '\\192.168.2.11\test\DF_CH03_%U';
6> Backup incremental level 0 database;
7> RELEASE CHANNEL ch00;
8> RELEASE CHANNEL ch01;
9> RELEASE CHANNEL ch02;
10> RELEASE CHANNEL ch03;
11> }
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-12001: could not open channel ch00
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database
ORA-12154: TNS:could not resolve the connect identifier specified