ORA-16249 master database down, logicalstandby direct change master database

ORA-16249 master database down, logicalstandby direct change master database

ORA-16249 master database down, logical standby direct change master database

ORA-16249 master database down, logical standby direct change master database

[Date: 2013-12-08] Source: Linux community Author: Linux [Font:]

ORA-16249 master database down, logical standby direct change master database

SQL> alter database activate logical standby database finish apply;
Alter database activate logical standby database finish apply
*
ERROR at line 1:
ORA-16249: Terminal apply failed to complete during failover

SQL> alter database activate logical standby database;

Database altered.

SQL> SELECT SWITCHOVER_STATUS FROM V $ DATABASE;

SWITCHOVER_STATUS
--------------------
SESSIONS ACTIVE

SQL> select database_role from v $ database;

DATABASE_ROLE
----------------
PRIMARY

SQL>

Related reading:

ORA-01172, ORA-01151 error handling

ORA-00600 [2662] troubleshooting

Troubleshooting for ORA-01078 and LRM-00109

Notes on ORA-00471 Processing Methods

ORA-00314, redolog corruption, or loss Handling Method

Solution to ORA-00257 archive logs being too large to store

0

ORA-17047 Problem Solving

ORA-01403: no data found, Standby cannot apply