Oracle: RMAN Backup & Recovery

1. Check if the database is in archive mode:

Archive mode is disabled.


(2): Set the database is in archive mode:

Premise set up the database in archive mode of the database in mount state, restart the database to mount state:

In the mount state, the use alter database statement archive mode enabled:

2. Define the flash recovery area (flash recovery area):

Flashback recovery area, mainly through the following three initialization parameters to set up and manage:

db_recovery_file_dest : Specifies the position Flashback recovery area
db_recovery_file_dest_size : Specifies flash recovery area free space
db_flashback_retention_target : Specifies that the database can be rolled back in time, in                                                                         minutes,
 The default 1440 minutes, which is one day. Of course, actually be rolled back in time also decided to return the size of the flash recovery area, because it saved the rollback required flash log. So this parameter to modify and db_recovery_file_dest_size fit.

(1) view the current location and the size of the flash recovery area:

(2), setting the flashback recovery area location and size:

Before setting up the flash recovery area location, determine the directory has been created,

or in the process of modification will be reported the following error:

(3) To view the results of the above settings:

(4) If you want to view the flash recovery area space usage, you can view the following views:

(5) If you want to free up more space, you can use the following command to delete all archived log files to free up space:

3. Set the archive logs multipath storage:
(1) view the current configuration information log_archive_dest:

(2), Define a new location:

The first command uses the flash recovery area, the second using a custom location.
(3) to see if the definition of success:

4, on the control file control_file_record_keep_time parameters:
This parameter specify the minimum days the RMAN information is stored in the control file before overwritten. The default value is 7 days. When using catalog, a smaller value should be chosen.
See the value of this parameter:

5, rman use:
(1) Enable rman:

Which means a non-catalog 1,2,3,5,6 connection section 4 is connected to the catalog, db02 is the target database, db01 directory database.
(2) to display the rman configuration information:

(3) Configured rman:
Enable automatic backup control file:

Enable backup set compression:

Define retention policies:
The default retention value is 1.

(4), Restore the configuration defaults rman:

6, The backup command backup:
If the direct use backup database, the whole preparation, this method can not be incremental and differential backups.

Level 0 backup performed, this can be incremental and differential backups:

Level 1 backup performed:

The level at which the cumulative (cumulative) backup 1:

           

Delete all archive logs after the backup is complete:

7, List the command:

                               

8, Report command:

9, Delete the command:


                               

10, Related to the several views rman:


V$ARCHIVED_LOG
V$BACKUP_CORRUPTION
V$BACKUP_DEVICE
V$BACKUP_FILES
V$BACKUP_PIECE
V$BACKUP_REDOLOG
V$BACKUP_SET
V$BACKUP_SPFILE
V$COPY_CORRUPTION
V$RMAN_CONFIGURATION

How to open without RESETLOGS after restore offline/cold backup

RESETLOGS | NORESETLOGS 

This clause determines whether Oracle Database resets the current log sequence number to 1, archives any unarchived logs (including the current log), and discards any redo information that was not applied during recovery, ensuring that it will never be applied. Oracle Database uses NORESETLOGS automatically except in the following specific situations, which require a setting for this clause: 

You must specify RESETLOGS: 

1.After performing incomplete media recovery or media recovery using a backup controlfile 
2.After a previous OPEN RESETLOGS operation that did not complete 
3.After a FLASHBACK DATABASE operation 

If a created controlfile is mounted, then you must specify RESETLOGS if the online logs are lost, or you must specify  NORESETLOGS if they are not lost. So, the point is that if we restored the controlfile backup, we have to do OPEN RESETLOGS because the controlfile type will be BACKUP controlfile. Moreover, online redo logs backups should also be available as RMAN doesn't backup online redo logs. 

In order to avoid RESETLOGS, the following steps can be followed: 

• In addition to take cold backup of database, also take backup of online redo logs
• Restore controlfile and database cold backup :

     RMAN> restore controlfile...... 
     RMAN> mount database ; 
     RMAN> restore database ; 

• Copy the online redo logs to the desired location for new database.

• Login to SQL*Plus and generate controlfile trace script ( please note that the database is mounted from rman after restoring controlfile ) :

     SQL> alter database backup controlfile to trace NORESETLOGS as '/tmp/ctl.sql' ; 
     SQL> SHUTDOWN IMMEDIATE 

• Edit the controlfile if required. For example, to change the location of online redo logs copied.

• Shutdown and STARTUP NOMOUNT the database and run the create controlfile script :

     SQL> STARTUP NOMOUNT 
     SQL> @/tmp/ctl.sql 

