oracle standby 数据库应用日志报错ORA-01111 ORA-01110 ORA-01157

oracle standby 数据库应用日志报错ORA-01111 ORA-01110 ORA-01157

         因为备库磁盘空间不够，在主库新增了表空间，之后导致备库同步失败，之后对备库进行了扩容，扩容后启动同步报发下错误：

MRP0: Background Media Recovery terminated with error 1111
Errors in file /opt/u01/app/oracle/diag/rdbms/ydjydg/ydjydg1/trace/ydjydg1_pr00_3708.trc:
ORA-01111: name for data file 421 is unknown - rename to correct file
ORA-01110: data file 421: '/opt/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00421'
ORA-01157: cannot identify/lock data file 421 - see DBWR trace file
ORA-01111: name for data file 421 is unknown - rename to correct file
ORA-01110: data file 421: '/opt/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00421'
Managed Standby Recovery not using Real Time Apply
Recovery Slave PR00 previously exited with exception 1111
MRP0: Background Media Recovery process shutdown (ydjydg1)

根据查找mos分析，处理步骤如下：创建一个空的数据文件，其结构与数据文件421相同，并且从创建时起需要所有存档日志进行恢复。

SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUAL SID='*';

System altered.

SQL>  
SQL> 
SQL> Alter database create datafile '/opt/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00421' as '+data' size 32700M;

Database altered.

SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO SID='*';

System altered.

SQL> alter database open;

启动日志应用

SQL> alter database recover managed standby database using current logfile disconnect from session;


Database altered.

SQL>

检查同步状态

SQL> select recovery_mode from v$archive_dest_status where dest_id=2;

RECOVERY_MODE
-----------------------
IDLE

SQL> select name,value,datum_time from v$dataguard_stats;

NAME                             VALUE                                                            DATUM_TIME
-------------------------------- ---------------------------------------------------------------- ------------------------------
transport lag                    +00 00:00:00                                                     07/28/2020 21:10:51
apply lag                        +01 20:19:40                                                     07/28/2020 21:10:51
apply finish time                +00 05:08:04.907
estimated startup time           29

SQL> /

NAME                             VALUE                                                            DATUM_TIME
-------------------------------- ---------------------------------------------------------------- ------------------------------
transport lag                    +00 00:00:00                                                     07/28/2020 21:11:39
apply lag                        +01 20:16:10                                                     07/28/2020 21:11:39
apply finish time                +00 02:01:00.952
estimated startup time           29

SQL> /

NAME                             VALUE                                                            DATUM_TIME
-------------------------------- ---------------------------------------------------------------- ------------------------------
transport lag                    +00 00:00:00                                                     07/28/2020 21:13:54
apply lag                        +01 20:09:21                                                     07/28/2020 21:13:54
apply finish time                +00 01:31:05.147
estimated startup time           29

SQL>