Category: Dataguard

Dataguard, Dataguard, General DBA

How to tell/find if the instance is Primary/Standby?

By querying v$database one can tell if the host is primary or standby For primary testdb> select database_role from v$database; DATABASE_ROLE —————- PRIMARY For Standby – Note you may need to connect to as sys as sysdba if the instance is in mount state testd> select database_role from v$database; DATABASE_ROLE —————- PHYSICAL STANDBY OR On Primary database the value of controlfile_type in V$database is “CURRENT” … Continue reading How to tell/find if the instance is Primary/Standby?

Alex LimaLeave a comment
Dataguard, General DBA

Dataguard ORA-16817

If you have an issue where the server where standby resides had to be restarted and when you try to enable Fast Start Failover, it wouldn’t enable due to ORA-16608 and when checking the primary database in dataguard it would return ORA-16817 “unsynchronized fast-start failover configuration” Example: $ dgmgrl / DGMGRL> enable configuration Enabled. DGMGRL> show configuration verbose Configuration Name: FSF Enabled: YES Protection Mode: … Continue reading Dataguard ORA-16817

Alex Lima1 Comment