ITPUB论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 1610|回复: 17

[备份恢复] dataguard备机意外停电后,不再应用日志。(已解决) [复制链接]

注册会员

待富者

精华贴数
0
专家积分
1
技术积分
172
社区积分
0
注册时间
2006-10-16
论坛徽章:
1
ITPUB十周年纪念徽章
日期:2011-11-01 16:23:26
发表于 2013-9-3 13:29:39 |显示全部楼层
本帖最后由 orthon 于 2013-9-3 14:26 编辑

dataguard备机停电

重新启动备机后,停机期间,主机产生的归档日志不再应用到备机,但新产生的日志会被备机读过去,当然也无法应用。

主机的归档日志记录

主机归档日志记录

主机归档日志记录


备机的归档日志记录
SQL> select sequence#,applied from v$archived_log where sequence#>25139 order by 1;

SEQUENCE# APPLIED
---------- ---------
     25140 YES
     25141 YES
     25142 YES
     25143 YES
     25144 YES
     25145 YES
     25146 YES
     25147 YES
     25148 YES
     25149 YES
     25150 YES

SEQUENCE# APPLIED
---------- ---------
     25151 YES
     25152 YES
     25153 YES
     25154 YES
     25155 YES
     25156 YES
     25157 YES
     25158 YES
     25159 YES
     25160 YES
     25161 YES

SEQUENCE# APPLIED
---------- ---------
     25162 YES
     25163 YES
     25164 YES
     25165 YES
     25166 YES
     25167 YES
     25168 YES
     25169 YES
     25170 YES
     25171 YES
     25172 YES

SEQUENCE# APPLIED
---------- ---------
     25173 YES
     25174 YES
     25175 YES
     25176 YES
     25177 YES
     25178 YES
     25179 YES
     25180 YES
     25181 YES
     25182 YES
     25183 YES

SEQUENCE# APPLIED
---------- ---------
     25184 YES
     25185 YES
     25196 NO
     25197 NO
     25198 NO
     25199 NO
     25200 NO
     25201 NO
     25202 NO
     25203 NO
     25205 NO

SEQUENCE# APPLIED
---------- ---------
     25206 NO
     25207 NO
     25208 NO
     25209 NO
     25210 NO

60 rows selected.

见过懒的,没见过像我这么懒的。
遇过废的,没遇过有俺那么废的。

注册会员

待富者

精华贴数
0
专家积分
1
技术积分
172
社区积分
0
注册时间
2006-10-16
论坛徽章:
1
ITPUB十周年纪念徽章
日期:2011-11-01 16:23:26
发表于 2013-9-3 13:30:42 |显示全部楼层
以下为备机的最近一次启动开始的日志

-----------------------------------------------------------------------------------

