背景說明
故障具體分析
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 =’’;
問題總結
文章版權歸作者所有,未經允許請勿轉載,若此文章存在違規行為,您可以聯系管理員刪除。
轉載請注明本文地址:http://specialneedsforspecialkids.com/yun/129673.html
摘要:配置主庫和備庫。主庫當前的二進制日志文件,和獲得數據快照時在該二進制日志文件中的偏移量。它能夠在備份時不阻塞服務器的操作,因此可以在不影響主庫的情況下設置備庫。 showImg(https://segmentfault.com/img/bVbqOEk?w=720&h=480); 正所謂理論造航母,現實小帆船。單有理論,不動手實踐,學到的知識猶如空中樓閣。接下來,我們一起來看下如何一步步...
摘要:配置主庫和備庫。主庫當前的二進制日志文件,和獲得數據快照時在該二進制日志文件中的偏移量。它能夠在備份時不阻塞服務器的操作,因此可以在不影響主庫的情況下設置備庫。 showImg(https://segmentfault.com/img/bVbqOEk?w=720&h=480); 正所謂理論造航母,現實小帆船。單有理論,不動手實踐,學到的知識猶如空中樓閣。接下來,我們一起來看下如何一步步...
閱讀 1346·2023-01-11 13:20
閱讀 1684·2023-01-11 13:20
閱讀 1132·2023-01-11 13:20
閱讀 1860·2023-01-11 13:20
閱讀 4100·2023-01-11 13:20
閱讀 2704·2023-01-11 13:20
閱讀 1385·2023-01-11 13:20
閱讀 3597·2023-01-11 13:20