For configuration Rman in RAC we can divide processes on the
more than one node by configuration multiple channel on the rman as described
in the following commands:
In this case we have three nodes:
1-Config tnsnames.ora file on the each node as following
scripts:
Node2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2)(PORT
= 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
Node3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac3)(PORT
= 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
2-By configure following rman command we can begin backup
with three parallel channels:
RMAN> CONFIGURE
DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
RMAN> CONFIGURE
CHANNEL 2 DEVICE TYPE DISK CONNECT 'sys/password@Node2';
RMAN> CONFIGURE
CHANNEL 3 DEVICE TYPE DISK CONNECT 'sys/password@Node3';
run {
sql 'alter system archive log current';
backup incremental level 0 database format '/backup/backup1/FULL_BACK_%U.bck';
backup archivelog all format '/backup/backup1/ARC_BACK_%U.bck';
backup current controlfile;
}
With above solution you’ll divided processes on the
node2 and node 3 but, be careful this way may have network wait.
Also
with the following commands you can be turned settings.
RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK CLEAR;
RMAN> CONFIGURE CHANNEL 3 DEVICE TYPE DISK CLEAR;
No comments:
Post a Comment