DataGuard Protection Mod Değiştirme
1 min readSep 5, 2022
DataGuard protection modları aşağıdaki tabloda kısaca açıklanmıştır.
Maximum Protection Mod :
Maksimum Protection olarak değiştirilecekse veya Maksimum Performance’tan Maksimum Availability olarak değiştiriliyorsa, primary veritabanı kapatılır ve mount modda yeniden açılır.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=orclstby SYNC VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE) DB_UNIQUE_NAME=ORCLSTBY';SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PROTECTION;
SQL> ALTER DATABASE OPEN;
DataGuard kontrol edilir. Protection modu MAXIMUM PROTECTION olarak değişmiştir.
SQL> select name,database_role,open_mode,protection_mode from v$database;NAME |DATABASE_ROLE |OPEN_MODE |PROTECTION_MODE
---------|----------------|--------------------|--------------------
ORCL |PHYSICAL STANDBY|MOUNTED |MAXIMUM PROTECTION
Maximum Availability Mod :
SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE AVAILABILITY;SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=orclstby LGWR SYNC NET_TIMEOUT=90 REOPEN=15 VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE) DB_UNIQUE_NAME=ORCLSTBY';SQL> select name,database_role,open_mode,protection_mode from v$database; --> DataGuardNAME |DATABASE_ROLE |OPEN_MODE |PROTECTION_MODE
---------|----------------|--------------------|--------------------
ORCL |PHYSICAL STANDBY|MOUNTED |MAXIMUM AVAILABILITY
Maximum Performance Mod :
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=orclstby ASYNC VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE) DB_UNIQUE_NAME=ORCLSTBY';SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;SQL> select name,database_role,open_mode,protection_mode from v$database; --> DataGuardNAME |DATABASE_ROLE |OPEN_MODE |PROTECTION_MODE
---------|----------------|--------------------|--------------------
ORCL |PHYSICAL STANDBY|MOUNTED |MAXIMUM PERFORMANCE