RAC(11gR2)OCRBACKUP&RESTORE

首先检查下OCR盘

创新互联专注为客户提供全方位的互联网综合服务,包含不限于成都网站建设、网站设计、双台子网络推广、微信平台小程序开发、双台子网络营销、双台子企业策划、双台子品牌公关、搜索引擎seo、人物专访、企业宣传片、企业代运营等,从售前售中售后,我们都将竭诚为您服务,您的肯定,是我们最大的嘉奖;创新互联为所有大学生创业者提供双台子建站搭建服务,24小时服务热线:028-86922220,官方网址:www.cdcxhl.com

[grid@rac1 cdata]$ ocrcheck

Status of OracleCluster Registry is as follows :

         Version                  :          3

         Total space (kbytes)     :    262120

         Used space (kbytes)      :      3068

         Available space (kbytes) :     259052

         ID                       : 1088979561

         Device/File Name         :      +CRS

                                    Device/Fileintegrity check succeeded

                                    Device/Filenot configured

                                    Device/Filenot configured

                                    Device/Filenot configured

                                    Device/Filenot configured

         Cluster registry integrity checksucceeded

         Logical corruption check bypassed dueto non-privileged user

 

[grid@rac1grid]$ cluvfy comp ocr -n all

Verifying OCR integrity

Checking OCRintegrity...

Checking the absence ofa non-clustered configuration...

All nodes free ofnon-clustered, local-only configurations

ASM Running checkpassed. ASM is running on all specified nodes

Checking OCR configfile "/etc/oracle/ocr.loc"...

OCR config file"/etc/oracle/ocr.loc" check successful

Disk group for ocrlocation "+CRS" available on all the nodes

NOTE:

This check does notverify the integrity of the OCR contents. Execute 'ocrcheck' as a privilegeduser to verify the contents of OCR.

OCR integrity checkpassed

Verification of OCRintegrity was successful.

 

备份asm参数文件

[grid@rac1grid]$ sqlplus / as sysasm

SQL> createpfile='/tmp/asm_pfile_20150306.txt' from spfile;

 

备份OCR盘

[root@rac1 grid]#bin/ocrconfig-export /tmp/ocr_bak20150306.dmp

模拟破坏OCR盘:

[root@rac1grid]# dd if=/dev/zero of=/dev/oracleasm/disks/CRS bs=1024 count=1000

破坏完后,检查集群状态

[grid@rac1grid]$ crsctl check crs

CRS-4638: Oracle HighAvailability Services is online

CRS-4537: Cluster ReadyServices is online

CRS-4529: ClusterSynchronization Services is online

CRS-4533: Event Manageris online

检查OCR一致性

[grid@rac1grid]$ cluvfy comp ocr -n all

Verifying OCR integrity

Checking OCRintegrity...

Checking the absence ofa non-clustered configuration...

All nodes free ofnon-clustered, local-only configurations

ASM Running checkpassed. ASM is running on all specified nodes

Checking OCR configfile "/etc/oracle/ocr.loc"...

OCR config file"/etc/oracle/ocr.loc" check successful

Disk group for ocrlocation "+CRS" available on all the nodes

NOTE:

This check does notverify the integrity of the OCR contents. Execute 'ocrcheck' as a privilegeduser to verify the contents of OCR.

OCR integrity checkpassed

Verification of OCRintegrity was successful.

重启CRS

[root@rac1grid]# bin/crsctl stop crs

CRS-2791: Startingshutdown of Oracle High Availability Services-managed resources on 'rac1'

CRS-2673: Attempting tostop 'ora.crsd' on 'rac1'

CRS-2790: Startingshutdown of Cluster Ready Services-managed resources on 'rac1'

CRS-2673: Attempting tostop 'ora.CRS.dg' on 'rac1'

CRS-2673: Attempting tostop 'ora.rac.db' on 'rac1'

CRS-2673: Attempting tostop 'ora.registry.acfs' on 'rac1'

CRS-2673: Attempting tostop 'ora.cvu' on 'rac1'

CRS-2673: Attempting tostop 'ora.oc4j' on 'rac1'

