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

当前位置:我的异常网» Oracle管理 » oracle DG 归档日志不能应用有关问题

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

www.myexceptions.net  网友分享于：2013-01-10  浏览：244次

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)'

文章评论