adg通过增量恢复后，tempfile报错ORA-01157

源端是oracle11.2.0.4 rac+asm，目标端单机+fs

由于断电故障，adg长时间无人维护，GAP归档缺失，采用增量恢复的方式恢复完成。

备库open后报如下错误：

处理办法：由于备库只有一个临时文件，所以需在备库添加一个新的临时文件，然后删掉报错的临时文件即可。

SQL> !mkdir -p /oradata/orcl/tempfile/

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
16:54:41 SQL> startup
ORACLE instance started.

Total System Global Area 1.2393E+10 bytes
Fixed Size                  2264696 bytes
Variable Size            7113539976 bytes
Database Buffers         5268045824 bytes
Redo Buffers                9256960 bytes
Database mounted.
Database opened.
SQL> select * from v$tempfile;

     FILE# CREATION_CHANGE# CREATION_        TS#     RFILE# STATUS  ENABLED         BYTES     BLOCKS CREATE_BYTES BLOCK_SIZE NAME
---------- ---------------- --------- ---------- ---------- ------- ---------- ---------- ---------- ------------ ---------- -------------------------------------------------------
         1             3114 14-DEC-18          3          1 ONLINE  READ WRITE          0          0     20971520       8192 +DATADG/orcl/tempfile/temp.281.994812687

SQL> alter tablespace temp add tempfile '/oradata/orcl/tempfile/temp.281.994812687' size 100M autoextend on next 10M;

Tablespace altered.
16:56:36 SQL> select * from v$tempfile;

     FILE# CREATION_CHANGE# CREATION_        TS#     RFILE# STATUS  ENABLED         BYTES     BLOCKS CREATE_BYTES BLOCK_SIZE NAME
---------- ---------------- --------- ---------- ---------- ------- ---------- ---------- ---------- ------------ ---------- -------------------------------------------------------
         1             3114 14-DEC-18          3          1 ONLINE  READ WRITE          0          0     20971520       8192 +DATADG/orcl/tempfile/temp.281.994812687
         2       3281115100 24-OCT-24          3          2 ONLINE  READ WRITE  104857600      12800    104857600       8192 /oradata/orcl/tempfile/temp.281.994812687

SQL> alter tablespace temp drop tempfile 1;

Tablespace altered.

SQL> select * from v$tempfile;

     FILE# CREATION_CHANGE# CREATION_        TS#     RFILE# STATUS  ENABLED         BYTES     BLOCKS CREATE_BYTES BLOCK_SIZE NAME
---------- ---------------- --------- ---------- ---------- ------- ---------- ---------- ---------- ------------ ---------- -------------------------------------------------------
         2       3281115100 24-OCT-24          3          2 ONLINE  READ WRITE  104857600      12800    104857600       8192 /oradata/orcl/tempfile/temp.281.994812687

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
16:57:32 SQL> startup
ORACLE instance started.

Total System Global Area 1.2393E+10 bytes
Fixed Size                  2264696 bytes
Variable Size            7113539976 bytes
Database Buffers         5268045824 bytes
Redo Buffers                9256960 bytes
Database mounted.
Database opened.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSIO
恢复同步

增量恢复相关参考：

Oracle主库丢失归档，如何使用增量前滚恢复主备一致

使用RMAN增量备份处理Dataguard因归档丢失造成的gap_fal[client]:failed to request gap sequence-CSDN博客

Oracle 增量修复DG同步