•  Recover the database and open normal :

     SQL> RECOVER DATABASE ; 
     SQL> ALTER DATABASE OPEN ;

Building Oracle HA With PowerHA 6.1 On AIX 6.1

Configure IBM PowerHA on aix.

The en0 just for boot ip and the en1 just for standby ip.

一.Requirements

1.Append follwoing lines to /etc/hosts on all of nodes.

#For Boot IP 
172.16.255.11   xxserv1 
172.16.255.13   xxserv2 
#For Standby IP 
192.168.0.11    xxserv1-stby 
192.168.0.13    xxserv2-stby 
#For Service IP 
172.16.255.15   xxserv1-serv 
172.16.255.17   xxserv2-serv 
#For Persistent IP 
192.168.2.11    xxserv1-pers 
192.168.2.13    xxserv2-pers 

2.Ensure that the following aix filesets are installed:

[root@xxserv1 /]#lslpp -l bos.data bos.adt.lib bos.adt.libm bos.adt.syscalls bos.net.tcp.client bos.net.tcp.server bos.rte.SRC bos.rte.libc bos.rte.libcfg bos.rte.libpthreads bos.rte.odm bos.rte.lvm bos.clvm.enh bos.adt.base bos.perf.perfstat bos.perf.libperfstat bos.perf.proctools rsct.basic.rte rsct.compat.clients.rte xlC.aix61.rte  

3.Install PowerHA on all of nodes:

[root@xxserv1 /]#loopmount -i powerHA_v6.1.iso -o "-V cdrfs -o ro" -m /mnt 
[root@xxserv1 /]#installp -a -d /mnt all 

After installation,keep the PowerHA up to date and reboot all of nodes.

4.Append boot ip and standby ip to /usr/es/sbin/cluster/etc/rhosts

[root@xxserv1 etc]#cat rhosts  
172.16.255.11    
172.16.255.13   
192.168.0.11     
192.168.0.13 
[root@xxserv2 etc]#cat rhosts  
172.16.255.11    
172.16.255.13   
192.168.0.11     
192.168.0.13 

5.Edit /usr/es/sbin/cluster/netmon.cf file.Append each boot ip and standby ip to it on each node.

[root@xxserv1 cluster]#cat netmon.cf  
172.16.255.11 
192.168.0.11  
[root@xxserv2 cluster]#cat netmon.cf  
172.16.255.13 
192.168.0.13  

6.Create a disk heartbeat:

//Create heartvg on xxserv1 
[root@xxserv1 /]#mkvg -x -y heartvg -C hdisk5 
[root@xxserv1 /]#lspv|grep hdisk5  
hdisk5          000c1acf7ca3bc3b                    heartvg    
//import heartvg on xxserv2 
[root@xxserv2 /]#importvg –y heartvg hdisk5 
[root@xxserv2 /]#lspv|grep hdisk5                 
hdisk5          000c1acf7ca3bc3b                    heartvg 

Test the disk heartbeat:

//Running following command on xxserv1 
[root@xxserv1 /]#/usr/sbin/rsct/bin/dhb_read -p hdisk5 -r  
DHB CLASSIC MODE  
First node byte offset: 61440  
Second node byte offset: 62976  
Handshaking byte offset: 65024  
       Test byte offset: 64512 
 
Receive Mode:  
Waiting for response . . .  
Magic number = 0x87654321  
Magic number = 0x87654321  
Magic number = 0x87654321  
Link operating normally 
 
//Running following command on xxserv2 

[root@xxserv2 /]#/usr/sbin/rsct/bin/dhb_read -p hdisk5 -t  
DHB CLASSIC MODE  
First node byte offset: 61440  
Second node byte offset: 62976  
Handshaking byte offset: 65024  
       Test byte offset: 64512 
 
Transmit Mode:  
Magic number = 0x87654321  
Detected remote utility in receive mode.  Waiting for response . . .  
Magic number = 0x87654321  
Magic number = 0x87654321  
Link operating normally 

7.Create a Share Volume Group:

//On xxserv1 
[root@xxserv1 /]#mkvg -V 48 -y oradata hdisk6 hdisk7  
0516-1254 mkvg: Changing the PVID in the ODM.  
0516-1254 mkvg: Changing the PVID in the ODM.  
oradata 
[root@xxserv1 /]#mklv -y lv02 -t jfs2 oradata 20G  
lv02  
[root@xxserv1 /]#crfs -v jfs2 -d /dev/lv02 –m /oradata  
File system created successfully.  
20970676 kilobytes total disk space.  
New File System size is 41943040  
[root@xxserv1 /]#chvg -an oradata 
[root@xxserv1 /]#varyoffvg oradata 
[root@xxserv1 /]#exportvg oradata 
 
