今天遇到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.