ORA-01152:ファイル1は十分に古いバックアップから復元されませんでした



Ora 01152 File 1 Was Not Restored From Sufficiently Old Backup



Standby SQL> ALTER DATABASE OPEN READ ONLY ALTER DATABASE OPEN READ ONLY * ERROR at line 1: ORA-10458: standby database requires recovery ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/oradata/ORCLDG/datafile/system.256.942211925' SQL> select ts#,checkpoint_change# from v$datafile TS# CHECKPOINT_CHANGE# ---------- ------------------ 0 208128738 1 208128732 2 208128732 4 208128738 5 208128732 6 208128732 8 208128740 9 208128740 10 208128740 11 208128740 10 rows selected. SQL> select ts#,checkpoint_change# from v$datafile_header TS# CHECKPOINT_CHANGE# ---------- ------------------ 0 208128738 1 208128732 2 208128732 4 208128738 5 208128732 6 208128732 8 208128740 9 208128740 10 208128740 11 208128740 10 rows selected. SQL> select * from v$recover_file no rows selected Recover from the primary backup archive SQL> SQL> recover database until change 208128740 using backup controlfile ORA-00283: recovery session canceled due to errors ORA-01666: control file is for a standby database SQL> recover standby database until change 208128740 using backup controlfile ORA-00279: change 208128732 generated at 08/29/2018 05:22:07 needed for thread 1 ORA-00289: suggestion : /arch/1_154_942212032.dbf ORA-00280: change 208128732 for thread 1 is in sequence #154 Specify log: filename ^C ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/oradata/ORCLDG/datafile/system.256.942211925' SQL> recover standby database until change 208128740 using backup controlfile ORA-00279: change 208128732 generated at 08/29/2018 05:22:07 needed for thread 1 ORA-00289: suggestion : /arch/1_154_942212032.dbf ORA-00280: change 208128732 for thread 1 is in sequence #154 Specify log: =suggested /arch/1_154_942212032.dbf ORA-00279: change 208128732 generated at 08/29/2018 04:09:04 needed for thread 2 ORA-00289: suggestion : /arch/2_143_942212032.dbf ORA-00280: change 208128732 for thread 2 is in sequence #143 Specify log: CANCEL /arch/2_143_942212032.dbf ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/oradata/ORCLDG/datafile/system.256.942211925' ORA-01112: media recovery not started SQL> select ts#,checkpoint_change# from v$datafile_header TS# CHECKPOINT_CHANGE# ---------- ------------------ 0 208128740 1 208128740 2 208128740 4 208128740 5 208128740 6 208128740 8 208128740 9 208128740 10 208128740 11 208128740 10 rows selected. SQL> select ts#,checkpoint_change# from v$datafile TS# CHECKPOINT_CHANGE# ---------- ------------------ 0 208128740 1 208128740 2 208128740 4 208128740 5 208128740 6 208128740 8 208128740 9 208128740 10 208128740 11 208128740 10 rows selected. SQL> ALTER DATABASE OPEN READ ONLY Database altered.