//On xxserv2 import oradata volume group 
[root@xxserv2 /]#importvg -V 48 -y oradata hdisk6  
oradata  
[root@xxserv2 /]#lspv  
hdisk0          000c18cf00094faa                    rootvg          active               
hdisk1          000c18cf003ca02c                    None                                 
hdisk2          000c1acf3e6440c6                    None                                 
hdisk3          000c1acf3e645312                    None                                 
hdisk4          000c1acf3e6460d9                    None                                 
hdisk5          000c1acf7ca3bc3b                    heartvg                              
hdisk6          000c1acf7cb764d9                    oradata         active               
hdisk7          000c1acf7cb765aa                    oradata         active 

8.For oracle do following steps.

(1).Check following softwares:

[root@xxserv2 /]#lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat bos.perf.libperfstat bos.perf.proctools xlC.aix61.rte 

(2).Change following parameters:

[root@xxserv1 /]#no -p -o tcp_ephemeral_low=9000 
[root@xxserv1 /]#no -p -o tcp_ephemeral_high=65500 
[root@xxserv1 /]#no -p -o udp_ephemeral_low=9000 
[root@xxserv1 /]#no -p -o udp_ephemeral_high=65500 
[root@xxserv2 /]#no -p -o tcp_ephemeral_low=9000 
[root@xxserv2 /]#no -p -o tcp_ephemeral_high=65500 
[root@xxserv2 /]#no -p -o udp_ephemeral_low=9000 
[root@xxserv2 /]#no -p -o udp_ephemeral_high=65500 

(3).Create oracle user and groups:

//On xxserv1 
[root@xxserv1 /]#for id in oinstall dba oper;do mkgroup $id;done 
[root@xxserv1 /]#mkuser oracle;passwd oracle
[root@xxserv1 /]#chuser pgrp=oinstall oracle 
[root@xxserv1 /]#chuser groups=oinstall,dba,oper oracle 
[root@xxserv1 /]#chuser fsize=-1 oracle 
[root@xxserv1 /]#chuser data=-1 oracle 
//On xxserv2 
[root@xxserv2 /]#for id in oinstall dba oper;do mkgroup $id;done 
[root@xxserv2 /]#mkuser oracle;passwd oracle
[root@xxserv2 /]#chuser pgrp=oinstall oracle 
[root@xxserv2 /]#chuser groups=oinstall,dba,oper oracle 
[root@xxserv2 /]#chuser fsize=-1 oracle 
[root@xxserv2 /]#chuser data=-1 oracle 

(4).Change maxuprocs parameter:

[root@xxserv1 /]#chdev -l sys0 -a maxuproc=16384 
sys0 changed 
[root@xxserv2 /]#chdev -l sys0 -a maxuproc=16384 
sys0 changed 

(5).Create Oracle home:

[root@xxserv1 /]#mkdir /u01;chown oracle:oinstall /u01;su - oracle 
[root@xxserv1 /]$vi .profile 
export ORACLE_SID=example 
export ORACLE_BASE=/u01/app/oracle 
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1 
export NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS" 
export TNS_ADMIN=$ORACLE_HOME/network/admin 
export ORA_NLS11=$ORACLE_HOME/nls/data 
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:$JAVA_HOME/bin 
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib:/lib:/usr/lib:/usr/local/lib 
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib 
export THREADS_FLAG=native 
[root@xxserv1 /]$source .profile;mkdir -p $ORACLE_HOME 
 
[root@xxserv2 /]#mkdir /u01;chown oracle:oinstall /u01;su - oracle 
[root@xxserv2 /]$vi .profile 
export ORACLE_SID=example 
export ORACLE_BASE=/u01/app/oracle 
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1 
export NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS" 
export TNS_ADMIN=$ORACLE_HOME/network/admin 
export ORA_NLS11=$ORACLE_HOME/nls/data 
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:$JAVA_HOME/bin 
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib:/lib:/usr/lib:/usr/local/lib 
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib 
export THREADS_FLAG=native 
[root@xxserv2 /]$source .profile;mkdir -p $ORACLE_HOME 

(6).Ensure that the /tmp filesystem has enough space:

