Broker configuration show ROLLING DATABASE MAINTENANCE IN PROGRESS after upgrade using dbms_rolling procedure

After executing an upgrade exercise in a dataguard environment (19c), the broker was still showing the status: “ROLLING DATABASE MAINTENANCE IN PROGRESS” This is due to a bug: Bug 26921039 – INCORRECT DGMGRL SHOW CONFIGURATION STATUS AFTER POST ROLLING UPGRADE SWITCHOVER Solution is simple: Execute the following statement on PRIMARY database and bounce it: Let’s…

ORA-16631: operation requires shutdown of database or instance

On short, after upgrading one of my databases from 11203 to 11204, I’ve noticed that the standby database was in a DISABLED state:   DGMGRL> show configuration Configuration – DG_CONFIG Protection Mode: MaxPerformance Databases: DB_PRI- Primary database DB_STANDBY – Physical standby database (disabled) Fast-Start Failover: DISABLED Configuration Status: SUCCESS   I tried to set it…

ORA-01203: wrong incarnation of this file – wrong creation SCN

Like in everyone else’s life, this kind of “happiness” is happening. This is what I got on one of my test STANDBY databases while I was trying to start the Recovery Manager: Managed Standby Recovery starting Real Time Apply Read of datafile ‘/u01/oradata/DB/filename.dbf’ (fno 113) header failed with ORA-01203 Rereading datafile 113 header failed with…

Changing SYS Password in Dataguard Environment

If you change SYS password with ALTER USER SYS IDENTIFIED BY NEWPASSWORD on the primary database of a dataguard environment, primary side stops to transfer archivelogs to standby and you will see an error on primary database alertlog file like: —————————————————————— Check that the primary and standby are using a password file and remote_login_passwordfile is…

Dataguard missing archivelog

Below you can find one of the available solutions that can be applied to solve this issue: PRI select max(sequence#) from v$archived_log where applied=’YES’; STBY select max(sequence#) from v$archived_log where applied=’YES’; SQL> select * from v$archive_gap;    THREAD# LOW_SEQUENCE# HIGH_SEQUENCE# ———- ————- ————–          1          285           285 RMAN> list ARCHIVELOG FROM SEQUENCE 286 until SEQUENCE…