1、备库是否对应时间点有错误？

2、数据库参数文件(create pfile='/tmp/init.ora' from memory)的配置

3、有没有arc4的trace文件

1、备库同步也是正常的，对应时间点也没有错误信息

3、没有看到arc4 TRACE

2\

# Oracle init.ora parameter file generated by instance orcl1 on 05/05/2019 09:43:45

orcl1.__db_cache_size=90368M

orcl2.__db_cache_size=56G

*.__java_pool_size=1792M

*.__large_pool_size=256M

*.__oracle_base='/u01/app/oracle' # ORACLE_BASE set from environment

orcl1.__pga_aggregate_target=80G

orcl2.__pga_aggregate_target=20G

orcl1.__sga_target=120G

orcl2.__sga_target=89G

orcl1.__shared_io_pool_size=512M

orcl2.__shared_io_pool_size=256M

orcl1.__shared_pool_size=28G

orcl2.__shared_pool_size=30464M

*.__streams_pool_size=512M

*._aggregation_optimization_settings=0

*._always_anti_join='CHOOSE'

*._always_semi_join='CHOOSE'

*._and_pruning_enabled=TRUE

*._b_tree_bitmap_plans=TRUE

*._bloom_filter_enabled=TRUE

*._bloom_folding_enabled=TRUE

*._bloom_pruning_enabled=TRUE

*._complex_view_merging=TRUE

*._compression_compatibility='11.2.0.4.0'

*._connect_by_use_union_all='TRUE'

*._convert_set_to_join=FALSE

*._cost_equality_semi_join=TRUE

*._cpu_to_io=0

*._dimension_skip_null=TRUE

*._eliminate_common_subexpr=TRUE

*._enable_type_dep_selectivity=TRUE

*._fast_full_scan_enabled=TRUE

*._first_k_rows_dynamic_proration=TRUE

*._gby_hash_aggregation_enabled=TRUE

*._gc_policy_time=0

*._gc_undo_affinity=FALSE

*._generalized_pruning_enabled=TRUE

*._globalindex_pnum_filter_enabled=TRUE

*._gs_anti_semi_join_allowed=TRUE

*._improved_outerjoin_card=TRUE

*._improved_row_length_enabled=TRUE

*._index_join_enabled=TRUE

*._ksb_restart_policy_times='0'

*._ksb_restart_policy_times='60'

*._ksb_restart_policy_times='120'

*._ksb_restart_policy_times='240' # internal update to set default

*._left_nested_loops_random=TRUE

*._local_communication_costing_enabled=TRUE

*._minimal_stats_aggregation=TRUE

*._mmv_query_rewrite_enabled=TRUE

*._new_initial_join_orders=TRUE

*._new_sort_cost_estimate=TRUE

*._nlj_batching_enabled=1

*._optim_adjust_for_part_skews=TRUE

*._optim_enhance_nnull_detection=TRUE

*._optim_new_default_join_sel=TRUE

*._optim_peek_user_binds=TRUE

*._optimizer_adaptive_cursor_sharing=TRUE

*._optimizer_better_inlist_costing='ALL'

*._optimizer_cbqt_no_size_restriction=TRUE

*._optimizer_coalesce_subqueries=TRUE

*._optimizer_complex_pred_selectivity=TRUE

*._optimizer_compute_index_stats=TRUE

*._optimizer_connect_by_combine_sw=TRUE

*._optimizer_connect_by_cost_based=TRUE

*._optimizer_connect_by_elim_dups=TRUE

*._optimizer_correct_sq_selectivity=TRUE

*._optimizer_cost_based_transformation='LINEAR'

*._optimizer_cost_hjsmj_multimatch=TRUE

*._optimizer_cost_model='CHOOSE'

*._optimizer_dim_subq_join_sel=TRUE

*._optimizer_distinct_agg_transform=TRUE

*._optimizer_distinct_elimination=TRUE

*._optimizer_distinct_placement=TRUE

*._optimizer_eliminate_filtering_join=TRUE

*._optimizer_enable_density_improvements=TRUE

*._optimizer_enable_extended_stats=TRUE

*._optimizer_enable_table_lookup_by_nl=TRUE

*._optimizer_enhanced_filter_push=TRUE

*._optimizer_extend_jppd_view_types=TRUE

*._optimizer_extended_cursor_sharing='UDO'

*._optimizer_extended_cursor_sharing_rel='SIMPLE'