[root@xxserv1 /]#chfs -a size=+1G /tmp 

二.Create a cluster:

1.Add a cluster:

[root@xxserv1 /]#/usr/es/sbin/cluster/utilities/claddclstr -n hatest  
Current cluster configuration: 
 
Cluster Name: hatest  
Cluster Connection Authentication Mode: Standard  
Cluster Message Authentication Mode: None  
Cluster Message Encryption: None  
Use Persistent Labels for Communication: No  
There are 0 node(s) and 0 network(s) defined 
 
No resource groups defined 

2.Add nodes to cluster:

[root@xxserv1 /]#/usr/es/sbin/cluster/utilities/clnodename -a xxserv1  -p xxserv1  
[root@xxserv1 /]#/usr/es/sbin/cluster/utilities/clnodename -a xxserv2  -p xxserv2 
[root@xxserv1 /]#/usr/es/sbin/cluster/utilities/clnodename 
xxserv1 
xxserv2 

3. Configure HACMP diskhb network:

[root@xxserv1 /]#/usr/es/sbin/cluster/utilities/clmodnetwork -a -l no -n net_diskhb_01 -i diskhb 
[root@xxserv1 /]#/usr/es/sbin/cluster/cspoc/cl_ls2ndhbnets  
Network Name   Node and Disk List  
============   ==================      ==================  
net_diskhb_01           

4.Configure HACMP Communication devices:

[root@xxserv1 /]#/usr/es/sbin/cluster/utilities/claddnode -a diskhb_xxserv1:diskhb:net_diskhb_01:serial:service:/dev/hdisk5 -n xxserv1 

[root@xxserv1 /]#/usr/es/sbin/cluster/utilities/claddnode -a diskhb_xxserv2:diskhb:net_diskhb_01:serial:service:/dev/hdisk5 -n xxserv2 

[root@xxserv1 /]#/usr/es/sbin/cluster/cspoc/cl_ls2ndhbnets  
Network Name   Node and Disk List  
============   ==================      ==================  
net_diskhb_01  xxserv1:/dev/hdisk5     xxserv2:/dev/hdisk5 

Test diskhb nerwork:

[root@xxserv1 /]#/usr/es/sbin/cluster/sbin/cl_tst_2ndhbnet -cspoc -n'xxserv1,xxserv2' '/dev/hdisk5' 'xxserv1' '/dev/hdisk5' 'xxserv2'  
cl_tst_2ndhbnet: Starting the receive side of the test for disk /dev/hdisk5 on node xxserv1  
cl_tst_2ndhbnet: Starting the transmit side of the test for disk /dev/hdisk5 on node xxserv2  
xxserv1: DHB CLASSIC MODE  
xxserv1:  First node byte offset: 61440  
xxserv1: Second node byte offset: 62976  
xxserv1: Handshaking byte offset: 65024  
xxserv1:        Test byte offset: 64512  
xxserv1:  
xxserv1: Receive Mode:  
xxserv1: Waiting for response . . .  
xxserv1: Magic number = 0x87654321  
xxserv1: Magic number = 0x87654321  
xxserv1: Magic number = 0x87654321  
xxserv1: Link operating normally  
xxserv2: DHB CLASSIC MODE  
xxserv2:  First node byte offset: 61440  
xxserv2: Second node byte offset: 62976  
xxserv2: Handshaking byte offset: 65024  
xxserv2:        Test byte offset: 64512  
xxserv2:  
xxserv2: Transmit Mode:  
xxserv2: Magic number = 0x87654321  
xxserv2: Detected remote utility in receive mode.  Waiting for response . . .  
xxserv2: Magic number = 0x87654321  
xxserv2: Magic number = 0x87654321  
xxserv2: Link operating normally  
cl_tst_2ndhbnet: Test complete 

5.Configure HACMP IP-Based Network:

[root@xxserv1 /]#/usr/es/sbin/cluster/utilities/clmodnetwork -a –n net_ether_02 –i ether –s 255.255.255.0 –l yes 

[root@xxserv1 /]#/usr/es/sbin/cluster/utilities/clmodnetwork -a -n net_ether_03 -i ether -s 255.255.255.0 -l yes 

6.Add Communication Interfaces:

[root@xxserv1 /]#/usr/es/sbin/cluster/utilities/claddnode -a'xxserv1' :'ether' :'net_ether_02' : : : -n'xxserv1'

[root@xxserv1 /]#/usr/es/sbin/cluster/utilities/claddnode -a'xxserv2' :'ether' :'net_ether_02' : : : -n'xxserv2' 

