Oracle 19c RAC 开启归档至ASM方法

最新推荐文章于 2024-03-03 15:21:40 发布
最新推荐文章于 2024-03-03 15:21:40 发布
阅读量1.2k 收藏 3
点赞数
文章标签： 数据库 oracle zookeeper java sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hbhe0316/article/details/122701369
版权

1.创建ASM归档日志空间

[grid@rac01 ~]$ asmcmd
ASMCMD> cd DATA
ASMCMD> cd CXMTDB 
ASMCMD> mkdir ARCH
ASMCMD> cd ARCH
ASMCMD> pwd
+DATA/CXMTDB/ARC

2.修改归档路径参数https://www.cndba.cn/hbhe0316/article/4857

[oracle@db01 backup]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Oct 3 12:21:34 2021
Version 19.12.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0

SQL> alter system set log_archive_dest_1='location=+DATA/CXMTDB/ARCH' scope=spfile sid='*';

System altered.

3.关闭所有节点数据库

https://www.cndba.cn/hbhe0316/article/4857
https://www.cndba.cn/hbhe0316/article/4857
https://www.cndba.cn/hbhe0316/article/4857 
[grid@rac01 ~]$ srvctl stop database -d cxmtdb
[grid@rac01 ~]$  /u01/app/19.3.0/grid/bin/crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.MGMT.GHCHKPT.advm
               OFFLINE OFFLINE      rac01                    STABLE
               OFFLINE OFFLINE      rac02                    STABLE
ora.chad
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.helper
               OFFLINE OFFLINE      rac01                    IDLE,STABLE
               OFFLINE OFFLINE      rac02                    IDLE,STABLE
ora.mgmt.ghchkpt.acfs
               OFFLINE OFFLINE      rac01                    STABLE
               OFFLINE OFFLINE      rac02                    STABLE
ora.net1.network
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.ons
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.proxy_advm
               OFFLINE OFFLINE      rac01                    STABLE
               OFFLINE OFFLINE      rac02                    STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        ONLINE  OFFLINE                               STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac01                    STABLE
ora.MGMT.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.MGMTLSNR
      1        OFFLINE OFFLINE                               STABLE
ora.OCR.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    Started,STABLE
      2        ONLINE  ONLINE       rac02                    Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       rac01                    STABLE
ora.cxmtdb.db
      1        OFFLINE OFFLINE                               Instance Shutdown,ST
                                                             ABLE
      2        OFFLINE OFFLINE                               Instance Shutdown,ST
                                                             ABLE
ora.qosmserver
      1        ONLINE  ONLINE       rac01                    STABLE
ora.rac01.vip
      1        ONLINE  ONLINE       rac01                    STABLE
ora.rac02.vip
      1        ONLINE  ONLINE       rac02                    STABLE
ora.rhpserver
      1        OFFLINE OFFLINE                               STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       rac01                    STABLE
--------------------------------------------------------------------------------

4.将一个节点数据库启动到mount状态

[grid@rac01 ~]$ srvctl start instance -d cxmtdb -i cxmtdb1 -o mount

5.修改数据库的归档模式并启动数据库

https://www.cndba.cn/hbhe0316/article/4857
https://www.cndba.cn/hbhe0316/article/4857 https://www.cndba.cn/hbhe0316/article/4857 
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

6.检查状态

https://www.cndba.cn/hbhe0316/article/4857 
SQL>  archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +DATA/cxmtdb/arch
Oldest online log sequence     14
Next log sequence to archive   15
Current log sequence           15

7.启动2节点数据库

https://www.cndba.cn/hbhe0316/article/4857
https://www.cndba.cn/hbhe0316/article/4857 
[grid@rac02 ~]$ srvctl start instance -d cxmtdb -i cxmtdb2

8.查看集群状态

[grid@rac02 ~]$  /u01/app/19.3.0/grid/bin/crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.MGMT.GHCHKPT.advm
               OFFLINE OFFLINE      rac01                    STABLE
               OFFLINE OFFLINE      rac02                    STABLE