CRS-2673: Attempting tostop 'ora.LISTENER_SCAN1.lsnr' on 'rac1'

CRS-2673: Attempting tostop 'ora.LISTENER.lsnr' on 'rac1'

CRS-2677: Stop of'ora.cvu' on 'rac1' succeeded

CRS-2672: Attempting tostart 'ora.cvu' on 'rac2'

CRS-2677: Stop of'ora.LISTENER_SCAN1.lsnr' on 'rac1' succeeded

CRS-2673: Attempting tostop 'ora.scan1.vip' on 'rac1'

CRS-2676: Start of'ora.cvu' on 'rac2' succeeded

CRS-2677: Stop of'ora.LISTENER.lsnr' on 'rac1' succeeded

CRS-2673: Attempting tostop 'ora.rac1.vip' on 'rac1'

CRS-2677: Stop of'ora.scan1.vip' on 'rac1' succeeded

CRS-2672: Attempting tostart 'ora.scan1.vip' on 'rac2'

CRS-2677: Stop of'ora.rac1.vip' on 'rac1' succeeded

CRS-2672: Attempting tostart 'ora.rac1.vip' on 'rac2'

CRS-2677: Stop of'ora.registry.acfs' on 'rac1' succeeded

CRS-2676: Start of'ora.scan1.vip' on 'rac2' succeeded

CRS-2672: Attempting tostart 'ora.LISTENER_SCAN1.lsnr' on 'rac2'

CRS-2677: Stop of'ora.rac.db' on 'rac1' succeeded

CRS-2673: Attempting tostop 'ora.DATA.dg' on 'rac1'

CRS-2673: Attempting tostop 'ora.FRA.dg' on 'rac1'

CRS-2676: Start of'ora.rac1.vip' on 'rac2' succeeded

CRS-2676: Start of'ora.LISTENER_SCAN1.lsnr' on 'rac2' succeeded

CRS-2677: Stop of'ora.CRS.dg' on 'rac1' succeeded

CRS-2677: Stop of'ora.FRA.dg' on 'rac1' succeeded

CRS-2677: Stop of'ora.DATA.dg' on 'rac1' succeeded

CRS-2673: Attempting tostop 'ora.asm' on 'rac1'

CRS-2677: Stop of'ora.asm' on 'rac1' succeeded

CRS-2677: Stop of'ora.oc4j' on 'rac1' succeeded

CRS-2672: Attempting tostart 'ora.oc4j' on 'rac2'

CRS-2676: Start of'ora.oc4j' on 'rac2' succeeded

CRS-2673: Attempting tostop 'ora.ons' on 'rac1'

CRS-2677: Stop of'ora.ons' on 'rac1' succeeded

CRS-2673: Attempting tostop 'ora.net1.network' on 'rac1'

CRS-2677: Stop of'ora.net1.network' on 'rac1' succeeded

CRS-2792: Shutdown ofCluster Ready Services-managed resources on 'rac1' has completed

CRS-2677: Stop of'ora.crsd' on 'rac1' succeeded

CRS-2673: Attempting tostop 'ora.crf' on 'rac1'

CRS-2673: Attempting tostop 'ora.ctssd' on 'rac1'

CRS-2673: Attempting tostop 'ora.evmd' on 'rac1'

CRS-2673: Attempting tostop 'ora.asm' on 'rac1'

CRS-2673: Attempting tostop 'ora.mDNSd' on 'rac1'

CRS-2673: Attempting tostop 'ora.drivers.acfs' on 'rac1'

CRS-2677: Stop of'ora.crf' on 'rac1' succeeded

CRS-2677: Stop of'ora.evmd' on 'rac1' succeeded

CRS-2677: Stop of'ora.mdnsd' on 'rac1' succeeded

CRS-2677: Stop of'ora.ctssd' on 'rac1' succeeded

CRS-2677: Stop of'ora.asm' on 'rac1' succeeded

CRS-2673: Attempting tostop 'ora.cluster_interconnect.haip' on 'rac1'

CRS-2677: Stop of'ora.cluster_interconnect.haip' on 'rac1' succeeded

