ITPub博客

    在Oracle 11g之前,物理备库（physical Standby）在应用redo的时候,是不可以打开的,只可以mount。从11g开始,在应用redo的时候,物理备库可以处于read-only模式,这就称为Active Data Guard 。通过Active ...

当试图开启备库的flashback功能时报如下错误：SQL> alter database flashback on;alter database flashback on*ERROR at line 1:ORA-01153: an incompatible media recovery is active原因：备库还在应用日志ORA-115...

从oracle MOS 上获得一个关于获取standby 库的配置信息的脚本Note 241438.1Script. to Collect Data Guard Physical Standby Diagnostic Informationset echo off set feedback off column timecol n...

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

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...

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 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...

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

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

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:...

查看dataguard 备库报警日志的时候发现有ORA-12514: TNS:listener does not currently know of service requested in connect descriptor 错误~！错误的意思是listener 不知道连接解析器中的请求服务，这里要说静态...

1、在备库检查日志缺失FAL[client]: Failed to request gap sequence GAP - thread 1 sequence 53415-53434 DBID 424533136 branch 710350416FAL[client]: All defined FAL servers have been attempted.-...

This note describes the wait events that monitor the performance of the log transport modes that were specified on the primary database with the ARCH, LGWR,SYNC, and ASYNC attributes on the LOG_ARCH...

版本：11gr2  环境：linux 实施dg的方法有很多种，这里介绍使用oracle提供的deplicate复制功能建立异机的dg的方法。对于备库安装和主库一样路径的软件和数据存放结构。配置参数文件，监听文件，启动到nomo...

不同的连接方式的导致的ORA-03113错误。C:\Documents and Settings\Administrator>set oracle_sid=testdgC:\Documents and Settings\Administrator>sqlplus /nologSQL*Plus: Release 11.1.0.6.0 - Production on 星...

版本 11g 主库 ORCL  备库 TESTDG1添加数据文件或表空间2删除数据文件或表空间3使用可传输表空间4重命名数据文件5添加或删除重做日志6使用NOLOGGING或unrecoverable子句操作ddl或dml7更改初始化参数一 添加数...

环境：数据库版本11g！主库 ORCL，备库 TESTDG-- 查看主库的最大归档序列号ORCL>select max(sequence#) from v$archived_log;MAX(SEQUENCE#)           &n...

主库：ORCL  备库：TESTDG           一般的，停止standby数据库之前，要先停用primary库，如果直接停用standby库，可能导致primary库也直接shutdown(最大...