oracle 11g rac 环境下 静态监听的配置 以及 归档日志备份

归档日志的备份 大致有三种 方式（除第一种外，后两种都需要 配置好监听）

1. 把归档日志放到 +ASM 磁盘上 或 把归档日志放到类似 NFS 的 共享存储上

2.把归档存储在本地，同时 还要把 归档 传输到 其它实例上(利用 log_archive_dest_2=’service=ora11g2‘   参数）

3.以connect 方式开辟多个通道

静态监听 ：

1. 

在 node1 ：

#su - grid 

$cd $ORACLE_HOME/network/admin/

$vim listener.ora

SID_LIST_LISTENER =
(SID_LIST =
 (SID_DESC =
  (GLOBAL_DBNAME=ora11g1)
   (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
    (SID_NAME=ora11g1)
  ))
       

在node2:

#su - grid 

$cd $ORACLE_HOME/network/admin/

$vim listener.ora

SID_LIST_LISTENER =
(SID_LIST =
 (SID_DESC =
  (GLOBAL_DBNAME=ora11g1=2)
   (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
    (SID_NAME=ora11g2)
  ))

node1 和 node2 都一样

#su - oracle

$cd $ORACLE_HOME/network/admin

$vim tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.


LISTENERS_ora11g =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
  )
ORA11G =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ora11g)
    )
  )


ORA11G1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.31)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ora11g1)
      (INSTANCE_NAME = ora11g1)
    )
)


ORA11G2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.41)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ora11g2)
      (INSTANCE_NAME = ora11g2)
    )
)

node1 和 node2 重启监听

第一种 不用多说了，直接备

第二种  传输归档日志到其它实例的机器上还 一直没有传过去。等我在研究研究

第三种 

run {
allocate channel c1 device type disk connect 'sys/oracle@ora11g1';
allocate channel c2 device type disk connect 'sys/oracle@ora11g2';
backup archivelog all format '/bk/%u.arc';
release channel c1;
release channel c2;
 }