Shulou(Shulou.com)06/01 Report--

6.3. Restart the test

After restarting Node 2, check the status in Node 1, where the instance is ORACLE_2 and runs on Node 2.

Grid@node1:~ > crsctl stat res-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.DATA.dg

ONLINE ONLINE node1

ONLINE OFFLINE node2

Ora.FRA.dg

ONLINE ONLINE node1

ONLINE OFFLINE node2

Ora.LISTENER.lsnr

ONLINE ONLINE node1

ONLINE ONLINE node2

Ora.OCR_VOTE.dg

ONLINE ONLINE node1

ONLINE OFFLINE node2

Ora.asm

ONLINE ONLINE node1 Started

ONLINE ONLINE node2 Started

Ora.gsd

OFFLINEOFFLINE node1

OFFLINEOFFLINE node2

Ora.net1.network

ONLINE ONLINE node1

ONLINE ONLINE node2

Ora.ons

ONLINE ONLINE node1

ONLINE ONLINE node2

Ora.registry.acfs

ONLINE ONLINE node1

ONLINE OFFLINE node2

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE OFFLINE STARTING

Ora.cvu

1 ONLINE ONLINE node1

Ora.node1.vip

1 ONLINE ONLINE node1

Ora.node2.vip

1 ONLINE ONLINE node2

Ora.oc4j

1 ONLINE OFFLINE STARTING

Ora.oracle.db

2 ONLINE OFFLINE Instance Shutdown,S

TARTING

Ora.oracle.oracleser.svc

1 ONLINE OFFLINE

Ora.scan1.vip

1 ONLINE ONLINE node1

Grid@node1:~ > srvctl status database-d ORACLE

Check again

Grid@node1:~ > srvctl status database-d ORACLE

Instance ORACLE_2 is running on node node1

Online relocation: INACTIVE

Grid@node1:~ > crsctl stat res-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.DATA.dg

ONLINE ONLINE node1

Ora.FRA.dg

ONLINE ONLINE node1

Ora.LISTENER.lsnr

ONLINE ONLINE node1

Ora.OCR_VOTE.dg

ONLINE ONLINE node1

Ora.asm

ONLINE ONLINE node1 Started

Ora.gsd

OFFLINEOFFLINE node1

Ora.net1.network

ONLINE ONLINE node1

Ora.ons

ONLINE ONLINE node1

Ora.registry.acfs

ONLINE ONLINE node1

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE node1

Ora.cvu

1 ONLINE ONLINE node1

Ora.node1.vip

1 ONLINE ONLINE node1

Ora.node2.vip

1 ONLINE INTERMEDIATE node1 FAILED OVER

Ora.oc4j

1 ONLINE ONLINE node1

Ora.oracle.db

2 ONLINE ONLINE node1 Open

Ora.oracle.oracleser.svc

1 ONLINE ONLINE node1

Ora.scan1.vip

1 ONLINE ONLINE node1

Grid@node1:~ >

Check again

Grid@node1:~ > crsctl stat res-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.DATA.dg

ONLINE ONLINE node1

ONLINE ONLINE node2

Ora.FRA.dg

ONLINE ONLINE node1

ONLINE ONLINE node2

Ora.LISTENER.lsnr

ONLINE ONLINE node1

ONLINE ONLINE node2

Ora.OCR_VOTE.dg

ONLINE ONLINE node1

ONLINE ONLINE node2

Ora.asm

ONLINE ONLINE node1 Started

ONLINE ONLINE node2 Started

Ora.gsd

OFFLINEOFFLINE node1

OFFLINEOFFLINE node2

Ora.net1.network

ONLINE ONLINE node1

ONLINE ONLINE node2

Ora.ons

ONLINE ONLINE node1

ONLINE ONLINE node2

Ora.registry.acfs

ONLINE ONLINE node1

ONLINE ONLINE node2

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE node1

Ora.cvu

1 ONLINE ONLINE node1

Ora.node1.vip

1 ONLINE ONLINE node1

Ora.node2.vip

1 ONLINE ONLINE node2

Ora.oc4j

1 ONLINE ONLINE node1

Ora.oracle.db

2 ONLINE ONLINE node1 Open

Ora.oracle.oracleser.svc

1 ONLINE ONLINE node1

Ora.scan1.vip

1 ONLINE ONLINE node1

Grid@node1:~ >

After restarting node 2, the ORACLE_2 instance is switched to node 1 to run, and the instance is still ORACLE_2.

6.4. Shutdown test

At this point, the instance is ORACLE_2 and runs on node 1. Close node 1 and view it on node 2.

Grid@node2:~ > crsctl stat res-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.DATA.dg

