8.3 Managing Primary Database Events That Affect the Standby Database

To prevent possible problems, you must be aware of events on the primary database that affect a standby database and learn how to respond to them. This section describes these events and the recommended responses to these events.

In some cases, the events or changes that occur on a primary database are automatically propagated through redo data to the standby database and thus require no extra action on the standby database. In other cases, you might need to perform maintenance tasks on the standby database.

Table 8-1 indicates whether or not a change made on the primary database requires additional intervention by the database administrator (DBA) to be propagated to the standby database. It also briefly describes how to respond to these events. Detailed descriptions of the responses are described in the section references provided.

The following events are automatically administered by redo transport services and Redo Apply, and therefore require no intervention by the database administrator:

• A SQL ALTER DATABASE statement is issued with the ENABLE THREAD or DISABLE THREAD clause.

• The status of a tablespace changes (changes to read/write or read-only, placed online or taken offline).

• A datafile is added or tablespace is created when the STANDBY_FILE_MANAGEMENT initialization parameter is set to AUTO.

  
  

Table 8-1 Actions Required on a Standby Database After Changes to a Primary Database

Reference	Change Made on Primary Database	Action Required on Standby Database
Section 8.3.1	Add a datafile or create a tablespace 添加文件或创建表空间	If you did not set the STANDBY_FILE_MANAGEMENT initialization parameter to AUTO, you must copy the new datafile to the standby database. 如果STANDBY_FILE_MANAGEMENT初始化参数没有设置为AUTO，那么你必须将新的数据文件拷贝到备库
Section 8.3.2	Drop or delete a tablespace or da 免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。 相关资料更多> JDBC连接数据库跟释放连接 把历史日期改为现在的日期，时刻不变 机房收费系统之系统分析与数据库创造 为何要使用存储过程及其书写方法【原创+转载】 转：特大型ORACLE数据库优化设计方案 1069错误（由于登录失败而无法启动服务）解决方法 一个高效率的数据分页的存储过程 可以轻松应付百万数据 hibernate中list的照射 Oracle BIEE EVALUATE系列应用数据库函数 推荐阅读更多> 批改MySQL数据库的root密码(转) 每日凌晨清空sequence，让sequence每天从1开始 调用 Google 通译的地址格式 误删了表，但是在recyclebin 里找不到 ORACLE 10g 装配教程[图文] java经过配置属性文件连接Oracle数据库 db2 隔绝级别-基础知识 JDBC的事宜隔离级别 Oracle触发器中select into 报错no_data_found错误处理 利用数据库复制技术 实现数据同步更新 Oracle用户创设视图权限 VNI—2015：验证错误 的解決方法總結 oracle中imp下令详解(转) ORACLE没有自动增长的数据类型 oracle导出，导入DMP资料 定时自动操作数据库——Oracle JOB 用法总结 Adblock往广告 Access报表打印——自动分页 jdbc优化，细碎 事务处理及锁定 【数据库高效率编程 - 学习笔记 第六章】