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

Example Analysis of RAC_OCR Management

2025-01-29 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

This article introduces you the example analysis of RAC_OCR management, the content is very detailed, interested friends can refer to, hope to be helpful to you.

Manage OCR

OCR is the Oracle RAC configuration information repository, which manages the relevant information of cluster nodes and instance-to-node mapping information. The processes that make up the CRS and other applications that support clusters use this repository to share information. It includes, but is not limited to, the following:

1 Node membership information

2 Database instance, node and other mapping information

3 Service characteristics

4 characteristics of any third-party application controlled by CRS (10g R2 and later)

The location of OCR is specified during CRS installation. The file pointer to the location of the OCR device is located in the file ocr.loc, which is more or less platform-dependent. For example, in Linux systems, it is in / etc/oracle; in Solaris systems, it is in / var/opt/oracle. The ocr.loc content is as follows:

# ocrconfig_loc=+ASMCCF1

Local_only=FALSE

The first line provides information about the last operation performed on OCR, which affects the contents of the ocr.loc file. Versions above Oracle 10g R2 provide the option of mirroring OCR at the Oracle level or operating system level to provide high availability.

For OCR, routine maintenance is rarely required. But OCR is a key component of the HA framework, so if anything happens to OCR. Then corrective measures should be taken at any time. The following Oracle uses tools to manage OCR. You should contact these commands in the test system to prepare for unexpected events that occur in OCR:

1 ocrchek: performs a quick health check on OCR and outputs space usage statistics.

2 ocrdump: dump the contents of OCR to an operating system file

3 ocrconfig: perform export, import, add, replace, delete, restore, and display backup operations on OCR.

First check the integrity of OCR

We can use ocrcheck to perform a quick health check on OCR, as shown below. This command returns the OCR version, the total space allocated, the space used, the free space, the location of each device, and the result of the integrity check.

[root@vmac1] # $GRID_HOME/bin/ocrcheck

This command also creates a log file in the $GRID_HOME/log//client directory; the contents of this log file reflect what is displayed in the output.

Second dump OCR information

Ocrdump, a tool provided by Oracle, writes the contents of OCR to operating system files, and by default it dumps them to a file called OCRDUMP in the current directory. Alternatively, you can specify a target file, or you can dump the information in XML format. Using the command with the-help option, you can view the command-line options available for this command.

The contents of the dump file are usually used by OSS (Oracle support Service) to view configuration information in OCR. This dump file is an ASCII file, which can be opened using any text editor. This file contains a set of key names, value types, and key value information.

Here is how to dump the contents of an OCR file into a XML file:

[root@vmac1] # $GRID_HOME/bin/ocrdump 1.xml-xml

3. Maintain a mirror OCR

Starting with the 10gR2 version, Oracle allows you to create a mirrored copy of OCR so that OCR is no longer a single point of failure. And this eliminates the need to mirror OCR using methods other than Oracle, such as storage-level or array-level mirrors.

(1)

The following command adds / redeploys the ocrmirror file to the specified location:

[root@vmac1] # $GRID_HOME/bin/ocrconfig-replace ocrmirror'+ ASMCCF1'

Redeploy an existing OCR file:

Ocrconfig-replace ocr'+ ASMCCF1'

(2)

Back up the OCR manually

# ocrconfig-manualbackup

(3)

View backed-up OCR files

# ocrconfig-showbackup

(4)

View the contents of the OCR backup file

# ocrdump-backupfile backup_file_name

(5)

Restore OCR backup files

# ocrconfig-restore file_name

(6)

Create an OCR file as root user in disk group DATABASE

# ocrconfig-add + database

(7)

Delete redundant OCR files

# ocrconfig-delete + database

(8)

Migrate OCR files from diskgroup DATA to diskgroup DATABASE

# ocrconfig-replace + data-replacement + database

(9)

Add OCR Mirror

[root@test233] # touch / oracle/ocrfile2

[root@test233] # ocrconfig-replace ocrmirror / oracle/ocrfile2

(10)

Delete mirror online

[root@test233 #] ocrconfig-replace ocrmirror

Manage Oracle Local Registry (OLR)

Although not all commands that can be used to manage OCR are available for OLR use, you can manage the Oracle local registry in a similar way to managing the Oracle clustered registry. You can use the command to manage OLR, but add the-local option to the command line:

Ocrcheck-local

Ocrdump-local

Ocrconfig-local-export filename

Ocrconfig-local-import filename

Ocrconfig-local-repair old filename

This is the end of the sample analysis on RAC_OCR management. I hope the above content can be helpful to you and learn more knowledge. If you think the article is good, you can share it for more people to see.

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: 241

*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