iori809 发表于 2011-10-3 13:06
看你的archive log的sequence已经大于3913了~
你的alert输出什么呢？显示一直在 recover 3913还是？
你可 ...
是的，目前archivelog的sequence已经大于3913了
alter的输入如下：
Physical Standby Database mounted.
Completed: ALTER DATABASE MOUNT
Sun Oct 2 18:11:50 2011
Using STANDBY_ARCHIVE_DEST parameter default value as +FRADG
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[1]: Assigned to RFS process 18621
RFS[1]: Identified database type as 'physical standby'
Sun Oct 2 18:11:50 2011
RFS LogMiner: Client disabled from further notification
RFS[1]: Archived Log: '+FRADG/surf_st/archivelog/2011_10_02/thread_2_seq_3897.2744.763495911'
Sun Oct 2 18:14:52 2011
alter database recover managed standby database using current logfile disconnect from session
Sun Oct 2 18:14:52 2011
Attempt to start background Managed Standby Recovery process (surf1)
MRP0 started with pid=31, OS id=19755
Sun Oct 2 18:14:52 2011
MRP0: Background Managed Standby Recovery process started (surf1)
Sun Oct 2 18:14:57 2011
Managed Standby Recovery starting Real Time Apply
Sun Oct 2 18:15:00 2011
parallel recovery started with 15 processes
Sun Oct 2 18:15:01 2011
Waiting for all non-current ORLs to be archived...
Media Recovery Log +FRADG/surf_st/archivelog/2011_10_02/thread_2_seq_3897.2744.763495911
Sun Oct 2 18:15:02 2011
Completed: alter database recover managed standby database using current logfile disconnect from session
Sun Oct 2 18:15:02 2011
Recovery of Online Redo Log: Thread 1 Group 15 Seq 3913 Reading mem 0
Mem# 0: +DATADG/surf_st/onlinelog/group_15.284.731905313
Mem# 1: +FRADG/surf_st/onlinelog/group_15.364.731905315
Sun Oct 2 18:21:08 2011
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[2]: Assigned to RFS process 22148
RFS[2]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
Primary database is in MAXIMUM PERFORMANCE mode
RFS[2]: Successfully opened standby log 13: '+DATADG/surf_st/onlinelog/group_13.301.731905305'
Sun Oct 2 18:25:36 2011
db_recovery_file_dest_size of 20480 MB is 55.22% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Sun Oct 2 18:27:58 2011
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[3]: Assigned to RFS process 24732
RFS[3]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
Primary database is in MAXIMUM PERFORMANCE mode
RFS[3]: Successfully opened standby log 20: '+DATADG/surf_st/onlinelog/group_20.266.731905335'
Sun Oct 2 18:28:13 2011
RFS[1]: Successfully opened standby log 21: '+DATADG/surf_st/onlinelog/group_21.270.731905339'
Sun Oct 2 18:31:22 2011
Primary database is in MAXIMUM PERFORMANCE mode
RFS[3]: Successfully opened standby log 21: '+DATADG/surf_st/onlinelog/group_21.270.731905339'
Mon Oct 3 05:00:15 2011
Primary database is in MAXIMUM PERFORMANCE mode
RFS[3]: Successfully opened standby log 20: '+DATADG/surf_st/onlinelog/group_20.266.731905335'
Mon Oct 3 05:00:28 2011
Primary database is in MAXIMUM PERFORMANCE mode
RFS[2]: Successfully opened standby log 14: '+DATADG/surf_st/onlinelog/group_14.285.731905309'
Mon Oct 3 05:00:51 2011
Primary database is in MAXIMUM PERFORMANCE mode
RFS[2]: Successfully opened standby log 16: '+DATADG/surf_st/onlinelog/group_16.271.731905319'
Mon Oct 3 05:01:04 2011
Primary database is in MAXIMUM PERFORMANCE mode
RFS[3]: Successfully opened standby log 21: '+DATADG/surf_st/onlinelog/group_21.270.731905339'
你说的停止应用再应用
是不是将备库执行如下操作：
alter database recover managed standby database cancel;
alter database recover managed standby database using current logfile disconnect from session;
谢谢！