Browse Docs

๐Ÿ”„ Data Guard

August 4, 2024 1 min read Memo Databases
On this page

Synchronisation mechanism between two databases in Active/Passive.

Switchover

1dgmgrl sys@orcl
2DGMGRL> switchover to 'orcl';

Check primary / standby

1echo -e "set heading off;\n select database_role FROM v\$database;" | sqlplus -S / as sysdba
2# PHYSICAL STANDBY   (or PRIMARY)
3
4echo -e "set heading off;\n select open_mode FROM v\$database;" | sqlplus -S / as sysdba
5# MOUNTED             (a standby is mounted, not open)
  • PRIMARY + READ WRITE โ†’ primary.
  • PHYSICAL STANDBY + MOUNTED โ†’ standby.
Sunday, October 4, 2026 Sunday, August 4, 2024
๐Ÿ“ฆ Export / Import (Data Pump)
๐Ÿšš Move / Clone a Database