[root@xxserv1 /]#/usr/es/sbin/cluster/utilities/claddnode -a'xxserv1-stby' :'ether' :'net_ether_03' : : : -n'xxserv1'

[root@xxserv1 /]#/usr/es/sbin/cluster/utilities/claddnode -a'xxserv2-stby' :'ether' :'net_ether_03' : : : -n'xxserv2' 

7.Add service ip:

[root@xxserv1 /]#/usr/es/sbin/cluster/utilities/claddnode -Tservice -B'xxserv1-serv' -w'net_ether_01' 
[root@xxserv1 /]#/usr/es/sbin/cluster/utilities/claddnode -Tservice -B'xxserv2-serv' -w'net_ether_01' 

8.Add Resource Group:

Extended Configuration->Extended Resource Configuration->HACMP Extended Resource Group Configuration->Add a Resource Group

9.Add persistent ip:

Extended Configuration->Extended Topology Configuration->Configure HACMP Persistent Node IP Label/Addresses->Add a Persistent Node IP Label/Address

10.Verification and Synchronization:

Extended Configuration->Extended Verification and Synchronization or you can use following command:

[root@xxserv1 /]#usr/es/sbin/cluster/utilities/cldare -rt -V normal 

三.Install Oracle databse:

1.Run rootpre.sh scripts:

Before install,you must run rootpre.sh from oralce meadia:

[root@xxserv1 database]#./rootpre.sh  
./rootpre.sh output will be logged in /tmp/rootpre.out_12-05-28.13:38:43 
 
Checking if group services should be configured....  
Group "hagsuser" does not exist.  
Creating required group for group services: hagsuser  
Please add your Oracle userid to the group: hagsuser  
Configuring HACMP group services socket for possible use by Oracle. 
 
The group or permissions of the group services socket have changed. 
 
Please stop and restart HACMP before trying to use Oracle. 
 
 
[root@xxserv2 database]#./rootpre.sh  
./rootpre.sh output will be logged in /tmp/rootpre.out_12-05-28.13:38:11 
 
Checking if group services should be configured....  
Group "hagsuser" does not exist.  
Creating required group for group services: hagsuser  
Please add your Oracle userid to the group: hagsuser  
Configuring HACMP group services socket for possible use by Oracle. 
 
The group or permissions of the group services socket have changed. 
 
Please stop and restart HACMP before trying to use Oracle. 

After do above step then you can install oracle database and copy the oracle installed files to another node.Make sure that the oracle listener address is you service ip.

2.Create start and stop scripts:

[root@xxserv1 /]#vi /etc/dbstart  
#!/usr/bin/bash  
#Define Oracle Home  
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1  
#Start Oracle Listener  
if [ -x $ORACLE_HOME/bin/lsnrctl ]; then  
su - oracle "-c lsnrctl start"  
fi  
#Start Oracle Instance  
if [ -x $ORACLE_HOME/bin/sqlplus ]; then  
su - oracle "-c sqlplus"<<EOF  
connect / as sysdba  
startup  
quit  
EOF  
fi  
[root@xxserv1 /]#vi /etc/dbstop  
#!/usr/bin/bash  
#Define Oracle Home  
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1  
#Stop Oracle Listener  
if [ -x $ORACLE_HOME/bin/lsnrctl ]; then  
su - oracle "-c lsnrctl stop"   
fi  
#Stop Oracle Instance  
if [ -x $ORACLE_HOME/bin/sqlplus ]; then  
su - oracle "-c sqlplus"<<EOF  
connect / as sysdba  
shutdown immediate  
quit  
EOF  
fi  
[root@xxserv1 /]#chmod +x /etc/dbst* 
[root@xxserv1 /]#scp /etc/dbst* xxserv2:/etc 

Register A Application to Resource Group

1.Configure HACMP Application Servers:

Extended Configuration->Extended Resource Configuration->HACMP Extended Resources Configuration->Configure HACMP Application Servers->Add an Application Server

2.Create Application Monitor:

Extended Configuration->Extended Resource Configuration->Configure HACMP Application Servers->Configure HACMP Application Monitoring->Add a Process Application Monitor

3.Register A resource to resource group:

Extended Configuration->Extended Resource Configuration->HACMP Extended Resource Group Configuration->Change/Show Resources and Attributes for a Resource Group

5.Verification and Synchronization

Excute following command:

[root@xxserv1 /]#usr/es/sbin/cluster/utilities/cldare -rt -V normal 

