"ORACLE" DG Performance conversion (11g)

One, maximum performance conversion to maximum available

Confirm the main Library mode:

[Email protected] hey~2->select protection_mode,protection_level from V$database;

Protection_mode Protection_level
-------------------- --------------------
MAXIMUM Performance MAXIMUM Performance

Confirm the Standby mode:

[Email protected] hey~1->select name,protection_mode,database_role,switchover_status from V$database;

NAME Protection_mode Database_role Switchover_status
--------- -------------------- ---------------- --------------------
ENMO1 MAXIMUM Performance Physical STANDBY to PRIMARY

Modify parameters: Alter system set log_archive_dest_2= ' Service=enmo2 ASYNC valid_for= (online_logfiles,primary_role) Db_unique_name=enmo2 ';

Database altered.

Mode conversion

[Email protected] Hey~1->alter database set standby database to maximize availability;

Database altered.

Main Library Confirmation Mode:

[Email protected] hey~2->select name,protection_mode,database_role,switchover_status from V$database;

NAME Protection_mode Database_role Switchover_status
--------- -------------------- ---------------- --------------------
ENMO1 MAXIMUM Availability Physical STANDBY to STANDBY

Standby Confirm mode:

[Email protected] hey~1->select name,protection_mode,database_role,switchover_status from V$database;

NAME Protection_mode Database_role Switchover_status
--------- -------------------- ---------------- --------------------
ENMO1 MAXIMUM Availability Physical STANDBY not allowed

Second, maximum available switch to maximum protection

[Email protected] Hey~1->alter database set standby database to maximize protection;

Database altered.

[Email protected] hey~1->select name,protection_mode,database_role,switchover_status from V$database;

NAME Protection_mode Database_role Switchover_status
--------- -------------------- ---------------- --------------------
ENMO1 MAXIMUM PROTECTION physical STANDBY to STANDBY

"ORACLE" DG Performance conversion (11g)