DG库的standby_file_management=manual,主库添加文件的时候,备库无法自动创建对应的文件而报错
File #154 added to control file as 'UNNAMED00154' because the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
The file should be manually created to continue.
Errors with log /archlog/xxxxxx/1_366104_861895616.dbf
MRP0: Background Media Recovery terminated with error 1274
Errors in file /oracle/diag/rdbms/standby_xxxxxx/xxxxxx/trace/xxxxxx_pr00_19400.trc:
ORA-01274: cannot add datafile '/data/xxxxxx/data02.dbf' - file could not be created
Wed Apr 15 19:40:55 2020
Recovery interrupted!
在DG库standby_file_management=manual的情况下,备库会在控制文件中将新生成的文件自动命名为$ORACLE_HOME/dbs/XXXfile#
解决方法:
alter database create datafile '/oracle/11204/dbs/UNNAMED00154' as '/data/xxxxxx/data02.dbf'; (在mount和open状态都可以执行)
alter system set standby_file_management=auto;
alter databaese recover managed standby database diconnect;