当前位置: 代码迷 >> Oracle管理 >> oracle DG 归档日志不能应用有关问题
  详细解决方案

oracle DG 归档日志不能应用有关问题

热度:1048   发布时间:2016-04-24 06:22:11.0
oracle DG 归档日志不能应用问题
主库和备库参数文件 密码文件 网络互联 监听器 文件路径都检查好几遍了 没啥问题 日志可以正常从主库传输到备库,
就是不能应用,在主库的警告文件中这样提示着:
Sun May 09 00:12:11 2010
Thread 1 advanced to log sequence 58146
  Current log# 2 seq# 58146 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\CBDB\REDO02.LOG
  Current log# 2 seq# 58146 mem# 1: E:\ORACLE\PRODUCT\10.2.0\ORADATA\CBDB\REDO022.LOG
  Current log# 2 seq# 58146 mem# 2: E:\ORACLE\PRODUCT\10.2.0\ORADATA\CBDB\REDO0222.LOG
Sun May 09 00:12:32 2010
FAL[server]: Fail to queue the whole FAL gap
 GAP - thread 1 sequence 6-105
 DBID 3163648218 branch 718483759
Sun May 09 00:16:48 2010
Shutting down archive processes
Sun May 09 00:16:53 2010
ARCH shutting down
ARC2: Archival stopped

大家帮我分析一下哪的问题

主库参数
cbdb.__db_cache_size=1409286144
cbdb.__java_pool_size=16777216
cbdb.__large_pool_size=8388608
cbdb.__shared_pool_size=218103808
cbdb.__streams_pool_size=0
*.audit_file_dest='E:\oracle\product\10.2.0/admin/cbdb/adump'
*.background_dump_dest='E:\oracle\product\10.2.0/admin/cbdb/bdump'
*.compatible='10.2.0.1.0'
*.control_files='E:\oracle\product\10.2.0/oradata/cbdb/\control01.ctl','E:\oracle\product\10.2.0/oradata/cbdb/\control02.ctl','E:\oracle\product\10.2.0/oradata/cbdb/\control03.ctl'
*.core_dump_dest='E:\oracle\product\10.2.0/admin/cbdb/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.DB_FILE_NAME_CONVERT='E:\oracle\product\10.2.0\oradata\cbdb','E:\oracle\product\10.2.0\oradata\cbdb','G:\oradata','G:\oradata'
*.db_name='cbdb'
*.db_recovery_file_dest='g:\temp'
*.db_recovery_file_dest_size=161061273600
*.db_unique_name='CBDB_P'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=cbdbXDB)'
*.FAL_CLIENT='cbdb_10.78.245.220'
*.FAL_SERVER='cbdb_10.78.173.198'
*.job_queue_processes=10
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(cbdb_p,cbdb_s)'
*.log_archive_dest_1='LOCATION=g:\temp VALID_FOR=(all_logfiles,all_roles) db_unique_name=cbdb_p'
*.LOG_ARCHIVE_DEST_2='SERVICE=cbdb_10.78.173.198 ARCH VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=cbdb_s'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='ARC%S_%R.%T'
*.LOG_FILE_NAME_CONVERT='E:\oracle\product\10.2.0\oradata\cbdb','E:\oracle\product\10.2.0\oradata\cbdb','G:\oradata','G:\oradata'
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=150
*.recovery_parallelism=5
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1660944384
*.STANDBY_FILE_MANAGEMENT='AUTO'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='E:\oracle\product\10.2.0/admin/cbdb/udump'

备库参数:
cbdb.__db_cache_size=1409286144
cbdb.__java_pool_size=16777216
cbdb.__large_pool_size=8388608
cbdb.__shared_pool_size=218103808
cbdb.__streams_pool_size=0
*.audit_file_dest='E:\oracle\product\10.2.0/admin/cbdb/adump'
*.background_dump_dest='E:\oracle\product\10.2.0/admin/cbdb/bdump'
*.compatible='10.2.0.1.0'
*.control_files='E:\oracle\product\10.2.0/oradata/cbdb/\control01.ctl','E:\oracle\product\10.2.0/oradata/cbdb/\control02.ctl','E:\oracle\product\10.2.0/oradata/cbdb/\control03.ctl'
*.core_dump_dest='E:\oracle\product\10.2.0/admin/cbdb/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.DB_FILE_NAME_CONVERT='E:\oracle\product\10.2.0\oradata\cbdb','E:\oracle\product\10.2.0\oradata\cbdb','G:\oradata','G:\oradata'
*.db_name='cbdb'
*.db_recovery_file_dest='g:\temp'
*.db_recovery_file_dest_size=161061273600
*.db_unique_name='CBDB_S'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=cbdbXDB)'
*.FAL_CLIENT='cbdb_10.78.173.198'
*.FAL_SERVER='cbdb_10.78.245.220'
*.job_queue_processes=10
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(cbdb_p,cbdb_s)'
  相关解决方案