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 免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。 相关资料更多> mongodb的一个恶心有关问题 推行夏令时的国家，数据的日期操作需要注意了 DATE TO NUMBER,NUMBER TO DATE JPA+mysql+servlet兑现的连接操作数据库的小例子 自各儿写的一个数据库模板类，可以直接操作封装好的数据对象类 mongoDB WindowsPHP联接安装测试(二) 转载 ORA-02049: 超时: 分布式事务处理等候锁 PHP和MySql数据库，怎么获取每个分类的记录的总数 oracle 11g 没scott用户下emp的创建方法 装载JDBC驱动的三种方式 推荐阅读更多> nitrogen 配备启动时自动启动mnesia数据库 JDBC容易步骤 Oracle强杀进程，解决表锁死等有关问题 DBUtil的一个操作种 联接oracle数据库的一个报错 为啥人们对mongo感兴趣 MySQL入门学习（四） Ubuntu 装配gcc/g++/gdb/make 等基本编程工具 Oracle联接查询，子查询(相关子查询，嵌套子查询) JDBC兑现记录的更新或者删除 全备份、增量备份、区别备份和永久增量备份 tnsping通却连接不下数据库 oracle札记（二） 过滤与排序 DB2常见异常及解决方法 怎么加快查询速度 JDBC　事宜　和　savePoint 禅聊系统的一些统计语句 经过JDBC获得表结构信息 怎么直接阅读Oracle中的trace文件(原创) 数据库设计14个技能