重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-01274:cannot add datafile ''-file could not be created DG添加删除数据文件 [打印本页]

作者: jiawang 时间: 2024-1-31 16:38
标题: ORA-01274:cannot add datafile ''-file could not be created DG添加删除数据文件
本帖最后由 jiawang 于 2024-1-31 17:24 编辑

备库报错日志：
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.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)