Tue Sep 03 12:32:57 2013
Starting ORACLE instance (normal)
sskgpgetexecname failed to get name
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
_ksb_restart_policy_times={0,60,120,240}
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =264
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 11.1.0.7.0.
Using parameter settings in server-side spfile /u01/PR12/db/tech_st/11.1.0/dbs/spfilePR12.ora
System parameters with non-default values:
  processes                = 1200
  sessions                 = 2400
  timed_statistics         = TRUE
  sga_max_size             = 32G
  shared_pool_size         = 512M
  shared_pool_reserved_size= 40M
  _ksb_restart_policy_times= "0"
  _ksb_restart_policy_times= "60"
  _ksb_restart_policy_times= "120"
  _ksb_restart_policy_times= "240"
  nls_language             = "american"
  nls_territory            = "america"
  nls_sort                 = "binary"
  nls_date_format          = "DD-MON-RR"
  nls_numeric_characters   = ".,"
  nls_comp                 = "binary"
  nls_length_semantics     = "BYTE"
  resource_manager_plan    = ""
  sga_target               = 32G
  control_files            = "/u01/PR12/db/apps_st/data/cntrl01.dbf"
  control_files            = "/u01/PR12/db/apps_st/data/cntrl02.dbf"
  control_files            = "/u01/PR12/db/apps_st/data/cntrl03.dbf"
  log_file_name_convert    = "/u01/PR12/db/apps_st/data"
  log_file_name_convert    = "/u01/PR12/db/apps_st/data"
  control_file_record_keep_time= 20
  db_block_checksum        = "TRUE"
  db_block_size            = 8192
  compatible               = "11.1.0"
  log_archive_config       = "DG_CONFIG=(pr12_s,pr12)"
  log_archive_dest_1       = "location=/u01/PR12/db/apps_st/data/archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=pr12_t"
  log_archive_dest_2       = "SERVICE=pr12_s LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=pr12"
  log_archive_dest_state_1 = "ENABLE"
  log_archive_dest_state_2 = "ENABLE"
  fal_client               = "pr12_t"
  fal_server               = "pr12_s"
  log_buffer               = 10485760
  log_checkpoint_interval  = 100000
  log_checkpoint_timeout   = 1200
  db_files                 = 512
  standby_file_management  = "AUTO"
  log_checkpoints_to_alert = TRUE
  dml_locks                = 10000
  undo_management          = "AUTO"
  undo_tablespace          = "APPS_UNDOTS1"
  db_block_checking        = "FALSE"
  sec_case_sensitive_logon = FALSE
  remote_login_passwordfile= "EXCLUSIVE"
  session_cached_cursors   = 500
  utl_file_dir             = "/usr/tmp"
  utl_file_dir             = "/u01/PR12/tmp"
  utl_file_dir             = "/u01/PR12/db/tech_st/11.1.0/appsutil/outbound/PR12_proddb"
  utl_file_dir             = "/usr/tmp"
  plsql_native_library_dir = "/u01/PR12/db/tech_st/11.1.0/plsql/nativelib"
  plsql_native_library_subdir_count= 149
  plsql_warnings           = "DISABLE:ALL"
  plsql_code_type          = "INTERPRETED"
  plsql_optimize_level     = 2
  job_queue_processes      = 2
  _system_trig_enabled     = TRUE
  cursor_sharing           = "EXACT"
  parallel_min_servers     = 0
  parallel_max_servers     = 8
  result_cache_max_size    = 4608K
  core_dump_dest           = "/u01/PR12/db/tech_st/11.1.0/admin/PR12_proddb/diag/rdbms/pr12/PR12/cdump"
  db_name                  = "PR12"
  db_unique_name           = "pr12_t"
  open_cursors             = 600
  optimizer_mode           = "ALL_ROWS"
  _optimizer_mode_force    = TRUE
  _sort_elimination_cost_ratio= 5
  _always_anti_join        = "CHOOSE"
  _optimizer_null_aware_antijoin= TRUE
  _partition_view_enabled  = TRUE
  _b_tree_bitmap_plans     = FALSE
  _cpu_to_io               = 0
  _optimizer_extended_cursor_sharing= "UDO"
  _optimizer_extended_cursor_sharing_rel= "SIMPLE"
  _optimizer_adaptive_cursor_sharing= TRUE
  _optimizer_cost_model    = "CHOOSE"
  _optimizer_undo_cost_change= "11.1.0.7"
  _optimizer_system_stats_usage= TRUE
  _new_sort_cost_estimate  = TRUE
  _complex_view_merging    = TRUE
  _unnest_subquery         = TRUE
  _eliminate_common_subexpr= TRUE
  _pred_move_around        = TRUE
  _convert_set_to_join     = FALSE
  _px_ual_serial_input     = TRUE
  _px_minus_intersect      = TRUE
  _remove_aggr_subquery    = TRUE
  _optimizer_push_down_distinct= 0
  _optimizer_cost_based_transformation= "LINEAR"
  _optimizer_squ_bottomup  = TRUE
  _push_join_predicate     = TRUE
  _push_join_union_view    = TRUE
  _push_join_union_view2   = TRUE
  _fast_full_scan_enabled  = FALSE
  _optimizer_skip_scan_enabled= TRUE
  _optimizer_join_sel_sanity_check= TRUE
  _optim_enhance_nnull_detection= TRUE
  _parallel_broadcast_enabled= TRUE
  _always_semi_join        = "CHOOSE"
  _ordered_nested_loop     = TRUE
  _optimizer_max_permutations= 2000
  _nlj_batching_enabled    = 1
  query_rewrite_enabled    = "true"
  _mmv_query_rewrite_enabled= TRUE
  _local_communication_costing_enabled= TRUE
  _left_nested_loops_random= TRUE
  _improved_row_length_enabled= TRUE
  _index_join_enabled      = FALSE
  _enable_type_dep_selectivity= TRUE
  _sqlexec_progression_cost= 2147483647
  _improved_outerjoin_card = TRUE
  _use_column_stats_for_function= TRUE
  _subquery_pruning_enabled= TRUE
  _subquery_pruning_mv_enabled= FALSE
  _or_expand_nvl_predicate = TRUE
  _like_with_bind_as_equality= TRUE
  _table_scan_cost_plus_one= TRUE
  _cost_equality_semi_join = TRUE
  _new_initial_join_orders = TRUE
  _optim_peek_user_binds   = TRUE
  _minimal_stats_aggregation= TRUE
  pga_aggregate_target     = 4G
  _pga_max_size            = 838860K
  workarea_size_policy     = "AUTO"
  _smm_min_size            = 1024
  _smm_max_size            = 419430
  _smm_px_max_size         = 2097152
  _gs_anti_semi_join_allowed= TRUE
  _optim_new_default_join_sel= TRUE
  optimizer_dynamic_sampling= 2
  _pre_rewrite_push_pred   = TRUE
  _optimizer_new_join_card_computation= TRUE
  _union_rewrite_for_gs    = "YES_GSET_MVS"
  _generalized_pruning_enabled= TRUE
  _optim_adjust_for_part_skews= TRUE
  _optimizer_compute_index_stats= TRUE
  _optimizer_autostats_job = FALSE
  _optimizer_push_pred_cost_based= TRUE
  _optimizer_extend_jppd_view_types= TRUE
  _optimizer_filter_pred_pullup= TRUE
  _optimizer_connect_by_cost_based= TRUE
  _optimizer_connect_by_combine_sw= TRUE
  _right_outer_hash_enable = TRUE
  skip_unusable_indexes    = TRUE
  _optimizer_correct_sq_selectivity= TRUE
  _optimizer_dim_subq_join_sel= TRUE
  _query_rewrite_setopgrw_enable= TRUE
  _optimizer_join_order_control= 3
  _bloom_filter_enabled    = TRUE
  _bloom_folding_enabled   = TRUE
  _optimizer_join_elimination_enabled= TRUE
  _gby_hash_aggregation_enabled= TRUE
  _globalindex_pnum_filter_enabled= TRUE
  _sql_model_unfold_forloops= "RUN_TIME"
  _optimizer_cost_hjsmj_multimatch= TRUE
  _optimizer_transitivity_retain= TRUE
  optimizer_secure_view_merging= FALSE
  _px_pwg_enabled          = TRUE
  _optimizer_cbqt_no_size_restriction= TRUE
  _optimizer_enhanced_filter_push= TRUE
  _optimizer_rownum_pred_based_fkr= TRUE
  _optimizer_better_inlist_costing= "ALL"
  _optimizer_or_expansion  = "DEPTH"
  _optimizer_outer_to_anti_enabled= TRUE
  _optimizer_order_by_elimination_enabled= TRUE
  _optimizer_star_tran_in_with_clause= TRUE
  _optimizer_sortmerge_join_inequality= TRUE
  _selfjoin_mv_duplicates  = TRUE
  _dimension_skip_null     = TRUE
  _optimizer_complex_pred_selectivity= TRUE
  _bloom_pruning_enabled   = TRUE
  _first_k_rows_dynamic_proration= TRUE
  _optimizer_distinct_elimination= TRUE
  _optimizer_multi_level_push_pred= TRUE
  _optimizer_group_by_placement= TRUE
  _optimizer_enable_density_improvements= TRUE
  _optimizer_rownum_bind_default= 10
  _optimizer_improve_selectivity= TRUE
  _optimizer_native_full_outer_join= "FORCE"
  _optimizer_enable_extended_stats= TRUE
  _pivot_implementation_method= "CHOOSE"
  _optimizer_fkr_index_cost_bias= 10
  _optimizer_extended_stats_usage_control= 224
  aq_tm_processes          = 1
  olap_page_pool_size      = 4M
  _sqltune_category_parsed = "DEFAULT"
  diagnostic_dest          = "/u01/PR12/db/tech_st/11.1.0/admin/PR12_proddb"
  _trace_files_public      = TRUE
  max_dump_file_size       = "500M"
