虚拟机上Oracle 10g DataGuard的配置(1)(3)

(2)在standby主机上配置

listener.ora文件内容如下：

SID_LIST_LISTENER =  
 
(SID_LIST =  
 
(SID_DESC =  
 
(GLOBAL_DBNAME = wellcommb)  
 
(ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)  
 
(SID_NAME = wellcommb)  
 
)  
 
)  
 
LISTENER =  
 
(DESCRIPTION_LIST =  
 
(DESCRIPTION =  
 
(ADDRESS = (PROTOCOL = TCP)(HOST = wangkang)(PORT = 1521))  
 
)  
 
) 

tnsnames.ora文件内容如下：

WELLCOMM =  
 
(DESCRIPTION =  
 
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.111.131)(PORT = 1521))  
 
(CONNECT_DATA =  
 
(SERVICE = DEDICATED)  
 
(SERVICE_NAME = wellcomm)  
 
)  
 
)  
 
WELLCOMMB =  
 
(DESCRIPTION =  
 
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.111.132)(PORT = 1521))  
 
(CONNECT_DATA =  
 
(SERVER = DEDICATED )  
 
(SERVICE_NAME = wellcommb)  
 
)  
 
) 

重启监听

lsnrctl stop

lsnrctl start

8.在standby主机上启动应用redo

alter database recover managed standby database disconnect from session;

(取消：alter database recover managed standby database cancel;)

9.确认从Primary到Standby的Redo传输及应用

(1)在Primary主机上执行日志文件切换(最好多次)

alter system switch logfile;

(2)查询Primary的归档日志

select sequence#,applied,first_time,next_time from v$archived_log order by sequence#;

(3)查询Standby的归档日志及其应用

select sequence#,applied,first_time,next_time from v$archived_log order by sequence#;

注意applied字段显示YES则表明该归档日志已被standby数据库应用了。