背景说明
故障具体分析
Thu Dec 23 00:18:05 2021
Media Recovery Waiting for thread 1 sequence 82 (in transit)
Recovery of Online Redo Log: Thread 1 Group 9 Seq 82 Reading mem 0
Mem# 0: /data/u01/oracle/oradata/stredo01.log
Thu Dec 23 16:34:03 2021
Errors in file /data/u01/oracle/diag/rdbms/aaadbdg/AAADBDG/trace/AAADBDG_pr00_12137.trc:
ORA-01264: Unable to create datafile file name
ORA-19800: Unable to initialize Oracle Managed Destination
Linux-x86_64 Error: 13: Permission denied
File #13 added to control file as UNNAMED00013.
Originally created as:
/data/u01/oracle/oradata/aaa_obs_data_01.dbf
2. 进行alert中上述trc文件重要信息收集
*** 2021-12-23 16:34:03.848
ORA-19800: Unable to initialize Oracle Managed Destination
Linux-x86_64 Error: 13: Permission denied
File #13 added to control file as UNNAMED00013.
Originally created as:
/data/u01/oracle/oradata/aaa_obs_data_01.dbf
Recovery was unable to create the file as a new OMF file.
*** 2021-12-23 16:34:03.880 4343 krsh.c
MRP0: Background Media Recovery terminated with error 1274
ORA-01274: cannot add datafile /data/u01/oracle/oradata/aaa_obs_data_01.dbf - file could not be created
*** 2021-12-23 16:34:03.880 4343 krsh.c
Managed Standby Recovery not using Real Time Apply
MRP: Prodding archiver at standby for thread 1 seq 82
SQL> show parameter file_name_convert
NAME TYPE VALUE-
------------------------------------ ---------------------- --------------------
log_file_name_convert /data/u01/oracle/oradata,/data/u01/oracle/oradata
db_file_name_convert /data/u01/oracle/oradata,/data/u01/oracle/oradata
SQL> show parameter STANDBY_FILE_MANAGEMENT
NAME TYPE VALUE
---------------- --------------- ------------------------------
standby_file_management string auto
SQL> show parameter db_create_file_dest
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
db_create_file_dest string /data
造成故障主要原因
处理方法
RMAN> duplicate target database for standby nofilenamecheck from active database;
Alter system set db_create_file_dest =’’;
问题总结
文章版权归作者所有,未经允许请勿转载,若此文章存在违规行为,您可以联系管理员删除。
转载请注明本文地址:https://www.ucloud.cn/yun/129673.html
摘要:配置主库和备库。主库当前的二进制日志文件,和获得数据快照时在该二进制日志文件中的偏移量。它能够在备份时不阻塞服务器的操作,因此可以在不影响主库的情况下设置备库。 showImg(https://segmentfault.com/img/bVbqOEk?w=720&h=480); 正所谓理论造航母,现实小帆船。单有理论,不动手实践,学到的知识犹如空中楼阁。接下来,我们一起来看下如何一步步...
摘要:配置主库和备库。主库当前的二进制日志文件,和获得数据快照时在该二进制日志文件中的偏移量。它能够在备份时不阻塞服务器的操作,因此可以在不影响主库的情况下设置备库。 showImg(https://segmentfault.com/img/bVbqOEk?w=720&h=480); 正所谓理论造航母,现实小帆船。单有理论,不动手实践,学到的知识犹如空中楼阁。接下来,我们一起来看下如何一步步...
阅读 1235·2023-01-11 13:20
阅读 1542·2023-01-11 13:20
阅读 994·2023-01-11 13:20
阅读 1650·2023-01-11 13:20
阅读 3958·2023-01-11 13:20
阅读 2456·2023-01-11 13:20
阅读 1288·2023-01-11 13:20
阅读 3450·2023-01-11 13:20