Tue Sep 03 12:32:59 2013
PMON started with pid=2, OS id=4719072
Tue Sep 03 12:32:59 2013
VKTM started with pid=3, OS id=4784314
VKTM running at (100ms) precision
Tue Sep 03 12:32:59 2013
DIAG started with pid=4, OS id=4194572
Tue Sep 03 12:32:59 2013
DBRM started with pid=5, OS id=4391254
Tue Sep 03 12:33:00 2013
PSP0 started with pid=6, OS id=6946928
Tue Sep 03 12:33:00 2013
DIA0 started with pid=7, OS id=3604876
Tue Sep 03 12:33:00 2013
MMAN started with pid=8, OS id=6881394
Tue Sep 03 12:33:00 2013
DBW0 started with pid=9, OS id=6553704
Tue Sep 03 12:33:00 2013
DBW1 started with pid=10, OS id=2949538
Tue Sep 03 12:33:00 2013
DBW2 started with pid=11, OS id=6029524
Tue Sep 03 12:33:00 2013
DBW3 started with pid=12, OS id=5964008
Tue Sep 03 12:33:00 2013
DBW4 started with pid=13, OS id=5832872
Tue Sep 03 12:33:00 2013
DBW5 started with pid=14, OS id=4325882
Tue Sep 03 12:33:00 2013
DBW6 started with pid=15, OS id=5767274
Tue Sep 03 12:33:00 2013
DBW7 started with pid=16, OS id=5243036
Tue Sep 03 12:33:00 2013
LGWR started with pid=17, OS id=4259948
Tue Sep 03 12:33:00 2013
CKPT started with pid=18, OS id=7536922
Tue Sep 03 12:33:00 2013
SMON started with pid=19, OS id=6619296
Tue Sep 03 12:33:00 2013
RECO started with pid=20, OS id=7405832
Tue Sep 03 12:33:00 2013
MMON started with pid=21, OS id=5308466
Tue Sep 03 12:33:00 2013
MMNL started with pid=22, OS id=7274616
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Tue Sep 03 12:33:09 2013
alter database mount standby database
Setting recovery target incarnation to 2
ARCH: STARTING ARCH PROCESSES
Tue Sep 03 12:33:13 2013
ARC0 started with pid=24, OS id=6881784
Tue Sep 03 12:33:13 2013
ARC1 started with pid=25, OS id=9830432
Tue Sep 03 12:33:13 2013
ARC2 started with pid=26, OS id=10813570
ARC0: Archival started
Tue Sep 03 12:33:13 2013
ARC3 started with pid=27, OS id=7012470
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC0: Thread not mounted
ARC2: Becoming the heartbeat ARCH
ARC2: Thread not mounted
ARC1: Thread not mounted
ARC3: Thread not mounted
Tue Sep 03 12:33:13 2013
Successful mount of redo thread 1, with mount id 2815597189
Physical Standby Database mounted.
Lost write protection disabled
Completed: alter database mount standby database
Tue Sep 03 12:33:22 2013
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION
Attempt to start background Managed Standby Recovery process (PR12)
Tue Sep 03 12:33:22 2013
MRP0 started with pid=28, OS id=6816242
MRP0: Background Managed Standby Recovery process started (PR12)
Tue Sep 03 12:33:24 2013
Using STANDBY_ARCHIVE_DEST parameter default value as /u01/PR12/db/apps_st/data/archive
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[1]: Assigned to RFS process 11337868
RFS[1]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
RFS LogMiner: Client disabled from further notification
Primary database is in MAXIMUM PERFORMANCE mode
kcrrvslf: inactive RFS archival for log 5 thread 1 sequence 25204
kcrrvslf: inactive RFS archival for log 6 thread 1 sequence 25186
RFS[1]: Successfully opened standby log 4: '/u01/PR12/db/apps_st/data/standbylg01.log'
Fast Parallel Media Recovery enabled
Managed Standby Recovery starting Real Time Apply
parallel recovery started with 63 processes
Tue Sep 03 12:33:31 2013
Warning: recovery process PR00 cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR01 cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR02 cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR03 cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR04 cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR05 cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR06 cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR07 cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR08 cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR09 cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0A cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0B cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0C cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0D cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0E cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0F cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0G cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0H cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0I cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0J cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0K cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0L cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0M cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0N cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0O cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0P cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0Q cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0R cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0S cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0T cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0U cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0V cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0W cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0X cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0Y cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR0Z cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR10 cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR11 cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR12 cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR13 cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR14 cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR15 cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR16 cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR17 cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR18 cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR19 cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR1A cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR1B cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR1C cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR1D cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR1E cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR1F cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR1G cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR1H cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR1I cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR1J cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR1K cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR1L cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR1M cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR1N cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR1O cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR1P cannot use async I/O
Tue Sep 03 12:33:31 2013
Warning: recovery process PR1Q cannot use async I/O
Tue Sep 03 12:33:31 2013
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[2]: Assigned to RFS process 8257880
RFS[2]: Identified database type as 'physical standby'
kcrrvslf: active RFS archival for log 4 thread 1 sequence 25206
kcrrvslf: inactive RFS archival for log 5 thread 1 sequence 25204
kcrrvslf: inactive RFS archival for log 6 thread 1 sequence 25186
RFS[2]: Successfully opened standby log 5: '/u01/PR12/db/apps_st/data/standbylg02.log'
Waiting for all non-current ORLs to be archived...
Recovery of Online Redo Log: Thread 1 Group 6 Seq 25186 Reading mem 0
  Mem# 0: /u01/PR12/db/apps_st/data/standbylg03.log
