Hi,
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit
Data Guard environment:
Primary: pdb1
Far Sync:fdb1
Standby: sdb1
Primary --sync---> Far Sync ---async---> Standby
| ^
| |
+----------alternate--async----------------
on standby:
SQL> SELECT UNIQUE THREAD# AS THREAD, MAX(SEQUENCE#) OVER (PARTITION BY thread#) AS LAST from V$ARCHIVED_LOG;
THREAD LAST
---------- ----------
1 494
SQL> select open_mode, switchover_status, database_role from v$database;
OPEN_MODE SWITCHOVER_STATUS DATABASE_ROLE
-------------------- -------------------- ----------------
READ ONLY WITH APPLY NOT ALLOWED PHYSICAL STANDBY
SQL> select * from v$archive_gap ;
no rows selected
on primary:
SQL> select open_mode, switchover_status, database_role from v$database;
OPEN_MODE SWITCHOVER_STATUS DATABASE_ROLE
-------------------- -------------------- ----------------
READ WRITE TO STANDBY PRIMARY
SQL> select DEST_ID,DEST_NAME,STATUS,TARGET,DESTINATION,ERROR,ALTERNATE from v$archive_dest where DESTINATION is not null;
DEST_ID DEST_NAME STATUS TARGET DESTINATION ERROR ALTERNATE
---------- -------------------- --------- ------- ------------------------- ----- ------------------
1 LOG_ARCHIVE_DEST_1 VALID PRIMARY USE_DB_RECOVERY_FILE_DEST NONE
2 LOG_ARCHIVE_DEST_2 VALID STANDBY fdb1 LOG_ARCHIVE_DEST_3
3 LOG_ARCHIVE_DEST_3 ALTERNATE STANDBY sdb1 LOG_ARCHIVE_DEST_2
SQL> SELECT UNIQUE THREAD# AS THREAD, MAX(SEQUENCE#) OVER (PARTITION BY thread#) AS LAST from V$ARCHIVED_LOG;
THREAD LAST
---------- ----------
1 494
SQL> alter database commit to switchover to physical standby with session shutdown;
alter database commit to switchover to physical standby with session shutdown
*
ERROR at line 1:
ORA-16416: No viable Physical Standby switchover targets available
primary alert.log file:
alter database commit to switchover to physical standby with session shutdown
Wed Jul 06 10:39:37 2016
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY [Process Id: 27927] (pdb1)
Wed Jul 06 10:39:37 2016
Waiting for target standby to receive all redo
Wed Jul 06 10:39:37 2016
Waiting for all non-current ORLs to be archived...
Wed Jul 06 10:39:37 2016
All non-current ORLs have been archived.
Wed Jul 06 10:39:37 2016
Waiting for all FAL entries to be archived...
Wed Jul 06 10:39:37 2016
All FAL entries have been archived.
Wed Jul 06 10:39:37 2016
Waiting for potential Physical Standby switchover target to become synchronized...
No viable Physical Standby switchover targets available
ORA-16416 signalled during: alter database commit to switchover to physical standby with session shutdown...
standby is synchronized with the primary.
Any idea what is wrong?
Message was edited by: Yossi.Nixon