| 共 47 篇文章 |
|
Data Guard 转载 ⑿ .Standby之选择数据保护模式本文作者：junsansi 转载网址：http://www.5ienet.com/index.shtml 第四部分Standby之选择数据保护模式 2007.12.18 关于有三模同学的光荣事迹大家应该都听说了，有不认识的请自觉重温"名词先混个脸熟"篇，下面让三思就有三模同学的高超本领为大家做个展示。3、设置新的数据保... 阅26 转0 评0 公众公开 15-09-12 14:43 |
主库需要注意事项A 如果switchover_status为TO_STANDBY说明可以转换直接转换alter database commit to switchover to physical standby;B 如果switchover_status为SESSIONS ACTIVE 则关闭会话SQL>alter database commit to switchover to physical standby with session shutdown;SQL> SQL> SQL> SQL> SQL> SQL> shutdown... 阅452 转5 评0 公众公开 15-07-11 21:15 |
阅365 转1 评0 公众公开 15-07-01 16:33 |
-------------------------------------------------------------------------------- /u01/app/oracle/oradata/czmmiao/system01.dbf /u01/app/oracle/oradata/czmmiao/undotbs01.dbf /u01/app/oracle/oradata/czmmiao/sysaux01.dbf /u01/app/oracle/oradata/czmmiao/users01.dbf /u01/app/oracle/oradata/czmmiao/example.dbf /u01/app/oracl... 阅45 转0 评0 公众公开 15-07-01 16:29 |
7 – Oracle 11g onward, see Support Note 414043.110 – Oracle 10g onward, see Support Note 414043.111 – Oracle 10g onward8, 12 – Oracle 11g onward13.7 – from Oracle 11g onward. Replication can only occur from a 32-bit primary to a 64-bit standby, once a role transition has promoted the 64-bit system to the primary... 阅137 转0 评0 公众公开 15-06-04 13:23 |
Oracle 11g Dataguard 物理备库配置(二)之Active Dataguard测试。Oracle 11g Dataguard 物理备库配置系列文档。SQL> select open_mode,database_role,db_unique_name from v$database;SQL> alter database recover managed standby database cancel;SQL> alter database open;SQL> alter database recover managed standby databas... 阅634 转0 评0 公众公开 15-06-04 13:12 |
TNAME TABTYPE CLUSTERID ------------------------------ ----------------- BONUS TABLE DEPT TABLE EMP TABLE EMP001 TABLE EMP004 TABLE SALGRADE ... 阅26 转0 评0 公众公开 15-05-15 00:11 |
4. 在主库修改保护模式为maximize availability，并打开数据库SQL> alter database set standby database to maximize availability;PROTECTION_MODE PROTECTION_LEVEL-------------------- --------------------MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY6. 查看备库保护模式SQL> select protection_mode,protection_level from v... 阅463 转1 评0 公众公开 15-05-15 00:03 |
FAL_CLIENT和FAL_SERVER是配置dataguard用到的两个参数,FAL指获取归档日志(Fetch Archived Log)FAL_SERVER指定一个Oracle Net service name,standby数据库使用这个参数连接到FAL server,这个参数适用于standby站点。FAL_CLIENT指定一个FAL客户端的名字，以便FAL Server可以引用standby库，这也是一个TNS name，primary库必须适当配置此TNS name... 阅73 转0 评0 公众公开 15-04-30 09:28 |
"Starting with 11gR1, Oracle Data Guard asynchronous redo transport will read redo directly from the in-memory log buffer, provided that the requested redo blocks still reside in the log buffer, and have not been reused for subsequent redo generation. If the redo blocks are not available in the log buffer, Data G... 阅79 转0 评0 公众公开 15-04-29 14:55 |
