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

I faced this error when I tried to open the database from the recovered database, at that time it was told that one of my system datafile was not restored from a sufficiently old backup. The workaround to fix it is can be done by copying all available archivelog into the directory where archivelog is stored. Then you can connect to the database using SQLPLUS


Then it will prompt you a request to find the required archivelog, just type auto if you already put all the archivelog in the directory where you put all the archivelog according to PFILE. Otherwise you have to type it manually one by one. That will be something like this

ORA-00279: ……..

ORA-00289: ……..

ORA-00280: ……..

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

Hope that will fix your error 😀