Tue Sep 03 12:33:32 2013
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION
Tue Sep 03 12:35:23 2013
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[3]: Assigned to RFS process 4653350
RFS[3]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
Re-archiving standby log 4 thread 1 sequence 25206
Primary database is in MAXIMUM PERFORMANCE mode
kcrrvslf: active RFS archival for log 4 thread 1 sequence 25206
kcrrvslf: inactive RFS archival for log 6 thread 1 sequence 25186
RFS[3]: Successfully opened standby log 5: '/u01/PR12/db/apps_st/data/standbylg02.log'
Tue Sep 03 12:37:43 2013
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[4]: Assigned to RFS process 7143598
RFS[4]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
Re-archiving standby log 5 thread 1 sequence 25207
Primary database is in MAXIMUM PERFORMANCE mode
kcrrvslf: active RFS archival for log 5 thread 1 sequence 25207
kcrrvslf: inactive RFS archival for log 6 thread 1 sequence 25186
RFS[4]: Successfully opened standby log 4: '/u01/PR12/db/apps_st/data/standbylg01.log'
Tue Sep 03 12:39:53 2013
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[5]: Assigned to RFS process 6947112
RFS[5]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
Re-archiving standby log 4 thread 1 sequence 25208
Primary database is in MAXIMUM PERFORMANCE mode
kcrrvslf: active RFS archival for log 4 thread 1 sequence 25208
kcrrvslf: inactive RFS archival for log 6 thread 1 sequence 25186
RFS[5]: Successfully opened standby log 5: '/u01/PR12/db/apps_st/data/standbylg02.log'
Tue Sep 03 12:49:59 2013
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[6]: Assigned to RFS process 8716652
RFS[6]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
Re-archiving standby log 5 thread 1 sequence 25209
Primary database is in MAXIMUM PERFORMANCE mode
kcrrvslf: active RFS archival for log 5 thread 1 sequence 25209
kcrrvslf: inactive RFS archival for log 6 thread 1 sequence 25186
RFS[6]: Successfully opened standby log 4: '/u01/PR12/db/apps_st/data/standbylg01.log'
Tue Sep 03 13:13:42 2013
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[7]: Assigned to RFS process 10027438
RFS[7]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
Re-archiving standby log 4 thread 1 sequence 25210
Primary database is in MAXIMUM PERFORMANCE mode
kcrrvslf: active RFS archival for log 4 thread 1 sequence 25210
kcrrvslf: inactive RFS archival for log 6 thread 1 sequence 25186
RFS[7]: Successfully opened standby log 5: '/u01/PR12/db/apps_st/data/standbylg02.log'
见过懒的,没见过像我这么懒的。
遇过废的,没遇过有俺那么废的。

