ITPub博客

standby 库不支持expdp，可以使用exp代替oracle@rac3:/home/oracle>expdp yang/yang directory=dump dumpfile=yang.dmp tables=yang                    &nb...

oracle@rac1:/home/oracle>rman target sys/yang402@rac auxiliary sys/yang402@yangdbRecovery Manager: Release 11.2.0.1.0 - Production on Thu Sep 15 15:46:58 2011Copyright (c) 1982, 2009, Oracle and/or it...

oracle@rac3:/home/oracle>rman target sys/yang402@yangdb auxiliary sys/yang402@yangdb2Recovery Manager: Release 11.2.0.1.0 - Production on Thu Sep 15 18:37:27 2011Copyright (c) 1982, 2009, Oracle and/o...

上一篇简单介绍了lsnrctl reload的原理！这篇文章实验一下给数据库增加静态监听，reload 监听并查看监听器的日志：oracle@rac1:/opt/oracle/11.2.0/yangdb/network/admin>lsnrctl statusLSNRCTL for Linux: Version ...

oracle 提供了lsnrctl reload 命令，在下面两种情况1 修改listener.ora2 修改sqlnet.ora之后又不想停止监听，可以考虑lsnrctl reload命令！reload命令会重新读取listener.ora的内容，这个命令让用户不停止监听器的情...

Starting backup at 11-SEP-11RMAN-03009: failure of backup command on c1 channel at 09/11/2011 17:48:09ORA-19505: failed to identify file "/opt/rac/oracle/11.2.0/db/dbs/orapwrac1"ORA-27037: unable ...

ORA-16032 Attempting to Transfer Archive Logs to Standby DatabaseProblem Description-------------------You are attempting to setup a standby database and automate theprocess of transferring archive lo...

ORACLE Instance rac1 - Archival ErrorORA-16038: log 2 sequence# 98 cannot be archivedORA-19502: write error on file "", block number  (block size=)ORA-00312: online log 2 thread 1: '+DATA1/rac/on...

作为一个理工科毕业的人，我发现，理工科专业所训练出来的理工科思维，在以下四个方面，反而形成了阻碍而不是促进作用，从而影响了人生一些重要的规划步骤，现列如下，望与理工科人士共勉： 1、大部分理工科行...

在Oracle DATAGUARD实验中必须要用到静态监听，否则很严重(例子前面创建dg的过程中有遇到)静态监听指实例启动时读取listener.ora配置文件，将实例和服务注册到监听程序。无论何时启动一个数据库，默认都有两条信息注...

 Duplicate From Active Database Errors : Ora-17627: Ora-12154: Tns:Could Not Resolve The C [ID 1144273.1]ORA-17629: Cannot connect to the remote database serverORA-17627: ORA-12154: TNS:could not...

oracle@rac3:/opt/oracle/11.2.0/yangdb/dbs>rman target sys/yang402@rac  auxiliary /Starting Duplicate Db at 08-SEP-11released channel: c1released channel: s1released channel: s2RMAN-00571: =======...

启动备库的过程中出现如下错误：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 ...