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

备端
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
从主端备份归档传过来恢复
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: {<RET>=suggested | filename | AUTO | CANCEL}
^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: {<RET>=suggested | filename | AUTO | CANCEL}
/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: {<RET>=suggested | filename | AUTO | 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.

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值