使用道具 举报

精华贴数
2
专家积分
163
技术积分
14211
社区积分
9
注册时间
2006-4-19
论坛徽章:
65
目光如炬
日期:2014-09-22 06:00:132013年新春福章
日期:2013-05-27 10:23:002013年新春福章
日期:2013-05-27 10:23:00茶鸡蛋
日期:2013-04-27 14:26:082013年新春福章
日期:2013-02-25 14:51:24ITPUB元老
日期:2013-06-25 09:38:55咸鸭蛋
日期:2013-02-27 15:22:55奥运纪念徽章
日期:2012-12-06 09:21:40鲜花蛋
日期:2012-11-23 14:00:012013年新春福章
日期:2013-04-08 17:42:48ITPUB 11周年纪念徽章
日期:2012-10-09 18:06:20奥运会纪念徽章:射箭
日期:2012-08-20 14:15:04
发表于 2013-9-3 13:32:31 |显示全部楼层
备库你是怎么重启应用日志操作的,请把操作步骤列出来?

使用道具 举报

精华贴数
2
专家积分
163
技术积分
14211
社区积分
9
注册时间
2006-4-19
论坛徽章:
65
目光如炬
日期:2014-09-22 06:00:132013年新春福章
日期:2013-05-27 10:23:002013年新春福章
日期:2013-05-27 10:23:00茶鸡蛋
日期:2013-04-27 14:26:082013年新春福章
日期:2013-02-25 14:51:24ITPUB元老
日期:2013-06-25 09:38:55咸鸭蛋
日期:2013-02-27 15:22:55奥运纪念徽章
日期:2012-12-06 09:21:40鲜花蛋
日期:2012-11-23 14:00:012013年新春福章
日期:2013-04-08 17:42:48ITPUB 11周年纪念徽章
日期:2012-10-09 18:06:20奥运会纪念徽章:射箭
日期:2012-08-20 14:15:04
发表于 2013-9-3 13:34:56 |显示全部楼层
另外你可以手动recover standby database;看看应用结果。