CRS-2673: Attempting tostop 'ora.cssd' on 'rac1'

CRS-2677: Stop of'ora.drivers.acfs' on 'rac1' succeeded

CRS-2677: Stop of'ora.cssd' on 'rac1' succeeded

CRS-2673: Attempting tostop 'ora.gipcd' on 'rac1'

CRS-2677: Stop of'ora.gipcd' on 'rac1' succeeded

CRS-2673: Attempting tostop 'ora.gpnpd' on 'rac1'

CRS-2677: Stop of'ora.gpnpd' on 'rac1' succeeded

CRS-2793: Shutdown ofOracle High Availability Services-managed resources on 'rac1' has completed

CRS-4133: Oracle HighAvailability Services has been stopped.

启动

[root@rac1grid]# bin/crsctl start crs

CRS-4123: Oracle HighAvailability Services has been started.

观察告警日志

[root@rac1 grid]# tail -100f/u01/app/11.2.0.4/grid/log/rac1/alertrac1.log

[/u01/app/11.2.0.4/grid/bin/orarootagent.bin(21098)]CRS-5016:Process"/u01/app/11.2.0.4/grid/bin/acfsregistrymount" spawned by agent"/u01/app/11.2.0.4/grid/bin/orarootagent.bin" for action"check" failed: details at "(:CLSN00010:)" in"/u01/app/11.2.0.4/grid/log/rac1/agent/crsd/orarootagent_root/orarootagent_root.log"

2015-03-0523:52:17.725:

[/u01/app/11.2.0.4/grid/bin/orarootagent.bin(21098)]CRS-5016:Process"/u01/app/11.2.0.4/grid/bin/acfsregistrymount" spawned by agent"/u01/app/11.2.0.4/grid/bin/orarootagent.bin" for action"check" failed: details at "(:CLSN00010:)" in"/u01/app/11.2.0.4/grid/log/rac1/agent/crsd/orarootagent_root/orarootagent_root.log"

2015-03-0618:46:58.197:

[/u01/app/11.2.0.4/grid/bin/orarootagent.bin(21098)]CRS-5822:Agent'/u01/app/11.2.0.4/grid/bin/orarootagent_root' disconnected from server.Details at (:CRSAGF00117:) {0:3:22642} in/u01/app/11.2.0.4/grid/log/rac1/agent/crsd/orarootagent_root/orarootagent_root.log.

2015-03-0618:47:00.102:

[ctssd(20098)]CRS-2405:TheCluster Time Synchronization Service on host rac1 is shutdown by user

[client(7931)]CRS-10001:06-Mar-1518:47 ACFS-9290: Waiting for ASM to shutdown.

2015-03-0618:47:01.435:

[mdnsd(19905)]CRS-5602:mDNSservice stopping by request.

2015-03-0618:47:11.506:

[cssd(19972)]CRS-1603:CSSDon node rac1 shutdown by user.

2015-03-0618:47:11.721:

[cssd(19972)]CRS-1660:TheCSS daemon shutdown has completed

2015-03-0618:47:12.299:

[ohasd(15515)]CRS-2767:Resourcestate recovery not attempted for 'ora.cssdmonitor' as its target state isOFFLINE

2015-03-0618:47:12.326:

[ohasd(15515)]CRS-2769:Unableto failover resource 'ora.cssdmonitor'.

2015-03-0618:47:13.861:

[ohasd(15515)]CRS-2769:Unableto failover resource 'ora.cssd'.

2015-03-0618:47:19.278:

[gpnpd(19923)]CRS-2329:GPNPDon node rac1 shutdown.

2015-03-0618:49:03.584:

[client(8370)]CRS-2302:Cannotget GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running).

2015-03-0618:49:03.585:

[client(8370)]CRS-1013:TheOCR location in an ASM disk group is inaccessible. Details in/u01/app/11.2.0.4/grid/log/rac1/client/crsctl_oracle.log.

...

2015-03-0618:54:12.281:

[client(9870)]CRS-2302:Cannotget GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running).

2015-03-0618:54:12.282:

