Have you set
log apply delay (DelayMins)
<http://laurentschneider.com/wordpress/2013/12/changing-the-log-apply-delay-delaymins.html>
Somewhere?
I'm not sure if this is an issue in 11.2 (my memory tells me 12.1 has these
issues)
But it's worth a check.
Hth,
berx
^∆x
On 24 Mar 2017 16:40, "GG" <grzegorzof@xxxxxxxxxx> wrote:
Hi,
looks like funny friday just have started for production switchover.
We are on 11.2.0.3 with latest psu and after
dgmgrl sys/pass@primary
switchover to standby
the switchover command hangs for 40minutes .
For primary database_role is primary for standby database_role is standby
and nothing is going on , except normal redo apply (no gap showed) .
in primary alert log though:
"
Fri Mar 24 15:21:27 2017
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION
SHUTDOWN
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY [Process Id:
28654] (DB_NAME)
Fri Mar 24 15:21:28 2017
LGWR: Standby redo logfile selected to archive thread 1 sequence 70230
LGWR: Standby redo logfile selected for thread 1 sequence 70230 for
destination LOG_ARCHIVE_DEST_2
Thread 1 advanced to log sequence 70230 (LGWR switch)
Current log# 5 seq# 70230 mem# 0: /u04/oradata/DB_NAME/redo05a.log
Current log# 5 seq# 70230 mem# 1: /u04/oradata/DB_NAME/redo05b.log
Fri Mar 24 15:21:28 2017
Stopping background process CJQ0
Fri Mar 24 15:21:28 2017
Archived Log entry 139667 added for thread 1 sequence 70229 ID 0xa380a3ed
dest 1:
"
Part of alert log standby:
"
Fri Mar 24 15:11:51 2017
Archived Log entry 139214 added for thread 1 sequence 70228 ID 0xa380a3ed
dest 1:
Archived Log entry 139215 added for thread 1 sequence 70228 ID 0xa380a3ed
dest 3:
Fri Mar 24 15:21:28 2017
RFS[166]: Selected log 8 for thread 1 sequence 70230 dbid -1555432873
branch 842634839
Fri Mar 24 15:21:28 2017
Archived Log entry 139216 added for thread 1 sequence 70229 ID 0xa380a3ed
dest 1:
Archived Log entry 139217 added for thread 1 sequence 70229 ID 0xa380a3ed
dest 3:
Fri Mar 24 15:21:28 2017
Media Recovery Waiting for thread 1 sequence 70230 (in transit)
Recovery of Online Redo Log: Thread 1 Group 8 Seq 70230 Reading mem 0
Mem# 0: /u04/oradata/DB_NAME/DB_NAME_srl1.f
dgmgrl shows:
DGMGRL> show configuration
Configuration - DB_NAME
Protection Mode: MaxAvailability
Databases:
DB_NAME_L1 - Primary database
DB_NAME_L2 - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
ORA-16534: switchover, failover or convert operation in progress
DGM-17017: unable to determine configuration status
Session stats on primary shows one session related to dgmgrl
which is waiting for ' wait for unread message on broadcast channel'
bcd8d2qdv1kcy 1 SYS dgmgrl@pimlu-db001 (TNS V1-V3) WAITING wait for
unread message on broadcast cha
with SQL text like below :
----------
SQL_TEXT
-----------------------------------------------------------------------------------
BEGIN dbms_drs.do_control_raw(:indoc, utdoc, :rid, ieceno, :context, 1);
END;
We've opened sever 1 but Support did not touch it yet .
I've found some bugs related closely to this which suggests :
1. restart primary
or
2 kill rsm0 process .
Any suggestions greatly appreciated .
Regards .
GG
--
//www.freelists.org/webpage/oracle-l
