Tags
Activate Physical Standby, Activate Physical Standby Database Flashback, Activate Physical Standby Database for Read Write
@Standby
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=25G;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’/dir/oracle/flashback’;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
CREATE RESTORE POINT db_standby_test GUARANTEE FLASHBACK DATABASE;
select NAME,SCN,TIME from v$restore_point;
@Primary
ALTER SYSTEM ARCHIVE LOG CURRENT;
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=DEFER;
@Standby
select NAME,SCN,TIME from v$restore_point;
ALTER DATABASE ACTIVATE STANDBY DATABASE;
select CONTROLFILE_TYPE from v$database;
ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;
@Standby
STARTUP MOUNT FORCE;
FLASHBACK DATABASE TO RESTORE POINT db_standby_test;
select controlfile_type from v$database;
ALTER DATABASE CONVERT TO PHYSICAL STANDBY;
STARTUP MOUNT FORCE;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;
select controlfile_type from v$database;
@Primary
ALTER SYSTEM ARCHIVE LOG CURRENT;
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;