Oracle Data Guard_ 主庫添加數(shù)據(jù)文件或創(chuàng)建表空間

8.3Managing Primary Database Events That Affect the Standby Database

8.3 管理主庫能影響備庫的事件

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.

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:

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

ReferenceChange Made on Primary DatabaseAction Required on Standby Database

Add a datafile or create a tablespace

添加文件或創(chuàng)建表空間

If you did not set theSTANDBY_FILE_MANAGEMENTinitialization parameter toAUTO, you must copy the new datafile to the standby database.

如果STANDBY_FILE_MANAGEMENT初始化參數(shù)沒有設(shè)置為AUTO，那么你必須將新的數(shù)據(jù)文件拷貝到備庫

Drop or delete a tablespace or datafile

刪除表空間或數(shù)據(jù)文件

Delete datafiles from primary and standby databases after the archived redo log file containing theDROPorDELETEcommand was applied.

從主庫刪除數(shù)據(jù)文件，備庫機(jī)會(huì)應(yīng)用包含DROP或者DELETE命令的歸檔重做日志來應(yīng)用

Use transportable tablespaces

使用傳輸表空間

Move tablespaces between the primary and standby databases.

在主備庫之間移動(dòng)表空間

Rename a datafile

重命名一個(gè)數(shù)據(jù)文件

Rename the datafile on the standby database.

在備庫重命令數(shù)據(jù)文件

Add or drop redo log files

添加或刪除重做日志文件愛你

Synchronize changes on the standby database.

在備庫上同步改變

Perform a DML or DDL operation using theNOLOGGINGorUNRECOVERABLEclause

使用NOLOGGING 或者UNRECOVERABLE執(zhí)行DML或者DDL操作，

Send the datafile containing the unlogged changes to the standby database.

向備庫發(fā)送包含沒有日志記錄的文件

Change initialization parameters

改變初始化參數(shù)

Dynamically change the standby parameters or shut down the standby database and update the initialization parameter file.

動(dòng)態(tài)的改變備用的參數(shù)或者關(guān)閉備庫，，再更新初始化參數(shù)文件

8.3.1添加一個(gè)數(shù)據(jù)文件或者創(chuàng)建一個(gè)表空間

The initialization parameter,STANDBY_FILE_MANAGEMENT, enables you to control whether or not adding a datafile to the primary database is automatically propagated to the standby database, as follows:

STANDBY_FILE_MANAGEMENT初始化參數(shù)文件，能使用控制是否在添加數(shù)據(jù)文件到主庫自動(dòng)傳播到備庫，如下：

Note that if you copy an existing datafile from another database to the primary database, then you must also copy the new datafile to the standby database and re-create the standby control file, regardless of the setting ofSTANDBY_FILE_MANAGEMENTinitialization parameter.

注意，如果你從另一個(gè)數(shù)據(jù)庫已存在的數(shù)據(jù)文件拷貝到到主庫，那么你必須也要拷貝到倒庫，然后重新創(chuàng)建備用控制文件，除非你設(shè)置了STANDBY_FILE_MANAGEMENT 初始化參數(shù)。

The following sections provide examples of adding a datafile to the primary and standby databases when theSTANDBY_FILE_MANAGEMENTinitialization parameter is set toAUTOandMANUAL,respectively.

按以下提供的例子來添加一個(gè)數(shù)據(jù)文件到主庫，備庫的STANDBY_FILE_MANAGEMENT分別設(shè)置為AUTO和MANUAL。

8.3.1.1When STANDBY_FILE_MANAGEMENT Is Set to AUTO

聲明：本網(wǎng)頁內(nèi)容旨在傳播知識(shí)，若有侵權(quán)等問題請(qǐng)及時(shí)與本網(wǎng)聯(lián)系，我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com