ITPub博客

启动备库的过程中出现如下错误：ORA-00313: open failed for members of log group 4 of thread 2ORA-00312: online log 4 thread 2: '/opt/oracle/oradata/alifpre/group_4.260.761070481'ORA-27037: unable to obt...

环境：版本  11.2.0.1 1   primary :     name： rac     ip： 10.250.7.226    scan ip：10.250.7.200    使用ASM存储数据...

注：不做特别说明，则全由root执行1.linux检查安装包是否全rpm -q --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" binutils \compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ ...

涉及到的版本： 11.2.0.1 to 11.2.0.2 - Release: 11.2 to 11.2现象：After successful 11gR2 Grid Infrastructure clusterware (CRS) installation or upgrade, INS-20802 reported while running Oracle Clus...

执行到最后遇到一个错误,信息如下：[INS-20802] Oracle Cluster Verification实用程序失败。原因-插件的执行方法失败操作-参考日志或与Oracle技术支持联系。日志文件位置：/opt/rac/oraInventory/logs/installAction...

因为安装数据库，需要较大的磁盘容量，需要把一块新磁盘挂载到/opt上1 对磁盘做分区：root@rac1:/root>fdisk /dev/sdb The number of cylinders for this disk is set to 182024.There is nothing wrong with t...

ALERT.LOG for ASM Shows "WARNING: failed to online diskgroup resource ora.GI.dg (unable to communicate with CRSD/OHASD)" [ID 1060920.1]现象：If OCR is located on ASM diskgroup, following shows in ASM ...

Diskgroup resource shows status offline after restart even it is mounted in ASM instanceApplies to:Oracle Server - Enterprise Edition - Version: 11.2.0.1.0 - Release: 11.2Information in this document ...

初始化参数asm_diskgroups指定了在ASM实例启动时，或执行alter diskgroup all mount语句时，被挂载的磁盘组的名字，即当ASM实例启动的时候，会挂载这个参数指定的所有磁盘组，或当执行alter diskgroup all mount/dis...

因为删除Clusterware之后，ocr还在磁盘中，使用dd命令格式化磁盘，但是oracle提供了oracleasm工具，所以看看oracleasm deletedisk的操作具体做了什么-------------------------------------------------------------...

日志的传输以及应用可以算作是Dataguard的核心所在.在我们搭建DG的过程中,如何配置优化日志传输服务,关系到整个DG体系的性能以及可用性.而且,不同的保护模式也需要不用的参数组合.10g下,影响配置日志传输的参数...

rac 安装完成，关闭之后重启数据库遇到如下错误：oracle@rac1:/tmp>sqlplus "/as sysdba"SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 2 13:17:14 2011Copyright (c) 1982, 2009, Oracle.  All rights ...

根据每日归档的生成量，可以反过来估计每日的数据库活动性及周期性，并决定空间分配的问题！1.计算归档日志的生产量：select name,completion_time,BLOCKS * BLOCK_SIZE/1024/1024 MB from v$archived_log&...

需要关闭整个集群，遇到CRS-2529，ORA-15097 错误 ~！grid@rac1:/home/grid/Opatch>srvctl stop asm  -n rac1  -o immediate      PRCR-1014 : 无法停止资源 ora.asmPRCR-1065 : 无法停止...

当主节点安装oracleasm disk[root@rac1 dev]# /etc/init.d/oracleasm deletedisk /dev/sdc1 VOL01     Removing ASM disk "/dev/sdc1":               &nbsp...

Rman backup or Delete obsolete fails with RMAN-20020: DATABASE INCARNATION NOT SET使用rman备份或者删除旧的文件的时候报如下错误：RMAN-00571: RMAN-03015: error occurred in stored script. abcRM...

折腾很多天的rman备份的磁带库产生的问题。留作纪念，纪念拖延的心理,相互推诿在运维过程中的体现,真诚的希望忽略"备份重于一切"的后果不会发生。。RMAN-03009: failure of backup command on ch00 channel at 08/30...

生产库的备库在做rman备份到磁带的时候，总是失败。查找原因时发现：crosscheck archivelog all;delete noprompt expired archivelog all;##allocate channel for maintenance type 'sbt_tape';crosscheck backu...

1.备库启动报redo log不存在的问题：错误信息：Errors in file /home/oracle/admin/kgbdwmyj/bdump/kgbdwmyj_mrp0_11986.trc:ORA-00313: open failed for members of log group 2 of thread 1ORA-00312: online log ...

安装完成dg后，发现alert 之中的有如下错误ORA-16014: log 4 sequence# 44 not archived, no available destinationsORA-00312: online log 4 thread 1: '/opt/oracle/oradata/orclpdg/redo04.log'Wed Aug 24 22:55:...