改變?cè)诰€重做日志文件大小和數(shù)量有時(shí)是優(yōu)化數(shù)據(jù)庫。你可以在主庫添加或刪除在線重做日志組或者日志成員而不影響備庫。同樣的，你

8.3.5 Adding or Dropping Online Redo Log Files

8.3.5 添加或刪除現(xiàn)在重做日志文件

Changing the size and number of the online redo log files is sometimes done to tune the database. You can add or drop online redo log file groups or members to the primary database without affecting the standby database. Similarly, you can drop log file groups or members from the primary database without affecting your standby database. However, these changes do affect the performance of the standby database after switchover.

改變?cè)诰€重做日志文件大小和數(shù)量有時(shí)是優(yōu)化數(shù)據(jù)庫。你可以在主庫添加或刪除在線重做日志組或者日志成員而不影響備庫。同樣的，，你可以在主庫刪除日志文件組或成員而不影響你的備庫。但是，這邊變化在普通切換后會(huì)影響備庫的性能。

Caution:

注意：

Whenever you add an online redo log file to the primary database, you should add corresponding online and standby redo log files to the standby database.

無論何時(shí)，你在主庫添加在線重做日志文件，你應(yīng)該在備庫添加相應(yīng)的在線重做日志和備用重做日志文件。

For example, if the primary database has 10 online redo log files and the standby database has 2, and then you switch over to the standby database so that it functions as the new primary database, the new primary database is forced to archive more frequently than the original primary database.

例如，如果主庫有10個(gè)在線重做日志，備庫有2個(gè)，那么你切換到備庫時(shí)，變?yōu)橹鲙欤碌闹鲙毂仍瓉淼闹鲙鞎?huì)強(qiáng)制頻繁的歸檔。

Consequently, when you add or drop an online redo log file at the primary site, it is important that you synchronize the changes in the standby database by following these steps:

因此，當(dāng)你在主庫添加或者刪除在線重做日志時(shí)，按照如下步驟將這些變化同步到備庫是很重要的，

1.

If Redo Apply is running, you must cancel Redo Apply before you can change the log files.

1.如果重做應(yīng)用正在運(yùn)行，你必須在你改變?nèi)罩疚募X取消重做應(yīng)用。

2.

If the STANDBY_FILE_MANAGEMENT initialization parameter is set to AUTO, change the value to MANUAL.

如果STANDBY_FILE_MANAGEMENT初始化參數(shù)設(shè)置為AUTO,將它改變?yōu)镸ANUAL。

3.

Add or drop an online redo log file:

3.添加或刪除在線重做日志文件：

To add an online redo log file, use a SQL statement such as this:

添加在線重做日志文件，使用如下SQL語句：

SQL> ALTER DATABASE ADD LOGFILE '/disk1/Oracle/oradata/payroll/prmy3.log' SIZE 100M;

To drop an online redo log file, use a SQL statement such as this:

刪除在線重做日志文件，使用如下SQL語句：

SQL> ALTER DATABASE DROP LOGFILE '/disk1/oracle/oradata/payroll/prmy3.log';

4.

Repeat the statement you used in Step 3 on each standby database.

在每個(gè)備庫上重復(fù)操作步驟3。

5.

Restore the STANDBY_FILE_MANAGEMENT initialization parameter and the Redo Apply options to their original states.

還原STANDBY_FILE_MANAGEMENT初始化參數(shù)為AUTO，然后重做應(yīng)用還原為原來的狀態(tài)。

相關(guān)參考:

Oracle Data Guard 重要配置參數(shù)

基于同一主機(jī)配置 Oracle 11g Data Guard

探索Oracle之11g DataGuard

Oracle Data Guard （RAC+DG) 歸檔刪除策略及腳本

Oracle Data Guard 的角色轉(zhuǎn)換

Oracle Data Guard的日志FAL gap問題

Oracle 11g Data Guard Error 16143 Heartbeat failed to connect to standby 處理方法

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