使用道具 举报

注册会员

待富者

精华贴数
0
专家积分
1
技术积分
172
社区积分
0
注册时间
2006-10-16
论坛徽章:
1
ITPUB十周年纪念徽章
日期:2011-11-01 16:23:26
发表于 2013-9-3 13:47:30 |显示全部楼层
jieyancai 发表于 2013-9-3 13:32
备库你是怎么重启应用日志操作的,请把操作步骤列出来?

启动数据库至nomount状态
>startup nomount

mount数据库到standby状态
>alter database mount standby database;

开始日志恢复
>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

启动数据库监听器
/u01/PR12/db/tech_st/11.1.0/appsutil/scripts/PR12_proddb/addlnctl.sh start PR12
见过懒的,没见过像我这么懒的。
遇过废的,没遇过有俺那么废的。

使用道具 举报

精华贴数
2
专家积分
163
技术积分
14211
社区积分
9
注册时间
2006-4-19
论坛徽章:
65
目光如炬
日期:2014-09-22 06:00:132013年新春福章
日期:2013-05-27 10:23:002013年新春福章
日期:2013-05-27 10:23:00茶鸡蛋
日期:2013-04-27 14:26:082013年新春福章
日期:2013-02-25 14:51:24ITPUB元老
日期:2013-06-25 09:38:55咸鸭蛋
日期:2013-02-27 15:22:55奥运纪念徽章
日期:2012-12-06 09:21:40鲜花蛋
日期:2012-11-23 14:00:012013年新春福章
日期:2013-04-08 17:42:48ITPUB 11周年纪念徽章
日期:2012-10-09 18:06:20奥运会纪念徽章:射箭
日期:2012-08-20 14:15:04
发表于 2013-9-3 13:56:37 |显示全部楼层
pr12_t目录貌似缺少25186到25195之间的归档日志,请检查一下吧。

使用道具 举报

注册会员

待富者

