Wednesday 1 October 2014

Fast Start Failover Running

Öncelikle Primary database'in Flashback özelliği enable edilmelidir.

   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';
   EDIT DATABASE STDBY SET PROPERTY 'LogXptMode'='SYNC';
   EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
fast start failover enable edilir.

   enable fast_start failover

3.cü makine'de:

  dgmgrl
  connect sys/oracle@primary database
  connect sys/oracle@standby database
  start observer;
Durdurulacağı zaman :

  dgmgrl
  connect sys/oracle@primary database
  connect sys/oracle@standby database
  stop observer;

No comments:

Post a Comment