Oracle RMAN 設定方式 --- for Oracle RAC

Before Oracle 11g :

configure default device type to sbt;

configure device type sbt parallelism 3;

confiure channel 1 device type sbt connect='sys/oracle@racdb1';

confiure channel 2 device type sbt connect='sys/oracle@racdb2';

confiure channel 3 device type sbt connect='sys/oracle@racdb3';

 

or

configure default device type to sbt;

configure device type sbt parallelism 3;

confiure channel 1 device type sbt connect='sys/oracle@racdb';

 

記得check 此方法是以local instance 備份還是以 service name 連至三個instance 備份

如果固定連到第一台資料庫備份的話 , 則可不用configure 以上參數.

 

For Oracle 11g :

 

tnsnames.ora僅需指定scan listener name 即可

 

racdb=

   (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = db-adm-scan )(PORT = 1521))

      (CONNECT_DATA =

         (SERVER = DEDICATED)

         (SERVICE_NAME = orcl )

      )

   )

 

configure default device type to sbt;

configure device type sbt parallelism 3;

confiure channel 1 device type sbt connect='sys/oracle@racdb';