Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Oralce 11g rac ocr and votedisk migration

2025-02-28 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

1. Create a new disk group + NEW

Create diskgroup CRS NORMAL REDUNDANCY

FAILGROUP CRS_0000 disk'/ dev/asm-orctest1'

FAILGROUP CRS_0001 disk'/ dev/asm-orctest2'

FAILGROUP CRS_0002 disk'/ dev/asm-orctest3'

ATTRIBUTE 'compatible.asm' =' 11.2'

2. View ocr backup

[root@rac02 bin] #. / ocrconfig-manualbackup

Ocrconfig-showbackup

[root@rac02 bin] #. / ocrconfig-showbackup manual

Rac01 2017-08-03 06:47:10 / u01/11.2.0/grid/cdata/rac-cluster/backup_20170803_064710.ocr

Rac02 2017-08-01 02:32:01 / u01/11.2.0/grid/cdata/rac-cluster/backup_20170801_023201.ocr

2. 2 nodes stop the cluster and modify the configuration file (change the name of the disk group inside to the new disk group)

. / crsctl stop crs

Vi / etc/oracle/ocr.loc

3. Start a node to exclusive mode and confirm whether the disk group + NEW is mount. If not, manually mount.

Crsctl start crs-excl-nocrs

SQL > select GROUP_NUMBER, NAME,STATE from v$asm_diskgroup

GROUP_NUMBER NAME STATE

1 ASM_DATA1 MOUNTED

2 ASM_FL MOUNTED

3 CRS MOUNTED

4 DATA MOUNTED

4. Use OCR backup to restore OCR to a new disk group (be careful to change ocr.loc ahead of time)

#. / ocrconfig-restore / u01/11.2.0/grid/cdata/rac-cluster/backup_20170801_023201.ocr

[root@rac02 bin] #. / ocrconfig-manualbackup

Rac01 2017-08-03 06:47:10 / u01/11.2.0/grid/cdata/rac-cluster/backup_20170803_064710.ocr

Rac02 2017-08-01 02:32:01 / u01/11.2.0/grid/cdata/rac-cluster/backup_20170801_023201.ocr

5. Restore votedisk

[root@rac02 bin] #. / crsctl replace votedisk + CRS

[root@rac02 bin] #. / ocrconfig-restore / u01/11.2.0/grid/cdata/rac-cluster/backup_20170801_023201.ocr

[root@rac02 bin] #. / crsctl replace votedisk + CRS

Successful addition of voting disk 99fc4fb627ab4ffabfa4819288ef362d.

Successful addition of voting disk 69c39aef708f4f0abf39c97b4c55dcea.

Successful addition of voting disk 6bef23769bae4f5fbfb594f99707b160.

Successful deletion of voting disk 264b8b526ac54fe9bf80c5eee1350526.

Successfully replaced voting disk group with + CRS.

CRS-4266: Voting file (s) successfully replaced

Check

The result of ocrcheck- check has not changed.

Crsctl query css votedisk

[root@rac02 bin] #. / ocrcheck

Status of Oracle Cluster Registry is as follows:

Version: 3

Total space (kbytes): 262120

Used space (kbytes): 3480

Available space (kbytes): 258640

ID: 1128199232

Device/File Name: + DATA

Device/File integrity check succeeded

Device/File not configured

Device/File not configured

Device/File not configured

Device/File not configured

Cluster registry integrity check succeeded

Logical corruption check succeeded

[root@rac02 bin] #. / crsctl query css votedisk

# # STATE File Universal Id File Name Disk group

1. ONLINE 99fc4fb627ab4ffabfa4819288ef362d (/ dev/asm-orctest1) [CRS]

2. ONLINE 69c39aef708f4f0abf39c97b4c55dcea (/ dev/asm-orctest2) [CRS]

3. ONLINE 6bef23769bae4f5fbfb594f99707b160 (/ dev/asm-orctest3) [CRS]

Located 3 voting disk (s).

6. Delete the original

. / ocrconfig-delete + DATA

Then restart the cluster

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report