ONLINE ONLINE node1

ONLINE ONLINE node2

Ora.FRA.dg

ONLINE ONLINE node1

ONLINE ONLINE node2

Ora.LISTENER.lsnr

ONLINE OFFLINE node1

ONLINE ONLINE node2

Ora.OCR_VOTE.dg

ONLINE ONLINE node1

ONLINE ONLINE node2

Ora.asm

ONLINE ONLINE node1 Started

ONLINE ONLINE node2 Started

Ora.gsd

OFFLINEOFFLINE node1

OFFLINEOFFLINE node2

Ora.net1.network

ONLINE ONLINE node1

ONLINE ONLINE node2

Ora.ons

ONLINE ONLINE node1

ONLINE ONLINE node2

Ora.registry.acfs

ONLINE ONLINE node1

ONLINE ONLINE node2

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE OFFLINE STARTING

Ora.cvu

1 ONLINE ONLINE node2

Ora.node1.vip

1 ONLINE INTERMEDIATE node2 FAILED OVER

Ora.node2.vip

1 ONLINE ONLINE node2

Ora.oc4j

1 ONLINE ONLINE node1 STOPPING

Ora.oracle.db

2 ONLINE OFFLINE Instance Shutdown,S

TARTING

Ora.oracle.oracleser.svc

1 ONLINE OFFLINE

Ora.scan1.vip

1 ONLINE ONLINE node2

Grid@node2:~ > srvctl status database-d ORACLE

Database is not running.

Online relocation: INACTIVE

Grid@node2:~ >

Check again

Grid@node2:~ > crsctl stat res-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.DATA.dg

ONLINE ONLINE node2

Ora.FRA.dg

ONLINE ONLINE node2

Ora.LISTENER.lsnr

ONLINE ONLINE node2

Ora.OCR_VOTE.dg

ONLINE ONLINE node2

Ora.asm

ONLINE ONLINE node2 Started

Ora.gsd

OFFLINEOFFLINE node2

Ora.net1.network

ONLINE ONLINE node2

Ora.ons

ONLINE ONLINE node2

Ora.registry.acfs

ONLINE ONLINE node2

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE node2

Ora.cvu

1 ONLINE ONLINE node2

Ora.node1.vip

1 ONLINE INTERMEDIATE node2 FAILED OVER

Ora.node2.vip

1 ONLINE ONLINE node2

Ora.oc4j

1 ONLINE ONLINE node2

Ora.oracle.db

2 ONLINE ONLINE node2 Open

Ora.oracle.oracleser.svc

1 ONLINE ONLINE node2

Ora.scan1.vip

1 ONLINE ONLINE node2

Grid@node2:~ > srvctl status database-d ORACLE

Instance ORACLE_2is running on node node2

Online relocation:INACTIVE

Grid@node2:~ >

Start node 1, wait a few minutes, and then check again

Grid@node2:~ > crsctl stat res-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.DATA.dg

ONLINE ONLINE node1

ONLINE ONLINE node2

Ora.FRA.dg

ONLINE ONLINE node1

ONLINE ONLINE node2

Ora.LISTENER.lsnr

ONLINE ONLINE node1

ONLINE ONLINE node2

Ora.OCR_VOTE.dg

ONLINE ONLINE node1

ONLINE ONLINE node2

Ora.asm

ONLINE ONLINE node1 Started

ONLINE ONLINE node2 Started

Ora.gsd

OFFLINEOFFLINE node1

OFFLINEOFFLINE node2

Ora.net1.network

ONLINE ONLINE node1

ONLINE ONLINE node2

Ora.ons

ONLINE ONLINE node1

ONLINE ONLINE node2

Ora.registry.acfs

ONLINE ONLINE node1

ONLINE ONLINE node2

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE node2

Ora.cvu

1 ONLINE ONLINE node2

Ora.node1.vip

1 ONLINE ONLINE node1

Ora.node2.vip

1 ONLINE ONLINE node2

Ora.oc4j

1 ONLINE ONLINE node2

Ora.oracle.db

2 ONLINE ONLINE node2 Open

Ora.oracle.oracleser.svc

1 ONLINE ONLINE node2

Ora.scan1.vip

1 ONLINE ONLINE node2

Grid@node2:~ >

When the Node 1 server is turned off, ORACLE_2 switches to Node 2 to run. When Node 1 is restarted, ORACLE_2 does not switch back.

Summary:

(1) the second instance is not used for Failover, but for manual relocate.

(2) during the process of Relocate from Node 1 to Node 2, an ORACLE_2 is started on the target host node 2, then the ORACLE_1 of the original host node 1 is closed, and finally ORACLE_2 is running on Node 2.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.