DataGuard库创建数据文件报错，导致DG库无法同步--解决方案记录

今天遇到DG库裸设备存放数据文件的目录权限不对，主库添加数据文件，需要对DG库进行同步时报错，无法添加，导致DG库无法同步。

报错信息如下：

Media Recovery Log /proplh/db_dg_arc/proplh/1_201588.dbf
File #195 added to control file as 'UNNAMED00195'. Originally created as:
'/dev/oradata06/rproplh_data_122'
Recovery was unable to create the file as:
'/dev/oradata06/rproplh_data_122'
MRP0: Background Media Recovery terminated with error 1274
Thu Dec 26 18:32:42 2013
Errors in file /u01/oracle/admin/proplh/bdump/proplh_mrp0_18346.trc:
ORA-01274: cannot add datafile '/dev/oradata06/rproplh_data_122' - file could not be created
ORA-01119: error in creating database file '/dev/oradata06/rproplh_data_122'
ORA-27040: skgfrcre: create error, unable to create file
HP-UX Error: 13: Permission denied

解决步骤如下：

首先在DG库上创建需要的数据文件

SQL> select name from v$datafile where name like '%UNNAMED00195%';
NAME
--------------------------------------------------------------------------------
/u01/oracle/product/db10gr2/dbs/UNNAMED00195

SQL> alter system set standby_file_management=manual;

System altered.

alter database create datafile '/u01/oracle/product/db9ir2/dbs/UNNAMED00195' as '/dev/oradata06/rproplh_data_122.dbf';
alter database create datafile '/u01/oracle/product/db9ir2/dbs/UNNAMED00196' as '/dev/oradata06/rproplh_data_123.dbf';
alter database create datafile '/u01/oracle/product/db9ir2/dbs/UNNAMED00197' as '/dev/oradata06/rproplh_data_124.dbf';
alter database create datafile '/u01/oracle/product/db9ir2/dbs/UNNAMED00198' as '/dev/oradata06/rproplh_data_125.dbf';
alter database create datafile '/u01/oracle/product/db9ir2/dbs/UNNAMED00199' as '/dev/oradata06/rproplh_data_126.dbf';

SQL> alter system set standby_file_management=auto;

System altered.

再把数据文件恢复完成后重新同步DG库

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE disconnect from session;

备注：
在以上步骤中，如果standby_file_management设置为AUTO时，执行create命令会遇到如下错误：
SQL> alter database create datafile '/u01/oracle/product/db9ir2/dbs/UNNAMED00195' as '/dev/oradata06/rproplh_data_122.dbf';

alter database rename
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01275: Operation RENAME is not allowed if standby file management is　automatic.