[client(9870)]CRS-1013:TheOCR location in an ASM disk group is inaccessible. Details in/u01/app/11.2.0.4/grid/log/rac1/client/crsctl_oracle.log.

2015-03-0618:54:12.311:

[ohasd(9880)]CRS-2112:TheOLR service started on node rac1.

2015-03-0618:54:12.326:

[ohasd(9880)]CRS-1301:OracleHigh Availability Service started on node rac1.

2015-03-0618:54:12.382:

[ohasd(9880)]CRS-8017:location:/etc/oracle/lastgasp has 2 reboot advisory log files, 0 were announced and 0errors occurred

2015-03-0618:54:16.606:

[/u01/app/11.2.0.4/grid/bin/orarootagent.bin(9940)]CRS-2302:Cannotget GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running).

2015-03-0618:54:17.004:

[client(10084)]CRS-2302:Cannotget GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running).

2015-03-0618:54:17.005:

[client(10084)]CRS-1013:TheOCR location in an ASM disk group is inaccessible. Details in/u01/app/11.2.0.4/grid/log/rac1/client/crsctl_oracle.log.

2015-03-0618:54:20.445:

[client(10096)]CRS-2302:Cannotget GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running).

2015-03-0618:54:20.446:

[client(10096)]CRS-1013:TheOCR location in an ASM disk group is inaccessible. Details in/u01/app/11.2.0.4/grid/log/rac1/client/crsctl_oracle.log.

2015-03-0618:54:20.878:

[gpnpd(10132)]CRS-2328:GPNPDstarted on node rac1.

2015-03-0618:54:23.356:

[cssd(10234)]CRS-1713:CSSDdaemon is started in clustered mode

2015-03-0618:54:25.105:

[ohasd(9880)]CRS-2767:Resourcestate recovery not attempted for 'ora.diskmon' as its target state is OFFLINE

2015-03-0618:54:25.106:

[ohasd(9880)]CRS-2769:Unableto failover resource 'ora.diskmon'.

2015-03-0618:54:27.522:

[cssd(10234)]CRS-1714:Unableto discover any voting files, retrying discovery in 15 seconds; Details at(:CSSNM00070:) in /u01/app/11.2.0.4/grid/log/rac1/cssd/ocssd.log

2015-03-0618:54:42.598:

[cssd(10234)]CRS-1714:Unableto discover any voting files, retrying discovery in 15 seconds; Details at(:CSSNM00070:) in /u01/app/11.2.0.4/grid/log/rac1/cssd/ocssd.log

2015-03-0618:54:57.663:

[cssd(10234)]CRS-1714:Unableto discover any voting files, retrying discovery in 15 seconds; Details at(:CSSNM00070:) in /u01/app/11.2.0.4/grid/log/rac1/cssd/ocssd.log

2015-03-0618:55:12.729:

[cssd(10234)]CRS-1714:Unableto discover any voting files, retrying discovery in 15 seconds; Details at(:CSSNM00070:) in /u01/app/11.2.0.4/grid/log/rac1/cssd/ocssd.log

2015-03-0618:55:26.190:

[client(10467)]CRS-1013:TheOCR location in an ASM disk group is inaccessible. Details in/u01/app/11.2.0.4/grid/log/rac1/client/crsctl_oracle.log.

2015-03-0618:55:27.787:

[cssd(10234)]CRS-1714:Unableto discover any voting files, retrying discovery in 15 seconds; Details at(:CSSNM00070:) in /u01/app/11.2.0.4/grid/log/rac1/cssd/ocssd.log

2015-03-0618:55:42.844:

[cssd(10234)]CRS-1714:Unableto discover any voting files, retrying discovery in 15 seconds; Details at(:CSSNM00070:) in /u01/app/11.2.0.4/grid/log/rac1/cssd/ocssd.log

发现错误啦

检查集群进程状态

[root@rac1grid]# bin/crsctl check crs

CRS-4638: Oracle HighAvailability Services is online

CRS-4535: Cannotcommunicate with Cluster Ready Services

CRS-4530:Communications failure contacting Cluster Synchronization Services daemon

CRS-4534: Cannotcommunicate with Event Manager

 

