Oracle 10g elastic uard Switch

Environment:

OS: rhel 6.3 _ 64bit

DB: Oracle 10gR2

Level switching process:

Master Database

SQL> select protection_mode, protection_level from v $ database;

PROTECTION_MODE PROTECTION_LEVEL
----------------------------------------
MAXIMUM PERFORMANCE
SQL> show parameter log_archive_dest_2

NAME TYPE VALUE
-----------------------------------------------------------------------------
Log_archive_dest_2 string SERVICE = stdy LGWR ASYNC VALI
D_FOR = (ONLINE_LOGFILES, PRIMARY
_ ROLE) DB_UNIQUE_NAME = stdy
SQL> alter system set log_archive_dest_2 = 'service = stdy OPTIONAL LGWR SYNC affrem VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = stdy ';

System altered.
: Maximize and {PROTECTION | AVAILABILITY | PERFORMANCE} correspond to the maximum PROTECTION, maximum AVAILABILITY, and maximum PERFORMANCE respectively.
Minimum Requirements for Maximum Protection Mode
Redo Archival Process LGWR
Network Transmission Mode SYNC
Disk Write Option affrem
Standby Redo Logs? Yes
Standby Database Type Physical Only
 
Alter system set log_archive_dest_2 = 'service = stdy optional lgwr sync affrem VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = stdy ';
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 213909504 bytes
Fixed Size 2095152 bytes
Variable Size 88082384 bytes
Database Buffers 117440512 bytes
Redo Buffers 6291456 bytes
Database mounted.
SQL> alter database set standby database to maximize Protection;

Database altered.
Sys @ ORA> select protection_mode, protection_level from v $ database;

PROTECTION_MODE PROTECTION_LEVEL
----------------------------------------
MAXIMUM PROTECTION UNPROTECTED
SQL> alter database open;

Database altered.

SQL> select protection_mode, protection_level from v $ database;

PROTECTION_MODE PROTECTION_LEVEL
----------------------------------------
MAXIMUM PROTECTION

Minimum Requirements for Maximum Availability Mode
Redo Archival Process LGWR
Network Transmission Mode SYNC
Disk Write Option affrem
Standby Redo Logs? Required for physical standby databases only. Standby redo logs are not supported for logical standby databases.
Standby Database Type Physical or Logical

Alter system set log_archive_dest_2 = 'service = stdy optional lgwr sync affrem VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = stdy ';
Alter database set standby database to maximize Availability;

Minimum Requirements for Maximum Performance Mode
Redo Archival Process LGWR or ARCH
Network Transmission Mode ASYNC when using LGWR process. Not applicable when using the ARCH process.
Disk Write Option noaffrem
Standby Redo Logs? Required for physical standby databases using the LGWR process.
Standby Database Type Physical or Logical

Alter system set log_archive_dest_2 = 'service = stdy optional lgwr async noaffrem VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = stdy ';
Alter database set standby database to maximize Performance;
 
SQL> alter database set standby database to maximize availability;

Database altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 213909504 bytes
Fixed Size 2095152 bytes
Variable Size 88082384 bytes
Database Buffers 117440512 bytes
Redo Buffers 6291456 bytes
Database mounted.
Database opened.
SQL> select protection_mode, protection_level from v $ database;

PROTECTION_MODE PROTECTION_LEVEL
----------------------------------------
MAXIMUM AVAILABILITY

Slave Database
After the slave database is stopped, the status of the master database changes to the State to be synchronized.

SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.

SQL> select protection_mode, protection_level from v $ database;

PROTECTION_MODE PROTECTION_LEVEL
----------------------------------------
MAXIMUM AVAILABILITY RESYNCHRONIZATION

Recommended reading:

Use the Duplicate function of RMAN to create a physical partition uard

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption

Use RMAN to back up duplicate to create a replica uard