Oracle DataGuard
关注
分享
扫一扫
文章平均质量分 84
冰释镜湖
DBA at Huawei since 2015.6, Focus on Oracle/MySQL/Redis/MongoDB/PaaS/Kubernetes/Docker/RDS;
Senior Oracle DBA at Oracle until 2015.6
展开
-
DataGuard 之物理STANDBY 的监控与管理
1、监控恢复进度1.1、查看进程的活动状态SELECT PROCESS,CLIENT_PROCESS,SEQUENCE#,STATUS FROM V$MANAGED_STANDBY;PROCESS CLIENT_P SEQUENCE# STATUS--------- -------- ---------- ------------ARCH ARCH原创 2013-02-04 23:38:45 · 3881 阅读 · 0 评论 -
Data Guard Gap Detection and Resolution (Doc ID 232649.1)
Overview:===============An archive gap is a range of missing archived redo logs created whenever the standby system is unable to receive the next archived redo log generated by the primary databa原创 2014-04-08 16:32:22 · 3228 阅读 · 0 评论 -
Script to Collect Data Guard Physical and Active Standby Diagnostic Info for 10g and above(+RAC)
-- NAME: new_dg_psby_diag.sql (Run from sqlplus on PHYSICAL STANDBY, ACTIVE STANDBY as SYS)-- ------------------------------------------------------------------------ -- Copyright 2002, Oracle Co原创 2013-12-19 16:27:38 · 3179 阅读 · 0 评论 -
Script to Collect Data Guard Primary Site Diagnostic Information for Version 10g and above(+RAC)
-- NAME: new_dg_prim_diag.sql (Run from sqlplus on PRIMARY with a LOGICAL or PHYSICAL STANDBY as SYS)-- ------------------------------------------------------------------------ -- Copyright 2002原创 2013-12-19 15:56:28 · 2744 阅读 · 0 评论 -
Step By Step Guide To Create Physical Standby Database Using RMAN Backup and Restore (Doc ID 469493.
In this Document Goal Solution ReferencesApplies to: Oracle Database - Enterprise Edition - Version 9.0.1.0 to 11.2.0.3 [Release 9.0.1 to 11.2转载 2013-12-19 10:07:28 · 2294 阅读 · 0 评论 -
Step by Step Guide on Creating Physical Standby Using RMAN DUPLICATE...FROM ACTIVE DATABASE (Doc ID
In this Document Goal Solution ReferencesCreated from SR 3-1430829871[This section is not visible to customers.]Applies to:转载 2013-12-19 10:05:30 · 3441 阅读 · 0 评论 -
Step-By-Step Guide To Create Physical Standby On Normal File System For ASM Primary using RMAN
In this Document Purpose Scope Details Overview Steps to accomplish Method 1 ReferencesApplies t原创 2013-12-19 10:25:09 · 2613 阅读 · 0 评论 -
Flashing Back a Failed Primary Database into a Physical Standby Database
The following steps assume that a failover has been performed to aphysical standby database and that Flashback Database was enabled on the oldprimary database at the time of the failover. This proce原创 2013-06-30 12:17:44 · 1632 阅读 · 0 评论 -
Oracle 11g Data Guard Role Transitions: Failover
Role TransitionsInvolving Physical Standby Databases A database operates in one of the following mutuallyexclusive roles:primary orstandby. Data Guard enables you to change theseroles dynamica原创 2013-06-20 23:23:03 · 3028 阅读 · 0 评论 -
Oracle 11g Active Data Guard step by step: How to create a Physical Standby Database using RMAN
DatabaseIPDB_UNIQUE_NAMEOracle Net Service Name Primary192.168.8.180prodProdStandby192.168.8.190standbystandby原创 2013-06-17 10:15:27 · 3459 阅读 · 0 评论 -
Oracle 11g Data Guard Role Transitions: Switchover
Role Transitions Involving Physical Standby Databases A database operates in one of the following mutuallyexclusive roles:primary orstandby. Data Guard enables you to change theseroles dynamic原创 2013-06-19 00:33:53 · 2182 阅读 · 0 评论 -
Oracle 11g Data Guard: How to Change Data Guard Protection Modes
How to Change Data Protection Mode ofa Primary Database Step 1 Select a dataprotection mode that meets your availability, performance, and data protectionrequirements. Maximum Availability原创 2013-06-18 09:04:05 · 3217 阅读 · 0 评论 -
Oracle 11g Data Guard: How to start and stop Redo Apply
1 Starting Redo Apply To start apply services on a physical standby database, ensure thephysical standby database is started and mounted and then start Redo Applyusing the SQL ALTER DATABASE REC原创 2013-06-17 21:11:17 · 3594 阅读 · 0 评论 -
Oracle 11.2.0.3.0 Active Data Guard 遇 ORA-10458、ORA-01152、ORA-01110 错误
今天第一次配 Oracle 11g R2 Active Data Guard，在用 RMAN 创建好 physical standby database 后，尝试将 standby 以 read only 方式打开时遇如下错误：SQL> alter database open read only;alter database open read only*ERROR a原创 2013-06-12 10:05:10 · 6450 阅读 · 0 评论 -
Oracle 10g 单实例数据库Data Guard 之 Logical Standby 配置详解（根据官方文档总结）
-----------Step-by-Step Instructions for Creating a Logical Standby Database-----------1.Create a Physical Standby Database （EXSITING NOW）2.Stop Redo Apply on the Physical Standby Database原创 2013-02-05 22:28:50 · 1568 阅读 · 0 评论 -
Data Guard——使用 RMAN 创建单实例物理(physical) standby 数据库
Primary Database：192.168.8.251 centos10g.oracle.com centos10gStandby Database：192.168.8.252 centos10g2.oracle.com centos10g21、在 primary database 上启用 force logging[oracle@centos原创 2013-02-24 11:07:02 · 1672 阅读 · 2 评论 -
Oracle 10g 单实例数据库 Data Guard 之 Physical Standby 配置详解（根据官方文档总结）
--------Creating Physical Standby Database---------------------------------------Settings for the primary database--------------------------------1、Enable Forced LoggingALTER DATABASE FORCE原创 2013-02-05 22:23:10 · 1678 阅读 · 0 评论 -
How To Check Whether Physical Standby is in Sync with the Primary or Not?
The following tips will help you in monitoring sync between primary and standby databases.How To Check Whether Physical Standby is in Sync with the Primary or Not?1. Check for GAP on standby2. C转载 2014-04-08 16:36:32 · 1938 阅读 · 0 评论