Linux 9i下Dataguard配置

(protocol=tcp) 
(port=1521) 
(host=1.1.1.1)) 
(connect_data= 
(SID=oracle)))
standby=(description= 
(address= 
(protocol=tcp) 
(port=1521) 
(host=1.1.1.2)) 
(connect_data= 
(SID=oracle)))
同样，在副节点(standby) 的tnsnames.ora文件

5. 在副节点(standby)上配置listener.ora文件, 添加监听服务standby_listener，在相应的节里添加有关的内容.
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
        (SID_NAME = oracle)
        (GLOBAL_DBNAME = oracle)
      (ORACLE_HOME = /home/oracle/oradata)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
     (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1521))
    )
  )

在主副库上启动lsnrctl,
  -bash-2.05b$ lsnrctl 
LSNRCTL>start      # 启动监听服务

 6.在主备节点用tnsping测试网络连通性

在primary机上
-bash-2.05b$  tnsping  primary
-bash-2.05b$  tnsping  standby

在standby机上
-bash-2.05b$  tnsping  primary
-bash-2.05b$  tnsping  standby

7. 启动副数据库

   sql> startup nomount;
   SQL> alter database mount standby database;
Database altered.
SQL> alter database recover managed standby database disconnect from session;
Database altered.

8. 在主节点设置归档路径
SQL> alter system set log_archive_dest_2='service=standby mandatory reopen=60';
System altered.
定义了主库向副库传输日志
# 定义归档到备用库，强制归档，重试时间60秒。 
# 如果定义为可选状态(optional)，那么在归档失败后不会再次尝试归档的。定义 
# 为madatory状态后，如果本次归档失败，则在归档下一个日志时会再次尝试
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> 
在备用节点观察日志
[oracle@eygle bdump]$ tail -f alert_primary.log 
MRP0: Background Managed Standby Recovery process started
Starting datafile 1 recovery in thread 1 sequence 90
Datafile 1: '/opt/oracle/oradata/primary/system01.dbf'
Starting datafile 2 recovery in thread 1 sequence 90
Datafile 2: '/opt/oracle/oradata/primary/undotbs01.dbf'
…………………………
-bash-2.05b$ mkdir /home/oracle/oradata/oracle/stdarch