STANDBY_FILE_MANAGEMENT=auto时，主库执行增删数据文件的动作，在备库会出来。如果STANDBY_FILE_MANAGEMENT=manual，那么需要在备库手工添加或删除。
如果文件系统是raw devices，那么STANDBY_FILE_MANAGEMENT参数仍然生效，不过还是需要手工的干预。
以下内容参考：
11g Document b28294/manage_ps.htm#i1022518
备忘
[@more@]1 修改异构物理备库参数：
SQL> show parameter standby_file_man
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string AUTO
SQL>
SQL> alter system set standby_file_management=manual scope=both;
System altered.
SQL>
SQL> show parameter standby_file_man
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string MANUAL
SQL>
2 主库：
SQL>
SQL> alter tablespace test_stdby
2 add datafile 'D:APPADMINISTRATORPRIMARYORADATAPRIMARYTEST_STDBY02.DBF' size 10m;
表空间已更改。
SQL> select bytes/1024/1024 MB, name from v$datafile;
MB NAME
---------- ----------------------------------------------------------------
700 D:APPADMINISTRATORPRIMARYORADATAPRIMARYSYSTEM01.DBF
822.625 D:APPADMINISTRATORPRIMARYORADATAPRIMARYSYSAUX01.DBF
230 D:APPADMINISTRATORPRIMARYORADATAPRIMARYUNDOTBS01.DBF
5 D:APPADMINISTRATORPRIMARYORADATAPRIMARYUSERS01.DBF
100 D:APPADMINISTRATORPRIMARYORADATAPRIMARYEXAMPLE01.DBF
10 D:APPADMINISTRATORPRIMARYORADATAPRIMARYTEST_STDBY01.DBF
10 D:APPADMINISTRATORPRIMARYORADATAPRIMARYTEST_STDBY02.DBF
已选择7行。
SQL>
3 再回到备库，察看参数摄制的影响
SQL> select bytes/1024/1024 MB, name from v$datafile;
MB NAME
---------- ----------------------------------------------------------------------------------------------------
700 /u01/app/oradata/standby/SYSTEM01.DBF
822.625 /u01/app/oradata/standby/SYSAUX01.DBF
230 /u01/app/oradata/standby/UNDOTBS01.DBF
5 /u01/app/oradata/standby/USERS01.DBF
100 /u01/app/oradata/standby/EXAMPLE01.DBF
10 /u01/app/oradata/standby/TEST_STDBY01.DBF
6 rows selected.
SQL>
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oradata/standby/archive
Oldest online log sequence 142
Next log sequence to archive 0
Current log sequence 143
SQL>
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL>
SQL> select bytes/1024/1024 MB, name from v$datafile;
MB NAME
---------- ----------------------------------------------------------------------------------------------------
700 /u01/app/oradata/standby/SYSTEM01.DBF
822.625 /u01/app/oradata/standby/SYSAUX01.DBF
230 /u01/app/oradata/standby/UNDOTBS01.DBF
5 /u01/app/oradata/standby/USERS01.DBF
100 /u01/app/oradata/standby/EXAMPLE01.DBF
10 /u01/app/oradata/standby/TEST_STDBY01.DBF
0 /u01/app/oracle/product/11.1.0/db_1/dbs/UNNAMED00007
7 rows selected.
SQL>
SQL> select bytes/1024/1024 MB, name from v$datafile;
MB NAME
---------- ----------------------------------------------------------------------------------------------------
700 /u01/app/oradata/standby/SYSTEM01.DBF
822.625 /u01/app/oradata/standby/SYSAUX01.DBF
230 /u01/app/oradata/standby/UNDOTBS01.DBF
5 /u01/app/oradata/standby/USERS01.DBF
100 /u01/app/oradata/standby/EXAMPLE01.DBF
10 /u01/app/oradata/standby/TEST_STDBY01.DBF
0 /u01/app/oracle/product/11.1.0/db_1/dbs/UNNAMED00007
7 rows selected.
SQL>
注：由于STANDBY_FILE_MANAGEMENT=manual，所以，第一个数据文件放在了默认的/u01/app/oracle/product/11.1.0/db_1/dbs/下，为UNNAMED00007。
4 恢复正常设置
SQL>
SQL> alter database create datafile '/u01/app/oracle/product/11.1.0/db_1/dbs/UNNAMED00007'
2 as
3 '/u01/app/oradata/standby/TEST_STDBY02.DBF';
Database altered.
SQL>
SQL> select bytes/1024/1024 MB, name from v$datafile;
MB NAME
---------- ----------------------------------------------------------------------------------------------------
700 /u01/app/oradata/standby/SYSTEM01.DBF
822.625 /u01/app/oradata/standby/SYSAUX01.DBF
230 /u01/app/oradata/standby/UNDOTBS01.DBF
5 /u01/app/oradata/standby/USERS01.DBF
100 /u01/app/oradata/standby/EXAMPLE01.DBF
10 /u01/app/oradata/standby/TEST_STDBY01.DBF
10 /u01/app/oradata/standby/TEST_STDBY02.DBF
7 rows selected.
SQL>
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oradata/standby/archive
Oldest online log sequence 142
Next log sequence to archive 0
Current log sequence 143
SQL>
SQL> show parameter standby_fil
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string MANUAL
SQL>
SQL> alter system set standby_file_management_file=auto scope=both;
alter system set standby_file_management_file=auto scope=both
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM
SQL> alter system set standby_file_management=auto scope=both;
System altered.
SQL>
SQL>