DG库不自动创建数据文件

原创黄丽萍 2021-08-25

812

问题：DG库不同步

查看日志：

Errors in file /opt/u01/app/oracle/diag/rdbms/sjzydbdg/sjzydb1/trace/sjzydb1_pr00_67311.trc:
MRP0: Background Media Recovery terminated with error 1274
The file should be manually created to continue.
the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
File #83 added to control file as ‘UNNAMED00083’ because

查看参数：

SQL> show parameter standby

NAME TYPE VALUE

standby_archive_dest string ?/dbs/arch
standby_file_management string MANUAL

查看数据文件：

SQL> select FILE#,name,CREATION_TIME from v$datafile;

    FILE# NAME                                     CREATION_TIME
复制

        1 +DATA/sjzydbdg/datafile/system.404.99756 2013-08-24 11:37:33
          4151
        ...................此处省略部分.............................

       82 +DATA/sjzydbdg/datafile/ts_pfm.391.99756 2019-01-11 00:29:10
          3333

       83 /opt/u01/app/oracle/product/11.2.0/dbhom 2019-01-30 17:12:19
          e_1/dbs/UNNAMED00083
复制

解决：

SQL> Alter database create datafile '/opt/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00083' as '+DATA/' size 30g;
			
SQL> alter system set standby_file_management=auto scope=both;
			  
System altered.
			  
SQL> recover managed standby database using current logfile disconnect;
Media recovery complete.
			  
SQL> select process,status,thread#,sequence#,block#,blocks from v$managed_standby;
复制

参考文档：文档 ID(1416554.1)

oracle