ORA-01274:cannot add datafile ''-file could not be created DG添加删除数据文件

jiawang

备库报错日志：
File #210 added to control file as 'UNNAMED00210' because
the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
The file should be manually created to continue.
MRP0: Background Media Recovery terminated with error 1274
Errors in file /u01/oracle/app/diag/rdbms/orcl/orcl/trace/orcl_pr00_109437.trc:



报错原因：
参数standby_file_management 设置为manual ，将standby_file_management 改为auto：



查看数据文件全名

SQL> select file_name from dba_data_files where tablespace_name='UNNAMED00210';
no rows selected


因为数据文件只是以UNNAMED00210 记录在控制文件中，并没有真正创建成功，所以在 dba_data_files 视图中是看不到的

SQL> select name from v$datafile;                                   
NAME
…………
/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00210

创建数据文件路径
SQL> alter database create datafile '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00210' as '/oradata/orcl/tsp_orcl05.dbf';
Database altered.


再将standby_file_management改为 auto，启动恢复进程：

SQL>  alter system set standby_file_management=auto;
System altered.

SQL> alter database recover managed standby database using current logfile disconnect;
Database altered.