【异常处理】RMAN恢复，遭遇ORA-00279、ORA-00280、ORA-00289报错处理方法

数据库：oracle 11.2.0.4

系统：CentOS 7.9

异常描述：rman在目标端进行恢复时，出现ORA-00279、ORA-00280、ORA-00289告警，如下：

SQL> alter database open resetlogs upgrade;

alter database open resetlogs upgrade

\*

ERROR at line 1:

ORA-01152: file 2 was not restored from a sufficiently old backup

ORA-01110: data file 2: '/u01/app/oracle/oradata/orcl/sysaux.257.1107818147'

**SQL> recover database using backup controlfile until cancel;**

ORA-00279: change 1209509 generated at 07/15/2022 09:42:49 needed for thread 1

ORA-00289: suggestion :

+DATA/orcl/archivelog/2022\_07\_15/thread\_1\_seq\_20.324.1110102193

ORA-00280: change 1209509 for thread 1 is in sequence #20

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

**AUTO （手工输入）**

ORA-00308: cannot open archived log

'+DATA/orcl/archivelog/2022\_07\_15/thread\_1\_seq\_20.324.1110102193'

ORA-17503: ksfdopn:2 Failed to open file

+DATA/orcl/archivelog/2022\_07\_15/thread\_1\_seq\_20.324.1110102193

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15077: could not locate ASM instance serving a required diskgroup

ORA-29701: unable to connect to Cluster Synchronization Service

ORA-00308: cannot open archived log

'+DATA/orcl/archivelog/2022\_07\_15/thread\_1\_seq\_20.324.1110102193'

ORA-17503: ksfdopn:2 Failed to open file

+DATA/orcl/archivelog/2022\_07\_15/thread\_1\_seq\_20.324.1110102193

ORA-15001: diskgroup "DATA" does not exist or is not mounted

ORA-15077: could not locate ASM instance serving a required diskgroup

ORA-29701: unable to connect to Cluster Synchronization Service

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01152: file 2 was not restored from a sufficiently old backup

ORA-01110: data file 2: '/u01/app/oracle/oradata/orcl/sysaux.257.1107818147'

经过一番资料的查找，解决结果如下：

SQL> SELECT open\_mode from v$database;

OPEN\_MODE

\--------------------

MOUNTED 

SQL> alter system set "\_allow\_resetlogs\_corruption"=true scope=spfile; 

System altered.

SQL> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 3006406656 bytes

Fixed Size                  2257032 bytes

Variable Size             704647032 bytes

Database Buffers         2281701376 bytes

Redo Buffers               17801216 bytes

Database mounted.

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 1209509 generated at 07/15/2022 09:42:49 needed for thread 1

ORA-00289: suggestion :

+DATA/orcl/archivelog/2022\_07\_15/thread\_1\_seq\_20.324.1110102193

ORA-00280: change 1209509 for thread 1 is in sequence #20

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

**CANCEL （手工输入）**

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01152: file 2 was not restored from a sufficiently old backup

ORA-01110: data file 2: '/u01/app/oracle/oradata/orcl/sysaux.257.1107818147'

ORA-01112: media recovery not started

SQL> alter database open resetlogs;

Database altered.

SQL> archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            USE\_DB\_RECOVERY\_FILE\_DEST

Oldest online log sequence     1

Next log sequence to archive   1

Current log sequence           1

SQL> alter system set "\_allow\_resetlogs\_corruption"=false scope=spfile;

System altered.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 3006406656 bytes

Fixed Size                  2257032 bytes

Variable Size             704647032 bytes

Database Buffers         2281701376 bytes

Redo Buffers               17801216 bytes

Database mounted.

Database opened.