Hello, I have a question that the documentation does not seem to answer.
Please let me know if you have done this or know how it will work.
I have an 11.2.0.3 database on linux.
RAC cluster with 4 nodes.
The database is using ASM connected to a SAN storage array.
There are about 100 datafiles.
We have been using 10 channels running from one node to do the full backup. It is 9 TB and was taking about 16 hours to complete.
To get it to complete faster we decided to have the channels connect to different nodes so the i/o would be from all hosts backup NICs.
That works.
But a question came up that we would NOT be able to restore the database unless the system we restore to has the same NUMBER of nodes, in this case 4.
Does anyone know if when you run a backup using multiple channel connections to multiple nodes can you restore the system to a cluster with a DIFFERENT NUMBER of hosts/nodes?
Here is my backup script:
RUN {
# All BIG DB backups will use 10 channels
#
ALLOCATE CHANNEL t01 TYPE 'SBT_TAPE' connect 'sys/pass@CON2';
ALLOCATE CHANNEL t02 TYPE 'SBT_TAPE' connect 'sys/pass@CON2';
ALLOCATE CHANNEL t03 TYPE 'SBT_TAPE' connect 'sys/pass@CON2';
ALLOCATE CHANNEL t04 TYPE 'SBT_TAPE' connect 'sys/pass@CON2';
ALLOCATE CHANNEL t05 TYPE 'SBT_TAPE' connect 'sys/pass@CON1';
ALLOCATE CHANNEL t06 TYPE 'SBT_TAPE' connect 'sys/pass@CON1';
ALLOCATE CHANNEL t07 TYPE 'SBT_TAPE' connect 'sys/pass@CON3';
ALLOCATE CHANNEL t08 TYPE 'SBT_TAPE' connect 'sys/pass@CON3';
ALLOCATE CHANNEL t09 TYPE 'SBT_TAPE' connect 'sys/pass@CON4';
ALLOCATE CHANNEL t10 TYPE 'SBT_TAPE' connect 'sys/pass@CON4';
SEND 'NB_ORA_POLICY=ORA_POLICY';
SEND 'NB_ORA_SCHED=ORA_SCHEDORA_SCHED';
BACKUP INCREMENTAL LEVEL 0 CUMULATIVE DATABASE
TAG='FULL_LEVEL0_DB' FORMAT '%d_%U_%t'
INCLUDE CURRENT CONTROLFILE
FILESPERSET = 1
SPFILE TAG='SPFILE' FORMAT '%d_%U_%t'
PLUS ARCHIVELOG NOT BACKED UP TAG='FULL_LEVEL0_ARCH' FORMAT '%d_%U_%t'
;
}
exit;