ORACLE技术论坛(停用)–请到ask.orasos.com提问

Please consider registering
guest

Log In

Lost password?
Advanced Search:

— Forum Scope —



— Match —



— Forum Options —




Wildcard usage:
*  matches any number of characters    %  matches exactly one character

Minimum search word length is 4 characters - maximum search word length is 84 characters

Topic RSS Related Topics
kcrrvslf: inactive RFS archival for log 故障解决
2013 年 09 月 23 日
22:46
xff
Guest
win 11.1.0.7的dg备库因为重启,出现dg不能应用日志,出现kcrrvslf: inactive RFS archival for log 11 thread 1 sequence 397错误,解决方案如下:红色部分表示故障原因,加粗部分表示解决方案
 
Mon Sep 23 16:42:10 2013
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[4]: Assigned to RFS process 32176
RFS[4]: Identified database type as 'physical standby'
kcrrvslf: inactive RFS archival for log 11 thread 1 sequence 397
kcrrvslf: active RFS archival for log 12 thread 1 sequence 402
RFS[4]: Successfully opened standby log 10: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\STD_REDO10.LOG'
Mon Sep 23 17:44:48 2013
alter database clear logfile group 11
ORA-1156 signalled during: alter database clear logfile group 11…
Mon Sep 23 17:47:05 2013
alter database recover managed standby database cancel
Mon Sep 23 17:47:05 2013
MRP0: Background Media Recovery cancelled with status 16037
Errors in file d:\app\administrator\diag\rdbms\orcldg\orcl\trace\orcl_mrp0_8332.trc:
ORA-16037: user requested cancel of managed recovery operation
Managed Standby Recovery not using Real Time Apply
Shutting down recovery slaves due to error 16037
Recovery interrupted!
Waiting for MRP0 pid 8332 to terminate
Errors in file d:\app\administrator\diag\rdbms\orcldg\orcl\trace\orcl_mrp0_8332.trc:
ORA-16037: user requested cancel of managed recovery operation
Completed: alter database recover managed standby database cancel
alter database clear logfile group 11
Clearing online log 11 of thread 1 sequence number 397
Completed: alter database clear logfile group 11
Mon Sep 23 17:47:40 2013
alter database recover managed standby database using current logfile disconnect from session
Mon Sep 23 17:47:40 2013
MRP0 started with pid=38, OS id=31344 
Fast Parallel Media Recovery enabled
Managed Standby Recovery starting Real Time Apply
 parallel recovery started with 7 processes
Waiting for all non-current ORLs to be archived…
Completed: alter database recover managed standby database using current logfile disconnect from session
Media Recovery Waiting for thread 1 sequence 397
Fetching gap sequence in thread 1, gap sequence 397-397
Mon Sep 23 17:47:49 2013
RFS[4]: Archived Log: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\ARCHIVELOG\1_397_823862483.ARC'
Mon Sep 23 17:48:17 2013
Media Recovery Log D:\APP\ADMINISTRATOR\ORADATA\ORCL\ARCHIVELOG\1_397_823862483.ARC
Media Recovery Log D:\APP\ADMINISTRATOR\ORADATA\ORCL\ARCHIVELOG\1_398_823862483.ARC
Media Recovery Waiting for thread 1 sequence 399
Fetching gap sequence in thread 1, gap sequence 399-399
Mon Sep 23 17:48:18 2013
RFS[4]: Archived Log: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\ARCHIVELOG\1_399_823862483.ARC'
Mon Sep 23 17:48:49 2013
Media Recovery Log D:\APP\ADMINISTRATOR\ORADATA\ORCL\ARCHIVELOG\1_399_823862483.ARC
Media Recovery Log D:\APP\ADMINISTRATOR\ORADATA\ORCL\ARCHIVELOG\1_400_823862483.ARC
Media Recovery Log D:\APP\ADMINISTRATOR\ORADATA\ORCL\ARCHIVELOG\1_401_823862483.ARC
Mon Sep 23 17:49:02 2013
Media Recovery Log D:\APP\ADMINISTRATOR\ORADATA\ORCL\ARCHIVELOG\1_402_823862483.ARC
Mon Sep 23 17:49:19 2013
Media Recovery Waiting for thread 1 sequence 403 (in transit)
Recovery of Online Redo Log: Thread 1 Group 10 Seq 403 Reading mem 0
  Mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\STD_REDO10.LOG
 

评论功能已关闭。