检查OCR盘

[root@rac1grid]# bin/ocrcheck

PROT-602: Failed toretrieve data from the cluster registry

PROC-26: Error whileaccessing the physical storage

ORA-15077: could notlocate ASM instance serving a required diskgroup

ORA-29701: unable toconnect to Cluster Synchronization Service

 

恢复开始...

停掉CRS

[root@rac1grid]# bin/crsctl stop crs -f

CRS-2791: Startingshutdown of Oracle High Availability Services-managed resources on 'rac1'

CRS-2673: Attempting tostop 'ora.mdnsd' on 'rac1'

CRS-2673: Attempting tostop 'ora.crf' on 'rac1'

CRS-2677: Stop of'ora.crf' on 'rac1' succeeded

CRS-2673: Attempting tostop 'ora.gipcd' on 'rac1'

CRS-2677: Stop of'ora.mdnsd' on 'rac1' succeeded

CRS-2677: Stop of'ora.gipcd' on 'rac1' succeeded

CRS-2673: Attempting tostop 'ora.gpnpd' on 'rac1'

CRS-2677: Stop of'ora.gpnpd' on 'rac1' succeeded

CRS-2793: Shutdown ofOracle High Availability Services-managed resources on 'rac1' has completed

CRS-4133: Oracle HighAvailability Services has been stopped.

以独占方式启动CRS

[root@rac1grid]# bin/crsctl start crs -excl -nocrs

CRS-4123: Oracle HighAvailability Services has been started.

CRS-2672: Attempting tostart 'ora.mdnsd' on 'rac1'

CRS-2676: Start of'ora.mdnsd' on 'rac1' succeeded

CRS-2672: Attempting tostart 'ora.gpnpd' on 'rac1'

CRS-2676: Start of'ora.gpnpd' on 'rac1' succeeded

CRS-2672: Attempting tostart 'ora.cssdmonitor' on 'rac1'

CRS-2672: Attempting tostart 'ora.gipcd' on 'rac1'

CRS-2676: Start of'ora.cssdmonitor' on 'rac1' succeeded

CRS-2676: Start of'ora.gipcd' on 'rac1' succeeded

CRS-2672: Attempting tostart 'ora.cssd' on 'rac1'

CRS-2672: Attempting tostart 'ora.diskmon' on 'rac1'

CRS-2676: Start of'ora.diskmon' on 'rac1' succeeded

CRS-2676: Start of'ora.cssd' on 'rac1' succeeded

CRS-2672: Attempting tostart 'ora.drivers.acfs' on 'rac1'

CRS-2679: Attempting toclean 'ora.cluster_interconnect.haip' on 'rac1'

CRS-2672: Attempting tostart 'ora.ctssd' on 'rac1'

CRS-2681: Clean of'ora.cluster_interconnect.haip' on 'rac1' succeeded

CRS-2672: Attempting tostart 'ora.cluster_interconnect.haip' on 'rac1'

CRS-2676: Start of'ora.ctssd' on 'rac1' succeeded

CRS-2676: Start of'ora.drivers.acfs' on 'rac1' succeeded

CRS-2676: Start of'ora.cluster_interconnect.haip' on 'rac1' succeeded

CRS-2672: Attempting tostart 'ora.asm' on 'rac1'

CRS-2676: Start of'ora.asm' on 'rac1' succeeded

添加ASM磁盘组,用来作为新的OCR盘

[grid@rac1grid]$ sqlplus / as sysasm

SQL>create diskgroup OCRVOTE external redundancy disk 'ORCL:OCRVOTE' attribute'compatible.asm'='11.2.0.0.0','compatible.rdbms'='11.2.0.0.0';

将ASM参数文件创建到OCRVOTE盘上

SQL>create spfile='+OCRVOTE' from pfile='/tmp/asm_pfile_20150306.txt';

File created.

查看参数文件

[grid@rac1grid]$ asmcmd

ASMCMD> pwd

+OCRVOTE/rac/ASMPARAMETERFILE

ASMCMD> ls

REGISTRY.253.873671069

OCR指向新盘,所有节点都改