ora.chad
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.helper
               OFFLINE OFFLINE      rac01                    IDLE,STABLE
               OFFLINE OFFLINE      rac02                    IDLE,STABLE
ora.mgmt.ghchkpt.acfs
               OFFLINE OFFLINE      rac01                    STABLE
               OFFLINE OFFLINE      rac02                    STABLE
ora.net1.network
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.ons
               ONLINE  ONLINE       rac01                    STABLE
               ONLINE  ONLINE       rac02                    STABLE
ora.proxy_advm
               OFFLINE OFFLINE      rac01                    STABLE
               OFFLINE OFFLINE      rac02                    STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        ONLINE  OFFLINE                               STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac01                    STABLE
ora.MGMT.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.MGMTLSNR
      1        OFFLINE OFFLINE                               STABLE
ora.OCR.dg(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    Started,STABLE
      2        ONLINE  ONLINE       rac02                    Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       rac01                    STABLE
      2        ONLINE  ONLINE       rac02                    STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       rac01                    STABLE
ora.cxmtdb.db
      1        ONLINE  ONLINE       rac01                    Open,HOME=/u01/app/o
                                                             racle/product/19.3.0
                                                             /db_1,STABLE
      2        ONLINE  ONLINE       rac02                    Open,HOME=/u01/app/o
                                                             racle/product/19.3.0
                                                             /db_1,STABLE
ora.qosmserver
      1        ONLINE  ONLINE       rac01                    STABLE
ora.rac01.vip
      1        ONLINE  ONLINE       rac01                    STABLE
ora.rac02.vip
      1        ONLINE  ONLINE       rac02                    STABLE
ora.rhpserver
      1        OFFLINE OFFLINE                               STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       rac01                    STABLE
--------------------------------------------------------------------------------

版权声明：本文为博主原创文章，未经博主允许不得转载。

Linux,oracle

hbhe0316
关注
  • 0
    点赞
  • 踩
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
RHEL 7环境下19c RAC安装之udev规则配置ASM共享存储.docx
09-23
RHEL 7环境下19c RAC安装之udev规则配置ASM共享存储 RHEL 7环境下19c RAC安装之udev规则配置ASM共享存储 RHEL 7环境下19c RAC安装之udev规则配置ASM共享存储
Oracle19c 归档模式开启与关闭
weixin_50383598的博客
10-19 2058
oracle19c的归档模式必须在容器数据库（cdb）一级开启，开启后，全部pdb启用归档模式；
oracle RAC 集群归档模式的关闭和开启（适用于11g/12g/18c/19c）
最新发布
weixin_63131036的博客
03-03 663
注意：一下操作只在一个节点上执行，本例为节点1进行的操作。2.修改cluster_database参数，你可以根据需要修改归档位置。-------实例为开启状态。二.开始数据库归档模式。
【商业信息】PNP ID注册名单 2019-05-21
热门推荐
少莫千华
05-21 4万+
原文地址 PNP id用于显示器EDID厂家名称等。 Company PNP ID Approved on Date 21ST CENTURY ENTERTAINMENT BUT 04/25/2002 2-Tel B.V TTL 03/20/1999 3Com Corporation TCM 11/29/1996 3D Pe...
oracle rac启动报错,oracle 11g RAC asm无法启动
weixin_33239386的博客
04-03 1892
oracle 11g RACasm无法启动，报错：ASMCMD-8102: no connection to ASM; command requires ASM to run环境变量如下：[grid@rac1 ~]$ cat .bash_profile# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then....
Oracle Rac 开启归档日志并修改归档路径
白昼的技术专栏
09-30 1万+
一、开启归档日志： 1、查看归档状态： SQL> archive log list; Database log mode           No Archive Mode Automatic archival           Disabled Archive destination           USE_DB_RECOVERY_FILE_DEST Oldest online...
Oracle Flex ASM与Flex集群详解
zll4859291的博客
03-28 471
数据库实例使用一个专用 ASM 实例，我们强制该 ASM 实例被停止工作来模拟故障，因此数据库实例重新连接到另一节点（在本示例中为节点 2 (rac2)）上的现有 ASM 实例。
RAC环境19cCDB开启归档
zongzizz的博客
10-26 949
RAC环境19cCDB开启归档
Oracle-RAC添加节点ASM实例没有启动问题分析
sinat_36757755的博客
02-08 954
在Oracle RAC19c的三节点集群进行第四个节点的添加，完成节点添加之后，集群状态正常但新节点的ASM实例没有启动
Oracle 10G RAC - 归档参数格式导致归档至ASM时出错的问题
07-14 1027
10G RAC在ASM中存放归档日志参数正确设置 log_archive_dest_1        string      location=+RECOVERY/JTPROD 在利用vmware workstation进行共享磁盘，当设置log_archive_dets_1为‘+RECOVERY/JTPROD/archfolder’类似格式时，归档时会导致磁盘不一致，归档文件也不能够正常使用
oracle 归档文件 asm,Oracle 更改归档文件到 ASM 磁盘
weixin_42628941的博客
04-05 312
Oracle 更改归档文件到 ASM 磁盘01, 配置磁盘路径,nide1 节点[Oracle@node1~]$ su-gridPassword:[grid@node1~]$ sqlplus/assysdbaSQL*Plus:Release11.2.0.4.0ProductiononMonMar1111:10:382019Copyright (c) 1982, 2013, Oracle. All ...
Oracle 19c RAC on Linux 7.6安装手册.docx
03-09
gns配置19c RAC，19c Linux 安装，RedHat 7.6安装Oracle 19c RAC，GNS配置SCAN。 介绍Flex ASM，介绍各个版本变化。 从12.2开始，集群分Standalone Cluster与Domain Service Cluster两种集群模式。 配置遇到问题...
CentOS7.5+Oracle 19c+RAC.pdf
09-27
熟练掌握在VMware下安装CentOS环境 熟练掌握在Linux环境下安装GRID软件 熟练掌握在Linux环境下安装Oracle19c RAC数据库 熟练掌握Linux环境下对Oracle数据库的运维操作
在Linux7.9环境下Oracle 19C RAC集群详细安装部署文档.pdf
02-20
关键字：Oracle 19C，RAC，Linux，多路径，ASM 本文档详细介绍在 Oracle Linux7.9 环境下，Oracle 19C RAC 集群的安装和部署。 RAC 集群使用 ASM 对磁盘进行管理，而共享磁盘则由 Linux 系统下部署存储管理软件来实 ...
Oracle rac+asm 原库备份与恢复
06-15
Oracle rac+asm 原库备份与恢复
OracleRac环境Rman备份与恢复
08-22
Oracle RAC环境，归档放到本地和放到ASM存储，备份规则是不同的。
Windows_2008_R2环境下的Oracle_11G_R2_RAC+ASM实验室环境安装指南V1.0.doc
05-26
Windows_2008_R2环境下的Oracle_11G_R2_RAC+ASM实验室环境安装指南V1.0.doc
在线修改oracle RAC集群scanIP地址.docx
09-23
在线修改oracle RAC集群scanIP地址，修改scan ip无需停止数据库实例，asm或crs
Oracle 11gR2 RAC + ASM on AIX-6.1安装指导手册
01-16
Oracle 11gR2 RAC + ASM on AIX-6.1安装指导手册，难得
oracle19C RAC安装
03-28
以下是Oracle 19c RAC安装的步骤： 1. 确保所有节点的操作系统和硬件都满足Oracle 19c RAC的要求。 2. 安装Oracle 19c软件包。这可以在Oracle官网上下载。 3. 在每个节点上，使用root用户安装Oracle Grid ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值