If you do not specify the STANDBY_FILE_MANAGEMENT initialization parameter or if you set it to MANUAL, then you must manually copy the new datafile to the standby database when you add a datafile to the primary database.
如果STANDBY_FILE_MANAGEMENT没有设置或者设置为MANUAL，那么当你在主库添加数据文件时，你必须手动拷贝新的数据文件到备库
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 of STANDBY_FILE_MANAGEMENT initialization parameter.
注意，如果你从另一个数据库已存在的数据文件拷贝到到主库，那么你必须也要拷贝到倒库，然后重新创建备用控制文件，除非你设置了STANDBY_FILE_MANAGEMENT 初始化参数。
The following sections provide examples of adding a datafile to the primary and standby databases when the STANDBY_FILE_MANAGEMENTinitialization parameter is set to AUTO and MANUAL, respectively.
按以下提供的例子来添加一个数据文件到主库，备库的STANDBY_FILE_MANAGEMENT分别设置为AUTO和MANUAL。
8.3.1.1 When STANDBY_FILE_MANAGEMENT Is Set to AUTO
8.3.1.1 当STANDBY_FILE_MANAGEMENT设置为AUTO时，The following example shows the steps required to add a new datafile to the primary and standby databases when the STANDBY_FILE_MANAGEMENTinitialization parameter is set to AUTO.
以下的例子给出了主库添加一个数据文件，备库的STANDBY_FILE_MANAGEMENT为AUTO时的步骤。
Add a new tablespace to the primary database:
1.添加一个新的表空间到主库：
SQL> CREATE TABLESPACE new_ts DATAFILE '/disk1/oracle/oradata/payroll/t_db2.dbf' 2> SIZE 1m AUTOEXTEND ON MAXSIZE UNLIMITED;Archive the current online redo log file so the redo data will be transmitted to and applied on the standby database:
归档当前现在重做日志，这样，重做日志会传输到备库，并且备库会应用传输过来的日志：
SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;Verify the new datafile was added to the primary database:
3.验证新的数据文件被添加到主库：
SQL> SELECT NAME FROM V$DATAFILE; NAME ---------------------------------------------------------------------- /disk1/oracle/oradata/payroll/t_db1.dbf /disk1/oracle/oradata/payroll/t_db2.dbfVerify the new datafile was added to the standby database:
验证信的数据文件被添加到备库：
SQL> SELECT NAME FROM V$DATAFILE; NAME ---------------------------------------------------------------------- /disk1/oracle/oradata/payroll/s2t_db1.dbf /disk1/oracle/oradata/payroll/s2t_db2.dbf########################################################################################################### 我的实验：主库添加新的表空间，备库中的STANDBY_FILE_MANAGEMENT参数设置为AUTO 主库：PROD 备库：PRODSTD
1.查看备库STANDBY_FILE_MANAGEMENT参数是否为AUTO SYS@PRODSTD>show parameter STANDBY_FILE_MANAGEMENT
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ standby_file_management string AUTO
2.在主库增加一个新的表空间 SYS@PROD>create tablespace SWTICH_TBS datafile '/u01/app/oracle/oradata/PROD/Disk1/swtich_tbs01.dbf' size 10m;
Tablespace created.
---------------------------------------------------------------------------------------------------------------
Sat Mar 29 16:27:18 2014 create tablespace SWTICH_TBS datafile '/u01/app/oracle/oradata/PROD/Disk1/swtich_tbs01.dbf' size 10m Sat Mar 29 16:27:21 2014 Completed: create tablespace SWTICH_TBS datafile '/u01/app/oracle/oradata/PROD/Disk1/swtich_tbs01.dbf' size 10m
-------------------------------------------------------------------------------------------------