[root@rac1 grid]# vi/etc/oracle/ocr.loc

ocrconfig_loc=+OCRVOTE

local_only=FALSE

Restore OCRcontents from manual backup

[root@rac1 grid]# bin/ocrconfig -import /tmp/ocr_bak20150306.dmp

注,如果这边是用自动备份(即/u01/app/11.2.0.4/grid/cdata/rac/下的几个备份)的话,则用ocrconfig-restore /…./backup00.ocr来restore

ocrcheck一把

[root@rac1grid]# bin/ocrcheck

Status of OracleCluster Registry is as follows :

         Version                  :          3

         Total space (kbytes)     :    262120

         Used space (kbytes)      :      3100

         Available space (kbytes) :     259020

         ID                       :  408582211

         Device/File Name         :  +OCRVOTE

                                    Device/Fileintegrity check succeeded

                                    Device/Filenot configured

                                    Device/Filenot configured

                                    Device/Filenot configured

                                    Device/Filenot configured

         Cluster registry integrity checksucceeded

         Logical corruption check succeeded

Restore voting disk

[root@rac1grid]# bin/crsctl query css votedisk

Located 0 votingdisk(s).

[root@rac1grid]# bin/crsctl replace votedisk +OCRVOTE

Successful addition ofvoting disk 794a9685b6154fbfbf7095ba72878188.

Successfully replacedvoting disk group with +OCRVOTE.

CRS-4266: Votingfile(s) successfully replaced

[root@rac1grid]# bin/crsctl query css votedisk

##  STATE   File Universal Id               File Name Disk group

--  -----   -----------------               --------- ---------

 1. ONLINE  794a9685b6154fbfbf7095ba72878188 (ORCL:OCRVOTE) [OCRVOTE]

Located 1 votingdisk(s).

重启CRS

[root@rac1grid]# bin/crsctl stop crs

CRS-2791: Startingshutdown of Oracle High Availability Services-managed resources on 'rac1'

CRS-2673: Attempting tostop 'ora.drivers.acfs' on 'rac1'

CRS-2673: Attempting tostop 'ora.mdnsd' on 'rac1'

CRS-2673: Attempting tostop 'ora.ctssd' on 'rac1'

CRS-2673: Attempting tostop 'ora.asm' on 'rac1'

CRS-2677: Stop of'ora.mdnsd' on 'rac1' succeeded

CRS-2677: Stop of'ora.asm' on 'rac1' succeeded

CRS-2673: Attempting tostop 'ora.cluster_interconnect.haip' on 'rac1'

CRS-2677: Stop of'ora.cluster_interconnect.haip' on 'rac1' succeeded

CRS-2677: Stop of'ora.drivers.acfs' on 'rac1' succeeded

CRS-2677: Stop of'ora.ctssd' on 'rac1' succeeded

CRS-2673: Attempting tostop 'ora.cssd' on 'rac1'

CRS-2677: Stop of'ora.cssd' on 'rac1' succeeded

CRS-2673: Attempting tostop 'ora.gipcd' on 'rac1'

CRS-2677: Stop of'ora.gipcd' on 'rac1' succeeded

CRS-2673: Attempting tostop 'ora.gpnpd' on 'rac1'

CRS-2677: Stop of'ora.gpnpd' on 'rac1' succeeded

CRS-2793: Shutdown ofOracle High Availability Services-managed resources on 'rac1' has completed

CRS-4133: Oracle HighAvailability Services has been stopped.

[root@rac1grid]# bin/crsctl start crs

CRS-4123: Oracle HighAvailability Services has been started.

[root@rac1 grid]# bin/crsctl stat res -t              --11g集群资源启动需要点时间,过一会就OK了

CRS-4535: Cannotcommunicate with Cluster Ready Services

CRS-4000: CommandStatus failed, or completed with errors.

[root@rac1grid]# bin/crsctl stat res -t

CRS-4535: Cannotcommunicate with Cluster Ready Services

CRS-4000: CommandStatus failed, or completed with errors.

[root@rac1grid]# bin/crsctl stat res -t

--------------------------------------------------------------------------------

