• RAC database is available when at least one instance is up and running
• Shutting down a RAC database means shutting down all its instances
• RAC instances can be started and stopped by using:
Enterprise Manager Cloud Control
The Server Control ( srvctl ) utility
SQL*Plus
[root@srv2 oracle]# srvctl start database -d rac -startoption open
[root@srv2 oracle]# srvctl stop database -d rac -stopoption normal
[root@srv2 oracle]# srvctl stop database -d rac -stopoption immediate
[root@srv2 oracle]# srvctl stop database -d rac -stopoption transactional
[root@srv2 oracle]# srvctl stop database -d rac -stopoption abort
srvctl stop database -db rac -o immediate
srvctl stop database -db rac -o transactional
[root@srv2 oracle]# srvctl status database -d rac
[root@srv2 oracle]# srvctl start database -d rac -startoption open
[root@srv2 oracle]# srvctl stop database -d rac -stopoption normal
[root@srv2 oracle]# srvctl stop database -d rac -stopoption immediate
[root@srv2 oracle]# srvctl stop database -d rac -stopoption transactional
[root@srv2 oracle]# srvctl stop database -d rac -stopoption abort
[root@srv2 oracle]# srvctl stop instance -db rac -instance rac1,rac2
[root@srv2 oracle]# srvctl start instance -db rac -instance rac1,rac2
[root@srv2 oracle]# srvctl start instance -d rac -i rac1,rac2
[root@srv2 oracle]# srvctl stop instance -d rac -i rac1,rac2
srvctl stop database -db rac -o transactional
[root@srv2 oracle]# srvctl status database -d rac
[root@srv2 oracle]# srvctl status instance -i rac1 -d rac
Instance rac1 is running on node srv1
[root@srv2 oracle]# srvctl status instance -i rac2 -d rac
Instance rac2 is running on node srv2
- Check Status of Clusterware resources
[root@srv2 oracle]# crsctl status resource -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.BACKUP.ACFSBACKUP.advm
ONLINE ONLINE srv1 Volume device /dev/a
sm/acfsbackup-280 is
online,STABLE
ONLINE ONLINE srv2 Volume device /dev/a
sm/acfsbackup-280 is
online,STABLE
ora.BACKUP.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.CRS.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.DATA.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.FRA.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.asm
ONLINE ONLINE srv1 Started,STABLE
ONLINE ONLINE srv2 Started,STABLE
ora.backup.acfsbackup.acfs
ONLINE ONLINE srv1 mounted on /u01/ACFS
BACKUP,STABLE
ONLINE ONLINE srv2 mounted on /u01/ACFS
BACKUP,STABLE
ora.net1.network
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.ons
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE srv1 169.254.235.61 192.1
68.10.1,STABLE
ora.cvu
1 ONLINE ONLINE srv2 STABLE
ora.mgmtdb
1 ONLINE ONLINE srv1 Open,STABLE
ora.oc4j
1 ONLINE ONLINE srv2 STABLE
ora.rac.db
1 ONLINE ONLINE srv1 Open,STABLE
2 ONLINE ONLINE srv2 Open,STABLE
ora.scan1.vip
1 ONLINE ONLINE srv1 STABLE
ora.scan2.vip
1 ONLINE ONLINE srv1 STABLE
ora.scan3.vip
1 ONLINE ONLINE srv1 STABLE
ora.srv1.vip
1 ONLINE ONLINE srv1 STABLE
ora.srv2.vip
1 ONLINE ONLINE srv2 STABLE
--------------------------------------------------------------------------------
[root@srv2 oracle]#
[root@srv2 oracle]# srvctl status database -d rac
Instance rac1 is running on node srv1
Instance rac2 is running on node srv2
[root@srv2 oracle]# srvctl status instance -i rac1 -d rac
Instance rac1 is running on node srv1
[root@srv2 oracle]# srvctl status instance -i rac2 -d rac
Instance rac2 is running on node srv2
[root@srv2 oracle]# srvctl status instance -db rac -node srv2
Instance rac2 is running on node srv2
[root@srv2 oracle]# srvctl status instance -db rac -node srv1
Instance rac1 is running on node srv1
[root@srv2 oracle]#
[root@srv2 oracle]# srvctl status instance -db rac -instance rac1
Instance rac1 is running on node srv1
[root@srv2 oracle]# srvctl status instance -db rac -instance rac2
Instance rac2 is running on node srv2
[root@srv2 oracle]#
[root@srv2 oracle]# srvctl start database -d rac -startoption nomount
[root@srv2 oracle]# crsctl status resource -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.BACKUP.ACFSBACKUP.advm
ONLINE ONLINE srv1 Volume device /dev/a
sm/acfsbackup-280 is
online,STABLE
ONLINE ONLINE srv2 Volume device /dev/a
sm/acfsbackup-280 is
online,STABLE
ora.BACKUP.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.CRS.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.DATA.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.FRA.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.asm
ONLINE ONLINE srv1 Started,STABLE
ONLINE ONLINE srv2 Started,STABLE
ora.backup.acfsbackup.acfs
ONLINE ONLINE srv1 mounted on /u01/ACFS
BACKUP,STABLE
ONLINE ONLINE srv2 mounted on /u01/ACFS
BACKUP,STABLE
ora.net1.network
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.ons
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE srv1 169.254.235.61 192.1
68.10.1,STABLE
ora.cvu
1 ONLINE ONLINE srv2 STABLE
ora.mgmtdb
1 ONLINE ONLINE srv1 Open,STABLE
ora.oc4j
1 ONLINE ONLINE srv2 STABLE
ora.rac.db
1 ONLINE INTERMEDIATE srv1 Dismounted,STABLE
2 ONLINE INTERMEDIATE srv2 Dismounted,STABLE
ora.scan1.vip
1 ONLINE ONLINE srv1 STABLE
ora.scan2.vip
1 ONLINE ONLINE srv1 STABLE
ora.scan3.vip
1 ONLINE ONLINE srv1 STABLE
ora.srv1.vip
1 ONLINE ONLINE srv1 STABLE
ora.srv2.vip
1 ONLINE ONLINE srv2 STABLE
--------------------------------------------------------------------------------
[root@srv2 oracle]#
[root@srv2 oracle]# srvctl start database -d rac -startoption open
[root@srv2 oracle]# srvctl status database -d rac
Instance rac1 is running on node srv1
Instance rac2 is running on node srv2
[root@srv2 oracle]#
[root@srv2 oracle]# crsctl status resource -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.BACKUP.ACFSBACKUP.advm
ONLINE ONLINE srv1 Volume device /dev/a
sm/acfsbackup-280 is
online,STABLE
ONLINE ONLINE srv2 Volume device /dev/a
sm/acfsbackup-280 is
online,STABLE
ora.BACKUP.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.CRS.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.DATA.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.FRA.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.asm
ONLINE ONLINE srv1 Started,STABLE
ONLINE ONLINE srv2 Started,STABLE
ora.backup.acfsbackup.acfs
ONLINE ONLINE srv1 mounted on /u01/ACFS
BACKUP,STABLE
ONLINE ONLINE srv2 mounted on /u01/ACFS
BACKUP,STABLE
ora.net1.network
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.ons
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE srv1 169.254.235.61 192.1
68.10.1,STABLE
ora.cvu
1 ONLINE ONLINE srv2 STABLE
ora.mgmtdb
1 ONLINE ONLINE srv1 Open,STABLE
ora.oc4j
1 ONLINE ONLINE srv2 STABLE
ora.rac.db
1 ONLINE ONLINE srv1 Open,STABLE
2 ONLINE ONLINE srv2 Open,STABLE
ora.scan1.vip
1 ONLINE ONLINE srv1 STABLE
ora.scan2.vip
1 ONLINE ONLINE srv1 STABLE
ora.scan3.vip
1 ONLINE ONLINE srv1 STABLE
ora.srv1.vip
1 ONLINE ONLINE srv1 STABLE
ora.srv2.vip
1 ONLINE ONLINE srv2 STABLE
--------------------------------------------------------------------------------
[root@srv2 oracle]#
[root@srv2 oracle]# srvctl stop database -db rac -eval -stopoption immediate
PRKO-2712 : Administrator-managed database rac is not supported with -eval option
[root@srv2 oracle]#
[root@srv2 oracle]# srvctl start database -d rac -startoption mount
[root@srv2 oracle]# crsctl status resource -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.BACKUP.ACFSBACKUP.advm
ONLINE ONLINE srv1 Volume device /dev/a
sm/acfsbackup-280 is
online,STABLE
ONLINE ONLINE srv2 Volume device /dev/a
sm/acfsbackup-280 is
online,STABLE
ora.BACKUP.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.CRS.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.DATA.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.FRA.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.asm
ONLINE ONLINE srv1 Started,STABLE
ONLINE ONLINE srv2 Started,STABLE
ora.backup.acfsbackup.acfs
ONLINE ONLINE srv1 mounted on /u01/ACFS
BACKUP,STABLE
ONLINE ONLINE srv2 mounted on /u01/ACFS
BACKUP,STABLE
ora.net1.network
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.ons
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE srv1 169.254.235.61 192.1
68.10.1,STABLE
ora.cvu
1 ONLINE ONLINE srv2 STABLE
ora.mgmtdb
1 ONLINE ONLINE srv1 Open,STABLE
ora.oc4j
1 ONLINE ONLINE srv2 STABLE
ora.rac.db
1 ONLINE INTERMEDIATE srv1 Mounted (Closed),STA
BLE
2 ONLINE INTERMEDIATE srv2 Mounted (Closed),STA
BLE
ora.scan1.vip
1 ONLINE ONLINE srv1 STABLE
ora.scan2.vip
1 ONLINE ONLINE srv1 STABLE
ora.scan3.vip
1 ONLINE ONLINE srv1 STABLE
ora.srv1.vip
1 ONLINE ONLINE srv1 STABLE
ora.srv2.vip
1 ONLINE ONLINE srv2 STABLE
--------------------------------------------------------------------------------
[root@srv2 oracle]#
No comments:
Post a Comment