High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Archivelog Sequence not Updated after switching Physical Standby to Primary

We recently switched the physical standby to primary since we had issues with the primary database.


We used the following procedure to do it.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;

--Activate the standby database:

SQL> ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE;

Database altered.

--Open the database:

SQL> ALTER DATABASE OPEN


The database is working as expected but the archivelog sequence is not being reflected when we query the DB

SQL> select max(sequence#) from v$archived_log;


MAX(SEQUENCE#)

--------------

480471


SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center