NAME           TARGET  STATE       SERVER                  STATE_DETAILS      

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.CRS.dg

              ONLINE  OFFLINE      rac1                                        

              OFFLINE OFFLINE      rac2                                        

ora.DATA.dg

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

ora.FRA.dg

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

ora.LISTENER.lsnr

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

ora.asm

               ONLINE  ONLINE      rac1                    Started            

               ONLINE  ONLINE      rac2                    Started            

ora.gsd

               OFFLINE OFFLINE      rac1                                        

               OFFLINE OFFLINE      rac2                                        

ora.net1.network

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

ora.ons

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

ora.registry.acfs

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.LISTENER_SCAN1.lsnr

      1       ONLINE  ONLINE       rac1                                        

ora.cvu

      1       ONLINE  ONLINE       rac1                                        

ora.oc4j

      1       ONLINE  ONLINE       rac1                                        

ora.rac.db

      1       ONLINE  ONLINE       rac1                     Open               

      2       ONLINE  ONLINE       rac2                     Open               

ora.rac1.vip

      1       ONLINE  ONLINE       rac1                                        

ora.rac2.vip

      1       ONLINE  ONLINE       rac2                                        

ora.scan1.vip

      1       ONLINE  ONLINE       rac1            

注意,因为这里我们磁盘组的名字已经换了,因此这里需要修改下CRS资源,并配置开机启动

查看原资源具体信息

[root@rac1grid]# bin/crsctl stat res ora.CRS.dg -p

NAME=ora.CRS.dg

TYPE=ora.diskgroup.type

ACL=owner:grid:rwx,pgrp:oinstall:rwx,other::r--

ACTION_FAILURE_TEMPLATE=

ACTION_SCRIPT=

AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%

ALIAS_NAME=

AUTO_START=never

CHECK_INTERVAL=300

CHECK_TIMEOUT=30

DEFAULT_TEMPLATE=

DEGREE=1

DESCRIPTION=CRSresource type definition for ASM disk group resource

ENABLED=1

LOAD=1

LOGGING_LEVEL=1

NLS_LANG=

NOT_RESTARTING_TEMPLATE=

OFFLINE_CHECK_INTERVAL=0

PROFILE_CHANGE_TEMPLATE=

RESTART_ATTEMPTS=5

SCRIPT_TIMEOUT=60

START_DEPENDENCIES=hard(ora.asm)pullup(ora.asm)

START_TIMEOUT=900

STATE_CHANGE_TEMPLATE=

STOP_DEPENDENCIES=hard(intermediate:ora.asm)

STOP_TIMEOUT=180

TYPE_VERSION=1.2

UPTIME_THRESHOLD=1d

USR_ORA_ENV=

USR_ORA_OPI=false

USR_ORA_STOP_MODE=

VERSION=11.2.0.4.0

[root@rac1 grid]# bin/crsctl stop res ora.CRS.dg

CRS-2500: Cannot stopresource 'ora.CRS.dg' as it is not running

CRS-4000: Command Stopfailed, or completed with errors.

[root@rac1grid]# bin/crsctl stop res ora.CRS.dg -f

CRS-2500: Cannot stop resource 'ora.CRS.dg' as itis not running

CRS-4000: Command Stopfailed, or completed with errors.

[root@rac1grid]# bin/crsctl  delete res ora.CRS.dg-f

[root@rac1grid]# bin/crsctl stat res -t

--------------------------------------------------------------------------------

NAME           TARGET  STATE       SERVER                  STATE_DETAILS      

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.DATA.dg

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

ora.FRA.dg

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

ora.LISTENER.lsnr

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

ora.asm

               ONLINE  ONLINE      rac1                    Started            

               ONLINE  ONLINE      rac2                    Started            

ora.gsd

               OFFLINE OFFLINE      rac1                                        

               OFFLINE OFFLINE      rac2                                        

ora.net1.network

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

ora.ons

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

ora.registry.acfs

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.LISTENER_SCAN1.lsnr

      1       ONLINE  ONLINE       rac1                                        

ora.cvu

      1       ONLINE  ONLINE       rac1                                        

