Oracle RAC开启归档 1.禁用集群实例 [oracle@racnode1 ~]$ sqlplus / as sysdba SQL> alter system set cluster_database=false scope=spfile sid='racdb1'; System altered. 2.关闭集群数据库…
Oracle11g RAC迁移到RAC 一、环境 1.RAC环境(源库) HostName Public IP Private IP VIP Scan IP DB Name Rac01 192.168.1.21 10.0.0.21 192.168.1.23 192.168.1.25 mydb Rac02 192.168.1.22 10.0.0.22…
Oracle11g RAC安装数据库补丁 一、RAC环境 OS Version DB Version Grid Version Gi Home Oracle Home RHEL7.8 112.0.4 112.0.4 /u01/app/11.2.0/grid /u01/app/oracle/product/11.2.0/db_1 二、准备介质 202…
RMAN恢复识别不到ASM磁盘 一、故障现象 [oracle@racnode01 ~]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jan 7 20:56:31 2022 Copyright (c) 1982, 2011, Oracle and/or…
set linesize 200 pagesize 200 col path for a20 col name for a15 col failgroup for a15 select group_number,disk_number,failgroup,name,path,state,mount_status,total_mb,free_mb,o…
RMAN set newname脚本: windows: set linesize 500 set pagesize 500 col file_name for a60 select 'set newname for datafile '||file_id||' to ''D:\Ora11gData…
从ASM磁盘Copy归档日志至文件系统: SQL> set linesize 200 pagesize 200 SQL> col name for a80 SQL> select 'copy archivelog '''||name||''' to '…
Oracle11g RAC DBCA创建数据库时候报错 一、现象 PRCR-1079 : Failed to start resource ora.mydb.db CRS-5017: The resource action "ora.mydb.db start" encountered the following error: …
Asmdiskgroup cannot be discovered 一、现象 二、解决方法 一、检查磁盘权限 [root@racnode01 ~]# ll /dev/asm* brw-rw---- 1 grid asmadmin 8, 16 Jan 5 16:43 /dev/asm-diskb brw-rw---- 1 grid asmadmin …
Oracle11g RAC卸载grid报错: [root@racnode01 ~]# /opt/app/11.2.0/grid/crs/install/rootcrs.pl -deconfig -force Can't locate Env.pm in @INC (@INC contains: /usr/local/lib64/perl5…