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