Sunday, October 4, 2020

TAF basic policy RAC

 PUNE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = racscan)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pune)
      (FAILOVER_MODE=(METHOD=basic)(TYPE=select))
     (LOAD_BALANCE=YES)
     (FAILOVER=ON)
    )
  )

SQL> select INSTANCE_NAME, status from v$instance;
INSTANCE_NAME    STATUS
---------------- ------------
pune1            OPEN

SQL> select INSTANCE_NAME, status from v$instance;
INSTANCE_NAME    STATUS
---------------- ------------
pune2            OPEN
On a different window:
----------------------

[oracle@rac1pub117 admin]$ sqlplus shoaib/shoaib@pune

sql> select * from dba_source;

On Node 2:
----------
[oracle@rac1pub117 admin]$ sqlplus / as sysdba
sql> select inst_id,username,service_name,failover_type,failover_method,failed_over from gv$session where username='SHOAIB';
INST_ID   USERNAME SERVICE_NAME FAILOVER_TYPE FAILOVER_METHOD FAILED-OVER
-------------------------------------------------------------------------
         1 SHOAIB    pune           SELECT BASIC         NO


On Node 1:
----------

sql> shut immediate;
On Node 2:
----------
sql>select inst_id,username,service_name,failover_type,failover_method,failed_over from gv$session where username='SHOAIB';
INST_ID   USERNAME SERVICE_NAME FAILOVER_TYPE FAILOVER_METHOD FAILED-OVER
-------------------------------------------------------------------------
         2 SHOAIB    pune           SELECT BASIC         YES



No comments:

Post a Comment

Featured post

Migrate OCR & vote from external to normal or High redundancy in ASM

How to Move OCR & Vote from external to Normal or high. 1)  Create New diskgroup(CRS) with suitable redundancy for OCR and Voting files....

Popular Posts