精华贴数
0
专家积分
1
技术积分
172
社区积分
0
注册时间
2006-10-16
论坛徽章:
1
ITPUB十周年纪念徽章
日期:2011-11-01 16:23:26
发表于 2013-9-3 14:03:33 |显示全部楼层
jieyancai 发表于 2013-9-3 13:56
pr12_t目录貌似缺少25186到25195之间的归档日志,请检查一下吧。

归档确实没自动拷贝过来

但我有手动拷贝了25186,但是还是不会自动应用
见过懒的,没见过像我这么懒的。
遇过废的,没遇过有俺那么废的。

使用道具 举报

精华贴数
2
专家积分
163
技术积分
14211
社区积分
9
注册时间
2006-4-19
论坛徽章:
65
目光如炬
日期:2014-09-22 06:00:132013年新春福章
日期:2013-05-27 10:23:002013年新春福章
日期:2013-05-27 10:23:00茶鸡蛋
日期:2013-04-27 14:26:082013年新春福章
日期:2013-02-25 14:51:24ITPUB元老
日期:2013-06-25 09:38:55咸鸭蛋
日期:2013-02-27 15:22:55奥运纪念徽章
日期:2012-12-06 09:21:40鲜花蛋
日期:2012-11-23 14:00:012013年新春福章
日期:2013-04-08 17:42:48ITPUB 11周年纪念徽章
日期:2012-10-09 18:06:20奥运会纪念徽章:射箭
日期:2012-08-20 14:15:04
发表于 2013-9-3 14:03:49 |显示全部楼层
本帖最后由 jieyancai 于 2013-9-3 14:05 编辑
orthon 发表于 2013-9-3 14:03
归档确实没自动拷贝过来

但我有手动拷贝了25186,但是还是不会自动应用


需要手动注册一下
ALTER DATABASE REGISTER PHYSICAL LOGFILE '文件位置';

使用道具 举报

注册会员

待富者

精华贴数
0
专家积分
1
技术积分
172
社区积分
0
注册时间
2006-10-16
论坛徽章:
1
ITPUB十周年纪念徽章
日期:2011-11-01 16:23:26
发表于 2013-9-3 14:05:23 |显示全部楼层
jieyancai 发表于 2013-9-3 14:03
需要手动注册一下

这个,从来没有做过手动注册,以前故障停机后,启动备机就会自动同步了。

该怎么做呢?
见过懒的,没见过像我这么懒的。
遇过废的,没遇过有俺那么废的。

使用道具 举报

精华贴数
2
专家积分
163
技术积分
14211
社区积分
9
注册时间
2006-4-19
论坛徽章:
65
目光如炬
日期:2014-09-22 06:00:132013年新春福章
日期:2013-05-27 10:23:002013年新春福章
日期:2013-05-27 10:23:00茶鸡蛋
日期:2013-04-27 14:26:082013年新春福章
日期:2013-02-25 14:51:24ITPUB元老
日期:2013-06-25 09:38:55咸鸭蛋
日期:2013-02-27 15:22:55奥运纪念徽章
日期:2012-12-06 09:21:40鲜花蛋
日期:2012-11-23 14:00:012013年新春福章
日期:2013-04-08 17:42:48ITPUB 11周年纪念徽章
日期:2012-10-09 18:06:20奥运会纪念徽章:射箭
日期:2012-08-20 14:15:04
发表于 2013-9-3 14:06:16 |显示全部楼层
orthon 发表于 2013-9-3 14:05
这个,从来没有做过手动注册,以前故障停机后,启动备机就会自动同步了。

该怎么做呢?

ALTER DATABASE REGISTER PHYSICAL LOGFILE '归档日志文件位置';


使用道具 举报


您需要登录后才可以回帖 登录 | 注册

TOP技术积分榜 社区积分榜 徽章 电子杂志 团队 统计 邮箱 虎吧 老博客 知识索引树 读书频道 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档 | IT博客
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛 | IXPUB | SAP ERP系统
CopyRight 1999-2011 itpub.net All Right Reserved. 北京皓辰网域网络信息技术有限公司版权所有 联系我们 网站律师 隐私政策 知识产权声明
京ICP证:060528号 北京市公安局海淀分局网监中心备案编号:1101082001 广播电视节目制作经营许可证:编号(京)字第1149号
  
回顶部