After above steps,start hacmp service and test you configuration.

6.Display HACMP Configuration:

[root@xxserv1 /]#/usr/es/sbin/cluster/utilities/cldisp 
Cluster: hatest 
   Cluster services: active 
   State of cluster: up 
      Substate: stable 
 
############# 
APPLICATIONS 
############# 
   Cluster hatest provides the following applications: example  
      Application: example 
         example is started by /etc/dbstart 
         example is stopped by /etc/dbstop 
         Application monitor of example: example 
            Monitor name: example 
               Type: process 
               Process monitored: tnslsnr 
               Process owner: oracle 
               Instance count: 1 
               Stabilization interval: 60 seconds 
               Retry count: 3 tries 
               Restart interval: 198 seconds 
               Failure action: fallover 
               Cleanup method: /etc/lsnrClear.sh 
               Restart method: /etc/lsnrRestart.sh 
         This application is part of resource group 'oradb'. 
            Resource group policies: 
               Startup: on first available node 
               Fallover: to next priority node in the list 
               Fallback: never 
            State of example: online 
            Nodes configured to provide example: xxserv1 {up}  xxserv2 {up}   
               Node currently providing example: xxserv1 {up}  
               The node that will provide example if xxserv1 fails is: xxserv2 
            Resources associated with example: 
               Service Labels 
                  xxserv1-serv(172.16.255.15) {online} 
                     Interfaces configured to provide xxserv1-serv: 
                        xxserv1 {up} 
                           with IP address: 172.16.255.11 
                           on interface: en0 
                           on node: xxserv1 {up} 
                           on network: net_ether_02 {up} 
                        xxserv2 {up} 
                           with IP address: 172.16.255.13 
                           on interface: en0 
                           on node: xxserv2 {up} 
                           on network: net_ether_02 {up} 
                  xxserv2-serv(172.16.255.17) {online} 
                     Interfaces configured to provide xxserv2-serv: 
                        xxserv1 {up} 
                           with IP address: 172.16.255.11 
                           on interface: en0 
                           on node: xxserv1 {up} 
                           on network: net_ether_02 {up} 
                        xxserv2 {up} 
                           with IP address: 172.16.255.13 
                           on interface: en0 
                           on node: xxserv2 {up} 
                           on network: net_ether_02 {up} 
               Shared Volume Groups: 
                  oradata 
 
############# 
TOPOLOGY 
############# 
   hatest consists of the following nodes: xxserv1 xxserv2  
      xxserv1 
         Network interfaces: 
            diskhb_01 {up} 
               device: /dev/hdisk5 
               on network: net_diskhb_01 {up} 
            xxserv1 {up} 
               with IP address: 172.16.255.11 
               on interface: en0 
               on network: net_ether_02 {up} 
            xxserv1-stby {up} 
               with IP address: 192.168.0.11 
               on interface: en1 
               on network: net_ether_03 {up} 
      xxserv2 
         Network interfaces: 
            diskhb_02 {up} 
               device: /dev/hdisk5 
               on network: net_diskhb_01 {up} 
            xxserv2 {up} 
               with IP address: 172.16.255.13 
               on interface: en0 
               on network: net_ether_02 {up} 
            xxserv2-stby {up} 
               with IP address: 192.168.0.13 
               on interface: en1 
               on network: net_ether_03 {up} 

Before you start powerHA service,you must excute following steps on both nodes then you can run clstat command.

[root@xxserv1 utilities]# snmpv3_ssw -1  
Stop daemon: snmpmibd 
In /etc/rc.tcpip file, comment out the line that contains: snmpmibd 
In /etc/rc.tcpip file, remove the comment from the line that contains: dpid2 
Stop daemon: snmpd 
Make the symbolic link from /usr/sbin/snmpd to /usr/sbin/snmpdv1 
Make the symbolic link from /usr/sbin/clsnmp to /usr/sbin/clsnmpne 
Start daemon: dpid2 
Start daemon: snmpd 
 
[root@xxserv2 /]# snmpv3_ssw -1  
Stop daemon: snmpmibd 
In /etc/rc.tcpip file, comment out the line that contains: snmpmibd 
In /etc/rc.tcpip file, remove the comment from the line that contains: dpid2 
Stop daemon: snmpd 
Make the symbolic link from /usr/sbin/snmpd to /usr/sbin/snmpdv1 
Make the symbolic link from /usr/sbin/clsnmp to /usr/sbin/clsnmpne 
Start daemon: dpid2 
Start daemon: snmpd