三思<涂抹oracle>dataguard配置请教,试了几天还是不行;

问题:standby数据库接收不到从primary数据库传过来的归档文件, 如下;配置都是按三思哥书中说明(同台电脑)

(primary):jsspre>select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
           115

但在(standby):
jsspdg>select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------


---------------------------------------------------------------------------------
为了分析问题以下列出相关参数:

1.primary端相关配置参数:
primary(spfile):

jssbook.__db_cache_size=406847488
jssbook.__java_pool_size=4194304
jssbook.__large_pool_size=4194304
jssbook.__shared_pool_size=192937984
jssbook.__streams_pool_size=0
*.audit_file_dest='d:\oracle\product\10.2.0\admin\jssbook\adump'
*.background_dump_dest='d:\oracle\product\10.2.0\admin\jssbook\bdump'
*.compatible='10.2.0.1.0'
*.control_files='d:\oracle\oradata\jssbook\jssbook\control01.ctl','d:\oracle\oradata\jssbook\jssbook\control02.ctl','d:\oracle\oradata\jssbook\jssbook\control03.ctl'
*.core_dump_dest='d:\oracle\product\10.2.0\admin\jssbook\cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_file_name_convert='d:\oracle\oradata\jssbook\jssbook','e:\oradata\jsspdg'
*.db_name='jssbook'
*.db_unique_name='jsspre'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=jssbookXDB)'
*.fal_client='jsspre_192.168.100.100'
*.fal_server='jsspdg_192.168.100.101'
*.job_queue_processes=10
*.log_archive_config='DG_CONFIG=(jsspre,jsspdg)'
*.log_archive_dest_1='location=D:\oracle\product\10.2.0\db_1\database\archive valid_for=(all_logfiles,all_roles) db_unique_name=jsspre'
*.log_archive_dest_2='service=jsspdg_192.168.100.101 arch valid_for=(online_logfiles,primary_role)  db_unique_name=jsspdg'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_file_name_convert='d:\oracle\oradata\jssbook\jssbook','e:\oradata\jsspdg'
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=612368384
*.standby_file_management='auto'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='d:\oracle\product\10.2.0\admin\jssbook\udump'

primary(archive log list)

jsspre>archive log list
数据库日志模式            存档模式
自动存档             启用
存档终点            D:\oracle\product\10.2.0\db_1\database\archive
最早的联机日志序列     114
下一个存档日志序列   116
当前日志序列           116

2.standby端配置相关参数:

standby(spfile):

jssbook.__db_cache_size=427819008
jsspdg.__db_cache_size=440401920
jssbook.__java_pool_size=4194304
jsspdg.__java_pool_size=4194304
jssbook.__large_pool_size=4194304
jsspdg.__large_pool_size=4194304
jssbook.__shared_pool_size=171966464
jsspdg.__shared_pool_size=159383552
jssbook.__streams_pool_size=0
jsspdg.__streams_pool_size=0
*.audit_file_dest='E:\oracle\product\10.2.0\admin\jsspdg\adump'
*.background_dump_dest='E:\oracle\product\10.2.0\admin\jsspdg\bdump'
*.compatible='10.2.0.1.0'
*.control_files='E:\oradata\jsspdg\jsspdg01.ctl','E:\oradata\jsspdg\jsspdg02.ctl','E:\oradata\jsspdg\jsspdg03.ctl'
*.core_dump_dest='E:\oracle\product\10.2.0\admin\jsspdg\cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_file_name_convert='d:\oracle\oradata\jssbook\jssbook','e:\oradata\jsspdg','e:\oradata\jsspdg','d:\oracle\oradata\jssbook\jssbook'
*.db_name='jssbook'
*.db_unique_name='jsspdg'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=jssbookXDB)'
*.fal_client='jsspre_192.168.100.101'
*.fal_server='jsspdg_192.168.100.100'
*.job_queue_processes=10
*.log_archive_config='DG_CONFIG=(jsspre,jsspdg)'
*.log_archive_dest_1='location=E:\oradata\jsspdg\archive'
*.log_archive_dest_2='service=jsspre_192.168.100.100 arch valid_for=(online_logfiles,primary_role)  db_unique_name=jsspre'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.log_file_name_convert='d:\oracle\oradata\jssbook\jssbook','e:\oradata\jsspdg','e:\oradata\jsspdg','d:\oracle\oradata\jssbook\jssbook'
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=612368384
*.standby_file_management='auto'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='E:\oracle\product\10.2.0\admin\jsspdg\udump'


standby(archive log list)

jsspdg>archive log list
数据库日志模式            存档模式
自动存档             启用
存档终点            E:\oradata\jsspdg\archive
最早的联机日志序列     112
下一个存档日志序列   114
当前日志序列           114


公共的listener.ora 和tnsnames.ora

listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = jssbook)
      (ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
      (SID_NAME = jssbook)
    )
   (SID_DESC =
      (GLOBAL_DBNAME = jsspdg)
      (ORACLE_HOME = e:\oracle\product\10.2.0\db_1)
      (SID_NAME = jsspdg)
    )
   
  )

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


tnsnames.ora


jsspdg_192.168.100.101=
  (description=
     (address_list=
       (address=(protocol=tcp)(host=192.168.100.101)(port=1521))
     )
      (connect_data=
        (sid=jsspdg)
        (server=dedicated)
      )
   )


jsspre_192.168.100.100=
  (description=
     (address_list=
       (address=(protocol=tcp)(host=192.168.100.100)(port=1521))
     )
      (connect_data=
        (sid=jssbook)
        (server=dedicated)
      )
   )

-----------------------------------------------------------------------
其它参数:

1.tnsping都可以通:

jsspdg>host tnsping jsspre_192.168.100.100

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 14-8月 -
2011 11:07:06

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

已使用的参数文件:
d:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora


已使用 TNSNAMES 适配器来解析别名
Attempting to contact (description= (address_list= (address=(protocol=tcp)(host=
192.168.100.100)(port=1521))) (connect_data= (sid=jssbook) (server=dedicated)))
OK (40 毫秒)
-------------------------------------------------
jsspre>host tnsping jsspdg_192.168.100.101

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 14-8月 -
2011 11:07:42

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

已使用的参数文件:
d:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora


已使用 TNSNAMES 适配器来解析别名
Attempting to contact (description= (address_list= (address=(protocol=tcp)(host=
192.168.100.101)(port=1521))) (connect_data= (sid=jsspdg) (server=dedicated)))
OK (10 毫秒)

2.两边数据库都可正常的启动;

-----------------------------------
测试了几天还是解决不了问题,故上来求救,望大家指教,谢谢大家;

[ 本帖最后由 AiKou_zhang 于 2011-8-14 11:12 编辑 ]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24766946/viewspace-704811/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24766946/viewspace-704811/