shu immediate
startup mount
ALTER SYSTEM SET UNDO_RETENTION=3600 SCOPE=SPFILE;
ALTER SYSTEM SET UNDO_MANAGEMENT='AUTO' SCOPE=SPFILE;
ALTER DATABASE FLASHBACK ON;
ALTER SYSTEM SET DG_BROKER_START=TRUE SCOPE=BOTH;
shu immediate;
startup
Benzer işlemler standby database'de tekrarlanmalıdır.
shu immediate
startup mount
ALTER SYSTEM SET UNDO_RETENTION=3600 SCOPE=SPFILE;
ALTER SYSTEM SET UNDO_MANAGEMENT='AUTO' SCOPE=SPFILE;
ALTER DATABASE FLASHBACK ON;
shu immediate;
startup mount
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
ALTER SYSTEM SET DG_BROKER_START=TRUE SCOPE=BOTH;
Primary Database'de :
DGMGRL
EDIT DATABASE PRM SET PROPERTY FastStartFailoverTarget='STDBY';
EDIT DATABASE STDBY SET PROPERTY FastStartFailoverTarget='PRM';
synch olacaksa :
EDIT DATABASE PRM SET PROPERTY 'LogXptMode'='SYNC';fast start failover enable edilir.
EDIT DATABASE STDBY SET PROPERTY 'LogXptMode'='SYNC';
EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
enable fast_start failover
3.cü makine'de:
dgmgrlDurdurulacağı zaman :
connect sys/oracle@primary database
connect sys/oracle@standby database
start observer;
dgmgrl
connect sys/oracle@primary database
connect sys/oracle@standby database
stop observer;
No comments:
Post a Comment