Oracle Data Guard
文章平均质量分 82
leishifei
这个作者很懒,什么都没留下…
展开
-
Oracle Data Guard 主备库切换
<br />Oracle Data Guard 主备库切换<br /> <br />Switchover <br />一般SWITCHOVER切换都是计划中的切换,特点是在切换后,不会丢失任何的数据,而且这个过程是可逆的,整个DATA GUARD环境不会被破坏,原来DATA GUARD环境中的所有物理和逻辑STANDBY都可以继续工作。<br /> <br /> 在进行DATA GUARD的物理STANDBY切换前需要注意: <br />1)确认主库和从库间网络连接通畅; <br />2)确认没有活动的会话原创 2011-03-11 16:43:00 · 887 阅读 · 0 评论 -
Step by Step Guide on How to Create Logical Standby [ID 738643.1]
Step by Step Guide on How to Create Logical Standby [ID 738643.1] 修改时间 13-APR-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution Applies to:原创 2011-06-12 16:08:00 · 316 阅读 · 0 评论 -
Creating a Logical Standby with Minimal Production Downtime [ID 278371.1]
Creating a Logical Standby with Minimal Production Downtime [ID 278371.1] 修改时间 18-APR-2011 类型 BULLETIN 状态 PUBLISHED Checked for relevance on 18-Apr-2011.原创 2011-06-12 16:13:00 · 387 阅读 · 0 评论 -
11.2 Data Guard Physical Standby Switchover Best Practices using SQL*Plus [ID 1304939.1]
11.2 Data Guard Physical Standby Switchover Best Practices using SQL*Plus [ID 1304939.1] Modified 21-MAR-2011 Type HOWTO Status PUBLISHED <br />In this Document<br /> Goal<br /> Solution<br /> I. Prerequisites / Preparation<br /> II. Pre-原创 2011-04-27 11:00:00 · 1274 阅读 · 0 评论 -
Creating a 10gr2 Data Guard Physical Standby database with Real-Time apply [ID 343424.1]
Creating a 10gr2 Data Guard Physical Standby database with Real-Time apply [ID 343424.1] Modified 31-MAR-2011 Type BULLETIN Status PUBLISHED <br />In this Document<br /> Purpose<br /> Scope and Application<br /> Creating a 10gr2 Data Guard Physi原创 2011-04-27 11:59:00 · 355 阅读 · 0 评论 -
10.2 Data Guard Physical Standby Switchover [ID 751600.1]
10.2 Data Guard Physical Standby Switchover [ID 751600.1] Modified 18-JAN-2011 Type REFERENCE Status PUBLISHED <br />In this Document<br /> Purpose<br /> 10.2 Data Guard Physical Standby Switchover<br /> 1.0 Prerequisites / Preparation<br />原创 2011-04-27 22:11:00 · 798 阅读 · 0 评论 -
Script to Collect Data Guard Logical Standby Diagnostic Information [ID 241512.1]
Script to Collect Data Guard Logical Standby Diagnostic Information [ID 241512.1] Modified 21-APR-2011 Type SCRIPT Status PUBLISHED Overview--------This script is intended to provide an easy method to provide informationnecessary to trouble原创 2011-04-27 21:54:00 · 417 阅读 · 0 评论 -
Creating a Data Guard Database with RMAN (Recovery Manager) using Duplicate Command [ID 183570.1]
Creating a Data Guard Database with RMAN (Recovery Manager) using Duplicate Command [ID 183570.1] Modified 19-OCT-2010 Type BULLETIN Status PUBLISHED "Checked for relevance on 21-Dec-2008"PURPOSE-------To understand and use the 9i Data Gu原创 2011-04-27 22:53:00 · 408 阅读 · 0 评论 -
Script to Collect Data Guard Primary Site Diagnostic Information [ID 241374.1]
Script to Collect Data Guard Primary Site Diagnostic Information [ID 241374.1] Modified 20-APR-2011 Type SCRIPT Status PUBLISHED Overview--------This script is intended to provide an easy method to provide informationnecessary to troublesho原创 2011-04-27 21:49:00 · 345 阅读 · 0 评论 -
Script to Collect Data Guard Physical Standby Diagnostic Information [ID 241438.1]
Script to Collect Data Guard Physical Standby Diagnostic Information [ID 241438.1]Modified 20-APR-2011 Type SCRIPT Status PUBLISHEDScript to Collect Data Guard Physical Standby Diagnostic Information [ID 241438.1] Modified 20-APR-2011 Type SCRI原创 2011-04-27 21:52:00 · 307 阅读 · 0 评论 -
Step By Step Guide To Create Physical Standby Database Using RMAN [ID 469493.1]
<br /> <br /> <br />Step By Step Guide To Create Physical Standby Database Using RMAN [ID 469493.1] Modified 12-DEC-2010 Type HOWTO Status MODERATED <br />In this Document<br /> Goal<br /> Solution<br /><br />Platforms: 1-914CU; <br /> <br />This原创 2011-04-27 22:49:00 · 520 阅读 · 0 评论 -
Step by Step Guide on Creating Physical Standby Using RMAN DUPLICATE...FROM ACTIVE DATABASE Without Shutting down the Primary an
Step by Step Guide on Creating Physical Standby Using RMAN DUPLICATE...FROM ACTIVE DATABASE Without Shutting down the Primary and using Primary Active Database Files [ID 1075908.1] 修改时间 17-FEB-2011 类型 HOWTO 状态 PUBLISHED <br />In this Document<br />原创 2011-04-27 10:47:00 · 373 阅读 · 0 评论 -
Creating Physical Standby using RMAN Duplicate Without Shutting down The Primary [ID 789370.1]
Creating Physical Standby using RMAN Duplicate Without Shutting down The Primary [ID 789370.1] Modified 08-MAR-2011 Type HOWTO Status MODERATED In this Do原创 2011-06-08 15:26:00 · 388 阅读 · 0 评论 -
RAC + DG 搭建归档日志缺失遭遇记
<br />RAC + DG 搭建归档日志缺失遭遇记<br /><br />SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;<br /><br />PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS<br />--------- ------------ ---------- ---------- --原创 2011-05-31 21:15:00 · 630 阅读 · 0 评论 -
RMAN backups in Max Performance/Max Availability Data Guard Environment [ID 331924.1]
<br />RMAN backups in Max Performance/Max Availability Data Guard Environment [ID 331924.1]<br /> <br />--------------------------------------------------------------------------------<br /> <br /> Modified 28-DEC-2010 Type BULLETIN Status PUBLISHE原创 2011-04-13 09:13:00 · 406 阅读 · 0 评论 -
Oracle 10g RAC + DG 日志应用观察闲谈
<br />运行环境:<br />AIX 5300-08<br />Oracle 单实例Data Guard<br />Oracle 10g 2节点RAC <br /> <br />备库查看日志应用情况:<br /> <br />SQL> select sequence#,applied from v$archived_log order by sequence#;<br /> SEQUENCE# APP<br />---------- ---<br /> 74 YES<br />原创 2011-03-12 12:10:00 · 505 阅读 · 0 评论 -
ORA-16009: remote archive log destination must be a STANDBY database
<br />ORA-16009:remote archive log destination must be a STANDBY databaseCause:The database associated with the archive log destination service name is other than the required STANDBY type database. Remote archival of redo log files is not allowed to non-S原创 2011-03-14 10:59:00 · 676 阅读 · 0 评论 -
Oracle 11gR2 物理备库的搭建及切换
<br /><br />在同一台机器上搭建物理备用数据库的步骤<br />实验环境:linux环境 Oracle 11.2.0.1<br />主库:orcl<br />备库:stby<br /><br />1 检查监听是否启动<br />2 配置主备数据库的初始化参数文件<br />sqlplus "/as sysdba"<br />create pfile='/home/oracle/initprim.ora' from spfile;<br />cp /home/oracle/initprim.ora原创 2011-04-08 10:17:00 · 922 阅读 · 0 评论 -
Oracle 11g 11.2.0.1 环境逻辑备库搭建
<br /> <br />首先创建物理备库<br />参考:http://blog.csdn.net/leishifei/archive/2011/04/08/6308758.aspx<br /> <br />创建物理备库后,最好创建各自的spfile<br /><br />物理备库上停止redo应用:<br />alter database recover managed STANDBY database cancel;<br />主库上生成logminer会发生几次切换日志报错忽略<br />execu原创 2011-04-08 10:26:00 · 607 阅读 · 0 评论 -
Oracle Switchover RAC数据库提示ORA-600(kcctrdf_2)错误解决方案
<br />Oracle 10g RAC环境数据库执行ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL DATABASE操作,<br />试图将当前的物理STANDBY数据库切换为PRIMARY数据库时,出现下面的错误:<br />SQL> CONN SYS/TEST@TESTRAC_STANDBY AS SYSDBA<br />已连接。<br />SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;<br />SWITC原创 2011-04-07 21:47:00 · 477 阅读 · 0 评论 -
Oracle 10g Data Guard 环境缺少log_archive_config 参数导致归档路径被禁用
<br /><br />Oracle 10g Data Guard的一个主要特点就是引入了log_archive_config参数,如果缺少这个参数,可能会导致归档路径被禁用。<br /> <br />实验过程:<br />当前是一个已经配置好的Data Guard,为了模拟错误,先将这个参数设置为空:<br />SQL> alter system set log_archive_config = '';<br />System altered.<br />SQL> alter system switch原创 2011-04-09 09:03:00 · 525 阅读 · 0 评论 -
Duplicate standby 与 RMAN-05501 错误
在Oracle9i中,当使用RMAN进行DataGuard创建过程时如果在RMAN恢复时不指定 nofilenamecheck 参数则在数据文件相同文件名恢复时会出现RMAN-05501错误错误信息可能类似如下:sql statement: alter database mount standby databaseRMAN-00571: ============================转载 2011-06-03 15:33:00 · 330 阅读 · 0 评论 -
Creating Physical Standby using RMAN Duplicate Without Shutting down The Primary [ID 789370.1]
Creating Physical Standby using RMAN Duplicate Without Shutting down The Primary [ID 789370.1] Modified 08-MAR-2011 Type HOWTO Status MODERATED In this Do原创 2011-06-03 19:43:00 · 233 阅读 · 0 评论 -
How to transport a Tablespace to Databases in a Physical Standby Configuration [ID 467752.1]
How to transport a Tablespace to Databases in a Physical Standby Configuration [ID 467752.1] Modified 28-NOV-2007 Type HOWTO Status PUBLISHED In this Document Goal Solution References Applies to: Oracle Server - Enterprise Edition - Version: 10.原创 2011-06-01 20:56:00 · 298 阅读 · 0 评论 -
Oracle 11g Data Guard 使用duplicate from active database 创建 standby database 实验
<br /><br />Oracle 11g Data Guard 使用duplicate from active database 创建 standby database 实验<br /> <br />使用duplicate from active database 来搭建standby database,主库的停机时间很少,只需要重启一下,使参数生效。也可以用这种方法进行DB迁移。DG搭建好,然后把备库激活就可以了,这样整个迁移中宕机时间也比较短。<br /><br />Oracle 11g的physi原创 2011-04-12 16:02:00 · 700 阅读 · 0 评论 -
Oracle Data Guard 主库 归档文件 删除策略 配置
<br />Oracle Data Guard 主库 归档文件 删除策略 配置<br /><br /><br />对于Oracle Data Guard 的Maximum Availability和 Maximum Performance 两种模式下的主库归档文件的删除,必须是在归档文件在备库应用以后才可以删除。<br /><br />对于Maximum Protection 模式,这种模式的日志是同时写到主库和备库的,所以这种模式下的主库删除归档,没有限制,可以直接删除。<br /><br />那么在Ma原创 2011-04-13 09:31:00 · 432 阅读 · 0 评论 -
Data Guard Gap Detection and Resolution [ID 232649.1]
Data Guard Gap Detection and Resolution [ID 232649.1] Modified 20-OCT-2010 Type REFERENCE Status PUBLISHED Overview:===============An archive gap is a range of missing archived redo logs created whenever the standby system is unable to re原创 2011-04-27 11:56:00 · 334 阅读 · 0 评论