*._optimizer_extended_stats_usage_control=192

*._optimizer_false_filter_pred_pullup=TRUE

*._optimizer_fast_access_pred_analysis=TRUE

*._optimizer_fast_pred_transitivity=TRUE

*._optimizer_filter_pred_pullup=TRUE

*._optimizer_fkr_index_cost_bias=10

*._optimizer_full_outer_join_to_outer=TRUE

*._optimizer_group_by_placement=TRUE

*._optimizer_improve_selectivity=TRUE

*._optimizer_interleave_jppd=TRUE

*._optimizer_invalidation_period=60

*._optimizer_join_elimination_enabled=TRUE

*._optimizer_join_factorization=TRUE

*._optimizer_join_order_control=3

*._optimizer_join_sel_sanity_check=TRUE

*._optimizer_max_permutations=2000

*._optimizer_mode_force=TRUE

*._optimizer_multi_level_push_pred=TRUE

*._optimizer_native_full_outer_join='FORCE'

*._optimizer_new_join_card_computation=TRUE

*._optimizer_null_aware_antijoin=TRUE

*._optimizer_or_expansion='DEPTH'

*._optimizer_order_by_elimination_enabled=TRUE

*._optimizer_outer_join_to_inner=TRUE

*._optimizer_outer_to_anti_enabled=TRUE

*._optimizer_push_down_distinct=0

*._optimizer_push_pred_cost_based=TRUE

*._optimizer_rownum_bind_default=10

*._optimizer_rownum_pred_based_fkr=TRUE

*._optimizer_skip_scan_enabled=TRUE

*._optimizer_sortmerge_join_inequality=TRUE

*._optimizer_squ_bottomup=TRUE

*._optimizer_star_tran_in_with_clause=TRUE

*._optimizer_system_stats_usage=TRUE

*._optimizer_table_expansion=TRUE

*._optimizer_transitivity_retain=TRUE

*._optimizer_try_st_before_jppd=TRUE

*._optimizer_undo_cost_change='11.2.0.4'

*._optimizer_unnest_corr_set_subq=TRUE

*._optimizer_unnest_disjunctive_subq=TRUE

*._optimizer_use_cbqt_star_transformation=TRUE

*._optimizer_use_feedback=TRUE

*._or_expand_nvl_predicate=TRUE

*._ordered_nested_loop=TRUE

*._parallel_broadcast_enabled=TRUE

*._partition_view_enabled=TRUE

*._pga_max_size=2G

*._pivot_implementation_method='CHOOSE'

*._pre_rewrite_push_pred=TRUE

*._pred_move_around=FALSE

*._push_join_predicate=TRUE

*._push_join_union_view=TRUE

*._push_join_union_view2=TRUE

*._px_minus_intersect=TRUE

*._px_partition_scan_enabled=TRUE

*._px_pwg_enabled=TRUE

*._px_ual_serial_input=TRUE

*._query_rewrite_setopgrw_enable=TRUE

*._remove_aggr_subquery=TRUE

*._replace_virtual_columns=TRUE

*._resource_manager_plan=''

*._right_outer_hash_enable=TRUE

*._selfjoin_mv_duplicates=TRUE

*._smm_max_size=1048576

*._smm_max_size_static=1048576

*._smm_min_size=1024

orcl1._smm_px_max_size=41943040

orcl2._smm_px_max_size=10485760

orcl1._smm_px_max_size_static=41943040

orcl2._smm_px_max_size_static=10092544

*._sql_model_unfold_forloops='RUN_TIME'

*._sqltune_category_parsed='DEFAULT' # parsed sqltune_category

*._subquery_pruning_enabled=TRUE

*._subquery_pruning_mv_enabled=FALSE

*._table_scan_cost_plus_one=TRUE

*._union_rewrite_for_gs='YES_GSET_MVS'

*._unnest_subquery=TRUE

*._use_adaptive_log_file_sync='FALSE'

*._use_column_stats_for_function=TRUE

*.aq_tm_processes=2

*.archive_lag_target=600

*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'

*.audit_trail='NONE'

orcl1.background_dump_dest='/u01/app/oracle/diag/rdbms/orcl/orcl1/trace' #Deprecate parameter

orcl2.background_dump_dest='/u01/app/oracle/diag/rdbms/orcl/orcl2/trace' #Deprecate parameter

*.cluster_database=TRUE

