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;

謝謝！

總結

以上是生活随笔為你收集整理的oracle备库重启后失去连接,关于dataguard备库宕机后重启后的问题的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。