往期专题请查看www.zhaibibei.cn 这是一个坚持Oracle,Python,MySQL原创内容的公众号这个专题讲一些日常运维的异常处理
今天讲一个DG环境中给主库增加数据文件时的报错
1. 现象今天给DG环境中给主库增加数据文件时的报错
提示无权限建立数据文件并关闭了同步 Fetching gap sequence for thread 1, gap sequence 3236-3236 Trying FAL server: mesft Media Recovery Log /mesft/arch/1_3236.log File #31 added to control file as 'UNNAMED00031'. Originally created as: '/oralog/mesft/oradata/mesft19.dbf' Recovery was unable to create the file as: '/oralog/mesft/mesft/oradata19.dbf'
MRP0: Background Media Recovery terminated with error 1274
Errors in file /u01/app/oracle/admin/mesftdg/bdump/mesftdg_mrp0_17570.trc: ORA-01274: cannot add datafile '/oralog/mesft/oradata/mesft19.dbf' - file could not be created ORA-01119: error in creating database file '/oralog/mesft/mesft/oradata19.dbf' ORA-27054: Message 27054 not found; product=RDBMS; facility=ORA Linux-x86_64 Error: 13: Permission denied Some recovered datafiles maybe left media fuzzy Media recovery may continue but open resetlogs may fail MRP0: Background Media Recovery process shutdown
2. 原因查找该错误是由于主库建立的数据文件无法同步在备库建立所致 由于db_file_name_convert 参数配置不当导致转换过去的文件路径在备库中无法建立 关于db_file_name_convert这里有三点需要说明 3. 问题解决3.1 找出系统生成文件的路径SQL> select name from v$datafile where name like '%UNNAMED%';
NAME -------------------------------------------------------------------------------- /u01/app/oracle/product/9.2.0/db_1/dbs/UNNAMED00031
3.2 关闭自动文件管理alter system set standby_file_management='manual';
3.2 在正确位置生成需要的数据文件alter database create datafile '/u01/app/oracle/product/9.2.0/db_1/dbs/UNNAMED00031' as '/mesft/oralog/mesft19.dbf';
3.3 启动自动文件管理alter system set standby_file_management='auto';
3. 启动同步进程alter database recover managed standby database disconnect from session;
4.参考链接https://www./fixing-dataguard-wrong-file-location-problem/
|