*.compatible='11.2.0.4.0'

*.control_file_record_keep_time=365

*.control_files='+DATA/orcl/controlfile/current.260.868665887'

*.control_files='+FRA/orcl/controlfile/current.256.868665887'

orcl1.core_dump_dest='/u01/app/oracle/diag/rdbms/orcl/orcl1/cdump'

orcl2.core_dump_dest='/u01/app/oracle/diag/rdbms/orcl/orcl2/cdump'

*.db_block_size=8192

*.db_create_file_dest='+DATA'

*.db_domain=''

*.db_name='orcl'

*.db_recovery_file_dest='+FRA'

*.db_recovery_file_dest_size=2900G

*.diagnostic_dest='/u01/app/oracle'

*.disk_asynch_io=FALSE

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'

*.fal_client='orcl'

*.fal_server='yl_xmk3db3_bak_orcl'

orcl1.instance_number=1

orcl2.instance_number=2

orcl1.local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.16)(PORT = 1521))'

orcl2.local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.17)(PORT = 1521))'

*.log_archive_config='DG_CONFIG=(orcl,yl_xmk3db3_bak_orcl,yl_cdk3db1_bak_orcl)'

*.log_archive_dest_1='LOCATION=+FRA/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl'

*.log_archive_dest_10=''

*.log_archive_dest_2='SERVICE=yl_xmk3db3_bak_orcl LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NA

ME=yl_xmk3db3_bak_orcl'

*.log_archive_dest_3='SERVICE=yl_cdk3db1_bak_orcl LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NA

ME=yl_cdk3db1_bak_orcl'

*.log_archive_dest_4=''

*.log_archive_dest_5=''

*.log_archive_dest_6=''

*.log_archive_dest_7=''

*.log_archive_dest_8=''

*.log_archive_dest_9=''

*.log_archive_dest_state_10='DEFER'

*.log_archive_dest_state_2='DEFER'

*.log_archive_dest_state_3='DEFER'

*.log_archive_dest_state_4='DEFER'

*.log_archive_dest_state_5='DEFER'

*.log_archive_dest_state_6='DEFER'

*.log_archive_dest_state_7='DEFER'

*.log_archive_dest_state_8='DEFER'

*.log_archive_dest_state_9='DEFER'

*.log_archive_format='%t_%s_%r.dbf'

*.log_archive_max_processes=5

orcl1.log_buffer=220790784

orcl2.log_buffer=101105664 # log buffer update

orcl1.memory_max_target=200G

orcl2.memory_max_target=109G

orcl1.memory_target=200G

orcl2.memory_target=109G

*.open_cursors=3000

*.optimizer_dynamic_sampling=4

*.optimizer_mode='ALL_ROWS'

*.parallel_adaptive_multi_user=FALSE

*.plsql_warnings='DISABLE:ALL' # PL/SQL warnings at init.ora

*.processes=1500

*.query_rewrite_enabled='TRUE'

*.remote_listener='yl-xmk3db-scan.yinlu.com:1521'

*.remote_login_passwordfile='EXCLUSIVE'

*.resource_manager_plan='SCHEDULER[0x32DF]:DEFAULT_MAINTENANCE_PLAN'

orcl1.result_cache_max_size=629152K

orcl2.result_cache_max_size=367008K

orcl1.service_names='clouddb'

orcl1.service_names='cloudyl'

orcl2.service_names='cloudyl_preconnect'

orcl2.service_names='clouddb_preconnect'

*.sessions=2304

orcl1.sga_max_size=120G

orcl2.sga_max_size=91904M # internally adjusted

orcl1.sga_target=120G

orcl2.sga_target=70G

*.shared_servers=0

*.skip_unusable_indexes=TRUE

*.standby_archive_dest='+FRA/arch' #Deprecate parameter

*.standby_file_management='AUTO'

orcl1.thread=1

orcl2.thread=2

orcl1.undo_tablespace='UNDOTBS1'

orcl2.undo_tablespace='UNDOTBS2'

orcl1.user_dump_dest='/u01/app/oracle/diag/rdbms/orcl/orcl1/trace' #Deprecate parameter

orcl2.user_dump_dest='/u01/app/oracle/diag/rdbms/orcl/orcl2/trace' #Deprecate parameter

tracer 目录这个点的日志文件

看 FAL 的跟踪文件。

另外，很多原因都可能导致偶尔的错误提示，不频繁的可以忽略。