ora.oc4j

      1       ONLINE  ONLINE       rac1                                        

ora.rac.db

      1       ONLINE  ONLINE       rac1                     Open               

      2       ONLINE  ONLINE       rac2                     Open               

ora.rac1.vip

      1       ONLINE  ONLINE       rac1                                        

ora.rac2.vip

      1       ONLINE  ONLINE       rac2                                        

ora.scan1.vip

      1       ONLINE  ONLINE       rac1    

已经删除了ora.CRS.dg资源,现在添加新的资源

[grid@rac1grid]$ crsctl add res ora.OCRVOTE.dg -type ora.diskgroup.type -attr"ACL='owner:grid:rwx,pgrp:oinstall:rwx,other::r--',AUTO_START=always,VERSION=11.2.0.4.0"-i

[grid@rac1grid]$ crsctl stat res -t

--------------------------------------------------------------------------------

NAME           TARGET  STATE       SERVER                  STATE_DETAILS      

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.DATA.dg

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

ora.FRA.dg

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

ora.LISTENER.lsnr

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

ora.OCRVOTE.dg

               OFFLINE OFFLINE      rac1                                        

               OFFLINE OFFLINE      rac2                                        

ora.asm

               ONLINE  ONLINE      rac1                    Started            

               ONLINE  ONLINE      rac2                    Started            

ora.gsd

               OFFLINE OFFLINE      rac1                                        

               OFFLINE OFFLINE      rac2                                        

ora.net1.network

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

ora.ons

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

ora.registry.acfs

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.LISTENER_SCAN1.lsnr

      1       ONLINE  ONLINE       rac1                                        

ora.cvu

      1       ONLINE  ONLINE       rac1                                        

ora.oc4j

      1       ONLINE  ONLINE       rac1                                        

ora.rac.db

      1       ONLINE  ONLINE       rac1                     Open               

      2       ONLINE  ONLINE       rac2                     Open               

ora.rac1.vip

      1       ONLINE  ONLINE       rac1                                        

ora.rac2.vip

      1       ONLINE  ONLINE       rac2                                        

ora.scan1.vip

      1       ONLINE  ONLINE       rac1

启动资源

[grid@rac1grid]$ crsctl start res ora.OCRVOTE.dg

CRS-2672: Attempting tostart 'ora.OCRVOTE.dg' on 'rac1'

CRS-2672: Attempting tostart 'ora.OCRVOTE.dg' on 'rac2'

CRS-2676: Start of'ora.OCRVOTE.dg' on 'rac2' succeeded

CRS-2676: Start of'ora.OCRVOTE.dg' on 'rac1' succeeded

[grid@rac1grid]$ crsctl stat res -t

--------------------------------------------------------------------------------

NAME           TARGET  STATE       SERVER                  STATE_DETAILS      

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.DATA.dg

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

ora.FRA.dg

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

ora.LISTENER.lsnr

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

ora.OCRVOTE.dg

               ONLINE  ONLINE      rac1                                        

               ONLINE  ONLINE      rac2                                        

ora.asm

               ONLINE  ONLINE      rac1                    Started            

               ONLINE  ONLINE      rac2                    Started            

ora.gsd

               OFFLINE OFFLINE      rac1                                        

               OFFLINE OFFLINE      rac2                                        

ora.net1.network

               ONLINE  ONLINE      rac1                                        


网站栏目:RAC(11gR2)OCRBACKUP&RESTORE
路径分享:http://bzwzjz.com/article/gpcchd.html

其他资讯

Copyright © 2007-2020 广东宝晨空调科技有限公司 All Rights Reserved 粤ICP备2022107769号
友情链接: 营销网站建设 网站制作 成都网站建设公司 响应式网站设计 成都网站设计 重庆网站建设 成都网站建设 攀枝花网站设计 成都模版网站建设 LED网站设计方案 成都商城网站建设 高端定制网站设计 网站制作 成都网站建设公司 成都网站设计公司 手机网站制作 成都响应式网站建设公司 企业网站设计 古蔺网站建设 网站设计制作 定制网站制作 成都网站设计