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

Backup and recovery of oracle vote disk and ocr disk

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

Share

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

Introduction to 1.ocr disk

The problem of forgetfulness is caused by the fact that each node has a copy of the configuration information and the configuration information of the modified node is out of sync. The solution adopted by Oracle is to put the configuration file on the shared storage, which is called OCR Disk. The information of the whole OCR is tree-shaped and is mainly divided into three branches. They are SYSTEM,DATABASE and CRS, each of which has many small branches, which can only be modified by root users. OCR is backed up every 4 hours, keeping only five files, three files on the same day, one last week and one last month.

The OCR DISK content includes:

1)。 Node information

2)。 Database instances, nodes, and other mapping relationships

3). Rac resource configuration information (VIP,SERVICES)

4)。 Database starts related processes

5) .CRS each three-party application information

2.ocrcheck (check the content of ocr, check the status of ocr)

[grid@rac2 ~] $ocrcheck

Status of Oracle Cluster Registry is as follows:

Version: 3

Total space (kbytes): 262120

Used space (kbytes): 3140

Available space (kbytes): 258980

ID: 1119662722

Device/File Name: + OCR

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 bypassed due to non-privileged user

[grid@rac2 ~] $

3.ocrdump (view the contents of the ocr file)

[root@rac1 ~] # ll / home/grid/11.2.0/grid/cdata/scan-cluster/

Total 58360

-rw- 1 root root 7462912 Oct 8 18:44 27255153.ocr

-rw- 1 root root 7462912 Oct 10 14:44 backup00.ocr

-rw- 1 root root 7462912 Oct 9 17:58 backup01.ocr

-rw- 1 root root 7462912 Oct 9 13:58 backup02.ocr

-rw- 1 root root 7462912 Oct 10 14:45 day_.ocr

-rw- 1 root root 7462912 Oct 9 13:58 day.ocr

-rw- 1 root root 7462912 Oct 9 17:58 week_.ocr

-rw- 1 root root 7421952 Sep 26 14:48 week.ocr

[root@rac1] # / home/grid/11.2.0/grid/bin/ocrdump-backupfile / home/grid/11.2.0/grid/cdata/scan-cluster/backup00.ocr

[root@rac1 ~] # ll OCRDUMPFILE-the current destination generates an OCRDUMPFILE file at this time

-rw- 1 root root 220258 Oct 10 16:32 OCRDUMPFILE

[root@rac1 ~] # more OCRDUMPFILE

10/10/2016 16:32:25

/ home/grid/11.2.0/grid/cdata/scan-cluster/backup00.ocr

/ home/grid/11.2.0/grid/bin/ocrdump.bin-backupfile / home/grid/11.2.0/grid/cdata/scan-cluster/backup00.ocr

[SYSTEM]

UNDEF:

SECURITY: {USER_PERMISSION: PROCR_ALL_ACCESS, GROUP_PERMISSION: PROCR_READ, OTHER_PERMISSION: PROCR_READ, USER_NAME: root, GROUP_NAME: root}

[root@rac1 ~] #

4.ocrconfig (maintain ocr disks)

[root@rac1] # / home/grid/11.2.0/grid/bin/ocrconfig-showbackup

Rac1 2016-10-10 14:45:03 / home/grid/11.2.0/grid/cdata/scan-cluster/backup00.ocr

Rac1 2016-10-09 17:58:37 / home/grid/11.2.0/grid/cdata/scan-cluster/backup01.ocr

Rac1 2016-10-09 13:58:33 / home/grid/11.2.0/grid/cdata/scan-cluster/backup02.ocr

Rac1 2016-10-09 13:58:33 / home/grid/11.2.0/grid/cdata/scan-cluster/day.ocr

Rac1 2016-09-26 14:48:52 / home/grid/11.2.0/grid/cdata/scan-cluster/week.ocr

[root@rac1 ~] # / home/grid/11.2.0/grid/bin/ocrconfig-manualbackup-enable manual backup

Rac1 2016-10-10 17:44:03 / home/grid/11.2.0/grid/cdata/scan-cluster/backup_20161010_174403.ocr

[root@rac1] # / home/grid/11.2.0/grid/bin/ocrconfig-restore / home/grid/11.2.0/grid/cdata/scan-cluster/backup_20161010_174403.ocr-restore ocr information

[root@rac1 ~] #

5. Backing up ocr disks manually

[root@rac1] # / home/grid/11.2.0/grid/bin/ocrconfig-export / tmp/ocr-20161010.back

[root@rac1 ~] # ll / tmp/ocr-20161010.back

-rw- 1 root root 125185 Oct 10 17:49 / tmp/ocr-20161010.back

[root@rac1 ~] # / home/grid/11.2.0/grid/bin/ocrconfig-import / tmp/ocr-20161010.back-crs service must be stopped on import

Introduction to 6.vote disk disk

Voting Disk this file is mainly used to record the status of node members, in the event of a brain fissure, determine which Partion to gain control, and other Partion must be removed from the cluster. You will also be prompted to specify this location when you install RAC. After installation, you can use the crsctl query css votedisk command to check the Voting Disk location. Oracle rac 10G can use dd tool to back up voting disk, oracle rac 11g voting disk and ocr disk are together, can not use dd tool backup.

1)。 Backup voting disk

Dd if=/dev/raw/raw3 of=/tmp/votedisk.back bs=1024M count=10

2)。 Restore voting disk

Dd if=/tmp/votedisk.back of=/dev/raw/raw3 bs=1024M count=10

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