Sunday, December 6, 2015

Configure RMAN in RAC

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