Tags

, ,

@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;

Advertisements