首页 文章 精选 留言 我的

精选列表

搜索[图形化操作],共10000篇文章
优秀的个人博客,低调大师

表决盘与仲裁盘操作

查看表决盘 [root@testdb1 ~]# crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 4a4d2ebc4ab64fa5bfb9c2ad51df2f06 (/dev/asm-diskm) [OCR_VOTE] 2. ONLINE 4098f6aa168a4f93bf1f6364273fe911 (/dev/asm-diski) [OCR_VOTE] 3. ONLINE 2a2c91ae30374fa0bfc8cb65feae7cf8 (/dev/asm-diskg) [OCR_VOTE] 4. ONLINE a808cd9fc5664f73bf1873c948f35fa6 (/dev/asm-diskf) [OCR_VOTE] 5. ONLINE 445d6133f4714fadbfd653f09ddca99c (/dev/asm-diskd) [OCR_VOTE] Located 5 voting disk(s). [root@testdb1 ~]# 把表决盘从ASM迁移到集群文件系统 root@testdb1[+ASM1]/odc/xx$crsctl replace votedisk /odc/xx/xx Now formatting voting disk: /odc/xx/xx. CRS-4256: Updating the profile Successful addition of voting disk ab9c20eb088e4f3dbfc0a241a06e2f37. Successful deletion of voting disk 4a4d2ebc4ab64fa5bfb9c2ad51df2f06. Successful deletion of voting disk 4098f6aa168a4f93bf1f6364273fe911. Successful deletion of voting disk 2a2c91ae30374fa0bfc8cb65feae7cf8. Successful deletion of voting disk a808cd9fc5664f73bf1873c948f35fa6. Successful deletion of voting disk 445d6133f4714fadbfd653f09ddca99c. CRS-4256: Updating the profile CRS-4266: Voting file(s) successfully replaced root@testdb1[+ASM1]/odc/xx$ll total 20520 -rw-r----- 1 grid oinstall 21004800 May 25 08:21 xx root@testdb1[+ASM1]/odc/xx$crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE ab9c20eb088e4f3dbfc0a241a06e2f37 (/odc/xx/xx) [] Located 1 voting disk(s). 将表决盘从集群文件迁移到ASM root@testdb1[+ASM1]/odc/xx$crsctl replace votedisk /odc/xx/xx Now formatting voting disk: /odc/xx/xx. CRS-4256: Updating the profile Successful addition of voting disk ab9c20eb088e4f3dbfc0a241a06e2f37. Successful deletion of voting disk 4a4d2ebc4ab64fa5bfb9c2ad51df2f06. Successful deletion of voting disk 4098f6aa168a4f93bf1f6364273fe911. Successful deletion of voting disk 2a2c91ae30374fa0bfc8cb65feae7cf8. Successful deletion of voting disk a808cd9fc5664f73bf1873c948f35fa6. Successful deletion of voting disk 445d6133f4714fadbfd653f09ddca99c. CRS-4256: Updating the profile CRS-4266: Voting file(s) successfully replaced root@testdb1[+ASM1]/odc/xx$ll total 20520 -rw-r----- 1 grid oinstall 21004800 May 25 08:21 xx root@testdb1[+ASM1]/odc/xx$crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE ab9c20eb088e4f3dbfc0a241a06e2f37 (/odc/xx/xx) [] Located 1 voting disk(s). root@testdb1[+ASM1]/odc/xx$ cd root@testdb1[+ASM1]/root$crsctl replace votedisk +OCR_VOTE CRS-4256: Updating the profile Successful addition of voting disk 575a6470237b4f7dbf16048d82229fcc. Successful addition of voting disk 2f9dab1fb1164f3bbf3365b37e3e887b. Successful addition of voting disk 8944dca8fb0e4f82bff80f0527a15cec. Successful addition of voting disk 2074a36da5154f25bf0ff4b83fabfe84. Successful addition of voting disk 56e7bbc906e04f08bfb554a99afd87db. Successful deletion of voting disk ab9c20eb088e4f3dbfc0a241a06e2f37. Successfully replaced voting disk group with +OCR_VOTE. CRS-4256: Updating the profile CRS-4266: Voting file(s) successfully replaced root@testdb1[+ASM1]/root$crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 575a6470237b4f7dbf16048d82229fcc (/dev/asm-diskm) [OCR_VOTE] 2. ONLINE 2f9dab1fb1164f3bbf3365b37e3e887b (/dev/asm-diski) [OCR_VOTE] 3. ONLINE 8944dca8fb0e4f82bff80f0527a15cec (/dev/asm-diskg) [OCR_VOTE] 4. ONLINE 2074a36da5154f25bf0ff4b83fabfe84 (/dev/asm-diskf) [OCR_VOTE] 5. ONLINE 56e7bbc906e04f08bfb554a99afd87db (/dev/asm-diskd) [OCR_VOTE] Located 5 voting disk(s). root@testdb1[+ASM1]/root$ 添加表决盘(在集群文件中) root@testdb1[+ASM1]/root$crsctl replace votedisk /odc/xx/test1 Now formatting voting disk: /odc/xx/test1. CRS-4256: Updating the profile Successful addition of voting disk 7f8f22c602384f17bf1dfd4822308d44. Successful deletion of voting disk 575a6470237b4f7dbf16048d82229fcc. Successful deletion of voting disk 2f9dab1fb1164f3bbf3365b37e3e887b. Successful deletion of voting disk 8944dca8fb0e4f82bff80f0527a15cec. Successful deletion of voting disk 2074a36da5154f25bf0ff4b83fabfe84. Successful deletion of voting disk 56e7bbc906e04f08bfb554a99afd87db. CRS-4256: Updating the profile CRS-4266: Voting file(s) successfully replaced root@testdb1[+ASM1]/root$crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 7f8f22c602384f17bf1dfd4822308d44 (/odc/xx/test1) [] Located 1 voting disk(s). root@testdb1[+ASM1]/root$crsctl add css votedisk /odc/xx/test2 Now formatting voting disk: /odc/xx/test2. CRS-4603: Successful addition of voting disk /odc/xx/test2. root@testdb1[+ASM1]/root$crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 7f8f22c602384f17bf1dfd4822308d44 (/odc/xx/test1) [] 2. ONLINE 4fc48fe3b68f4f74bff440fed7b3ab4e (/odc/xx/test2) [] Located 2 voting disk(s). root@testdb1[+ASM1]/root$ 添加表决盘(在ASM中) 注意事项:表决盘存在ASM注意事项 * 如果表决盘存放在ASM中,则表决文件的镜像,由磁盘组完成,不在需要另外一个磁盘组做镜像 * 不允许表决盘同时存在ASM和集群文件系统中。 删除表决盘(在集群文件系统中) root@testdb1[+ASM1]/root$crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 7f8f22c602384f17bf1dfd4822308d44 (/odc/xx/test1) [] 2. ONLINE 4fc48fe3b68f4f74bff440fed7b3ab4e (/odc/xx/test2) [] Located 2 voting disk(s). root@testdb1[+ASM1]/root$crsctl delete css votedisk /odc/xx/test2 CRS-4611: Successful deletion of voting disk /odc/xx/test2. root@testdb1[+ASM1]/root$ root@testdb1[+ASM1]/root$crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 7f8f22c602384f17bf1dfd4822308d44 (/odc/xx/test1) [] Located 1 voting disk(s). root@testdb1[+ASM1]/root$ 恢复原状 root@testdb1[+ASM1]/root$crsctl replace votedisk +OCR_VOTE CRS-4256: Updating the profile Successful addition of voting disk 531089329c6e4fd7bf55527321648aeb. Successful addition of voting disk 228bc2cc1a624f2bbff2ed7ed24d3a36. Successful addition of voting disk 2ddb39eaa1a54ff0bf38c48b12a7315c. Successful addition of voting disk 735db22d36d14f31bf446493c25cf1bc. Successful addition of voting disk 5cc9d45f6ade4f98bf16c78be12fa786. Successful deletion of voting disk 7f8f22c602384f17bf1dfd4822308d44. Successfully replaced voting disk group with +OCR_VOTE. CRS-4256: Updating the profile CRS-4266: Voting file(s) successfully replaced root@testdb1[+ASM1]/root$ 仲裁盘OCR集群资源的配置信息。 root@testdb1[+ASM1]/root$ocrcheck Status of Oracle Cluster Registry is as follows : Version : 3 Total space (kbytes) : 262120 Used space (kbytes) : 3216 Available space (kbytes) : 258904 ID : 545177980 Device/File Name : +OCR_VOTE 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 只存在一个存放OCR的路径是+OCR_VOTE touch /odc/ocrmirr/ocr_mirror1chown root.oinstall /odc/ocrmirr/ocr_mirror1chomd 640 /odc/ocrmirr/ocr_mirror1 touch /odc/ocrmirrchown root.oinstall /odc/ocrmirrchmod 640 /odc/ocrmirr 镜像OCR 检查镜像现有位置 现有只存在一个存放OCR的路径是+OCR_VOTE root@testdb1[+ASM1]/root$ocrcheck Status of Oracle Cluster Registry is as follows : Version : 3 Total space (kbytes) : 262120 Used space (kbytes) : 3232 Available space (kbytes) : 258888 ID : 545177980 Device/File Name : +OCR_VOTE 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 添加一个ASM磁盘后,再配置一个OCR root@testdb1[+ASM1]/root$ocrconfig -add +OCR_VOTE2 检查镜像现有位置 root@testdb1[+ASM1]/root$ocrcheck Status of Oracle Cluster Registry is as follows : Version : 3 Total space (kbytes) : 262120 Used space (kbytes) : 3232 Available space (kbytes) : 258888 ID : 545177980 Device/File Name : +OCR_VOTE Device/File integrity check succeeded Device/File Name : +OCR_VOTE2 Device/File integrity check succeeded Device/File not configured Device/File not configured Device/File not configured Cluster registry integrity check succeeded 删除OCR root@testdb1[+ASM1]/root$ocrconfig -delete +OCR_VOTE2 root@testdb1[+ASM1]/root$ocrcheck Status of Oracle Cluster Registry is as follows : Version : 3 Total space (kbytes) : 262120 Used space (kbytes) : 3232 Available space (kbytes) : 258888 ID : 545177980 Device/File Name : +OCR_VOTE 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 替换OCR OCR的备份 Oracle会自动备份,每隔4个小时。 手工备份 root@testdb1[+ASM1]/odc$ocrconfig -manualbackup testdb1 2021/05/25 09:13:58 /grid/grid_home/cdata/testdb-cluster/backup_20210525_091358.ocr root@testdb1[+ASM1]/odc$ocrconfig -showbackup testdb1 2021/05/16 13:40:02 /grid/grid_home/cdata/testdb-cluster/backup00.ocr testdb2 2021/05/15 17:47:50 /grid/grid_home/cdata/testdb-cluster/backup01.ocr testdb2 2018/12/11 02:05:36 /grid/grid_home/cdata/testdb-cluster/backup02.ocr testdb2 2021/05/15 17:47:50 /grid/grid_home/cdata/testdb-cluster/day.ocr testdb2 2021/05/15 17:47:50 /grid/grid_home/cdata/testdb-cluster/week.ocr testdb1 2021/05/25 09:13:58 /grid/grid_home/cdata/testdb-cluster/backup_20210525_091358.ocr root@testdb1[+ASM1]/odc$ dump备份的ocr文件,会生成一个文件,查看生成文件 ocrdump -backupfile /grid/grid_home/cdata/testdb-cluster/backup_20210525_091358.ocr 查看OCR备份文件 root@testdb1[+ASM1]/root$ocrdump -backupfile /grid/grid_home/cdata/testdb-cluster/backup_20210525_091358.ocr 查看OCR备份文件 OCRDUMPFILE root@testdb1[+ASM1]/root$lltotal 352-rw-------. 1 root root 2153 Mar 24 2018 anaconda-ks.cfgdrwxr-xr-x 3 root root 4096 Mar 25 2018 Desktopdrwxr-xr-x 2 root root 4096 Mar 24 2018 Documentsdrwxr-xr-x 2 root root 4096 Mar 24 2018 Downloads-rw-r--r--. 1 root root 64378 Mar 24 2018 install.log-rw-r--r--. 1 root root 19598 Mar 24 2018 install.log.syslogdrwxr-xr-x 2 root root 4096 Mar 24 2018 Music-rw------- 1 root root 225959 May 25 09:17 OCRDUMPFILEdrwxr-xr-x 2 root root 4096 Mar 24 2018 Picturesdrwxr-xr-x 2 root root 4096 Mar 24 2018 Publicdrwxr-xr-x 2 root root 4096 Mar 24 2018 Templatesdrwxr-xr-x 2 root root 4096 Mar 24 2018 Videos OCR的恢复 暂时先不写 OCR的导出 导出ocr文件,文件名ocrEXP ocrconfig -export ocrEXP root@testdb1[+ASM1]/root$ocrconfig -export ocrEXP root@testdb1[+ASM1]/root$ll -lrt total 480 -rw-r--r--. 1 root root 19598 Mar 24 2018 install.log.syslog -rw-r--r--. 1 root root 64378 Mar 24 2018 install.log -rw-------. 1 root root 2153 Mar 24 2018 anaconda-ks.cfg drwxr-xr-x 2 root root 4096 Mar 24 2018 Videos drwxr-xr-x 2 root root 4096 Mar 24 2018 Templates drwxr-xr-x 2 root root 4096 Mar 24 2018 Public drwxr-xr-x 2 root root 4096 Mar 24 2018 Pictures drwxr-xr-x 2 root root 4096 Mar 24 2018 Music drwxr-xr-x 2 root root 4096 Mar 24 2018 Downloads drwxr-xr-x 2 root root 4096 Mar 24 2018 Documents drwxr-xr-x 3 root root 4096 Mar 25 2018 Desktop -rw------- 1 root root 225959 May 25 09:17 OCRDUMPFILE -rw------- 1 root root 127862 May 25 09:19 ocrEXP root@testdb1[+ASM1]/root$ 当集群出现问题的时候我们可以通过Import进行导入 但是需要很小心,有可能导致集群无法启动。如果要得到一个完整集群备份,需要全部关机采用导出导入。 ocrconfig -import ocrEXP 2种备份ocr的方法 方式一、 ocrconfig -manualbackup and ocrconfig -restore 方式二、 ocrconfig -export and ocrconfig -import 注意:方式一是完全备份,方式二是不完全的。我们用方式一。注意方式一不能用方式二的导入。 表决盘备份作为OCR备份的一部分,表决盘自动备份自动恢复,表决盘全部丢失,需要人工干预。

