ORACLE_DATAGUARD
Perry705
OCM
展开
-
DataGuard参数配置详解
DB_NAME 只需注意DataGuard的主备各节点instance使用相同的db_name即可。推荐与service_name一致。Primary Site Standby Site*.DB_NAME='DB'*.DB_NAME='DB’DB_UNIQUE_NAME Primary与Standby端数据转载 2014-09-30 22:45:33 · 464 阅读 · 0 评论 -
Flashing Back a Failed Primary Database into a Physical Standby Database(12.1)
Oracle Data Guard Concepts and Administration>Oracle Data Guard Scenarios>Converting a Failed Primary Into a Standby Database Using Flashback Database>15.2.1 Flashing Back a Fa转载 2016-12-13 19:38:02 · 426 阅读 · 0 评论 -
DG同步测试脚本
sqlplus / as sysdba drop table t1;create table t1(id number,check_for_dg varchar2(30));declarei number;begindelete t1 where 1=1;insert into t1 values(1,to_char(sysdate,'YYYY-MM-DD HH24:M原创 2016-09-05 13:29:59 · 907 阅读 · 0 评论 -
Creating a Standby using RMAN Duplicate (RAC or Non-RAC) (Doc ID 1617946.1)
Creating a Standby using RMAN Duplicate (RAC or Non-RAC) (Doc ID 1617946.1)To BottomIn this DocumentGoal Solution转载 2016-08-30 11:58:08 · 1556 阅读 · 0 评论 -
Adding a standby database to a dataguard configuration fails with ORA-1017 (Doc ID 1072022.1)
Adding a standby database to a dataguard configuration fails with ORA-1017 (Doc ID 1072022.1)To BottomIn this DocumentSymptoms转载 2016-08-07 20:02:59 · 763 阅读 · 2 评论 -
Views Relevant to Oracle Data Guard
This chapter describes the views that are especially useful when monitoring a Data Guard environment. The view described in this chapter are a subset of the views that are available for Oracle databas原创 2016-04-19 17:28:50 · 253 阅读 · 0 评论 -
Physical Standby Switchover_status Showing Not Allowed. (Doc ID 1392763.1)
Physical Standby Switchover_status Showing Not Allowed. (Doc ID 1392763.1)In this Document Symptoms Cause SolutionThis docum原创 2016-04-17 19:40:40 · 1644 阅读 · 0 评论 -
Duplication with Oracle Managed Files(OMF)
Duplication with Oracle Managed FilesIf the source database files are in the Oracle Managed Files (OMF) format, then you cannot use the DB_FILE_NAME_CONVERT andLOG_FILE_NAME_CONVERT initializati原创 2016-04-26 14:16:04 · 430 阅读 · 0 评论 -
standby报错:PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 16009.
standby报错:Mon Apr 25 12:18:26 2016PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 16009.Mon Apr 25 12:19:26 2016PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. E原创 2016-04-25 13:30:40 · 7096 阅读 · 0 评论 -
11gR2 DataGuard参数文件(pfile/spfile)设置模板
主机:orcl.__db_cache_size=771751936orcl.__java_pool_size=16777216orcl.__large_pool_size=16777216orcl.__oracle_base='/u01/app/oracle'orcl.__pga_aggregate_target=1308622848orcl.__sga_target=20原创 2016-01-15 08:53:44 · 882 阅读 · 0 评论 -
11gR2 DataGuard standby开启实时查询(Real-time query)备份standby恢复报错:ORA-01194 ORA-01110
1.备份standy,确认archivelog同步是没有问题的2.使用rman备份恢复standby,打开报错3.手动在主机切换redo将切换后的3组归档日志拷贝到备机4.手动指定归档日志前滚后,数据库可以open原创 2016-01-14 16:45:09 · 1875 阅读 · 0 评论 -
查看DATAGUARD相关命令
//启用SQL> alter database recover managed standby database disconnect from session;Database altered.//关闭SQL> alter database recover managed standby database cancel;Database altered原创 2014-09-30 22:45:41 · 1473 阅读 · 0 评论 -
ORACLE 11g DataGuard切换
1.在primary和standby查看状态:primary:SQL> select switchover_status,database_role from v$database;SWITCHOVER_STATUS DATABASE_ROLE-------------------- ----------------TO STANDBY PRI原创 2015-01-14 09:04:40 · 473 阅读 · 0 评论 -
LOG_ARCHIVE_DEST_n Parameter Attributes
LOG_ARCHIVE_DEST_n Parameter AttributesThis chapter provides reference information for the attributes of the LOG_ARCHIVE_DEST_n initialization parameter, where n is an integer between 1 and 31原创 2015-01-07 13:22:30 · 658 阅读 · 0 评论 -
Alter database mount;和Alter database mount standby database;区别
MOUNT ClauseUse the MOUNT clause to mount the database. Do not use this clause when the database is already mounted.MOUNT STANDBY DATABASE You can specify MOUNT STANDBY DATABASE to mount a原创 2014-11-18 10:42:34 · 4313 阅读 · 0 评论 -
Oracle Data Guard 理论知识
oracle数据库archiveserversqldelayRAC, Data Gurad, Stream 是Oracle 高可用性体系中的三种工具,每个工具即可以独立应用,也可以相互配合。 他们各自的侧重点不同,适用场景也不同。RAC 它的强项在于解决单点故障和负载均衡,因此RAC 方案常用于7*24 的核心系统,但RAC 方案中的数据只有一份,尽管可以通过RAID 等机制可以避转载 2014-09-30 22:43:48 · 339 阅读 · 0 评论 -
DataGuard日志无法同步,报错:CORRUPTION DETECTED: In redo blocks starting at block ......
DataGuard日志无法同步,报错如下图:After further investigation, it would seem that the Cisco switches being used between ourprimary and standby sites had “SQL*Net inspection enabled” by default (deep packet i...原创 2019-06-13 14:42:52 · 821 阅读 · 0 评论