资源下载

更多资源
Nacos

Nacos

Nacos /nɑ:kəʊs/ 是 Dynamic Naming and Configuration Service 的首字母简称,一个易于构建 AI Agent 应用的动态服务发现、配置管理和AI智能体管理平台。Nacos 致力于帮助您发现、配置和管理微服务及AI智能体应用。Nacos 提供了一组简单易用的特性集,帮助您快速实现动态服务发现、服务配置、服务元数据、流量管理。Nacos 帮助您更敏捷和容易地构建、交付和管理微服务平台。

Spring

Spring

Spring框架(Spring Framework)是由Rod Johnson于2002年提出的开源Java企业级应用框架,旨在通过使用JavaBean替代传统EJB实现方式降低企业级编程开发的复杂性。该框架基于简单性、可测试性和松耦合性设计理念,提供核心容器、应用上下文、数据访问集成等模块,支持整合Hibernate、Struts等第三方框架,其适用范围不仅限于服务器端开发,绝大多数Java应用均可从中受益。

Rocky Linux

Rocky Linux

Rocky Linux(中文名:洛基)是由Gregory Kurtzer于2020年12月发起的企业级Linux发行版,作为CentOS稳定版停止维护后与RHEL(Red Hat Enterprise Linux)完全兼容的开源替代方案,由社区拥有并管理,支持x86_64、aarch64等架构。其通过重新编译RHEL源代码提供长期稳定性,采用模块化包装和SELinux安全架构,默认包含GNOME桌面环境及XFS文件系统,支持十年生命周期更新。

Sublime Text

Sublime Text

Sublime Text具有漂亮的用户界面和强大的功能,例如代码缩略图,Python的插件,代码段等。还可自定义键绑定,菜单和工具栏。Sublime Text 的主要功能包括:拼写检查,书签,完整的 Python API , Goto 功能,即时项目切换,多选择,多窗口等等。Sublime Text 是一个跨平台的编辑器,同时支持Windows、Linux、Mac OS X等操作系统。

用户登录
用户注册