ORA-01152: file 1 was not restored from a sufficiently old backupORA-01110: data file 1: ‘/apps01/oradata/orcl19xsystem01.dbf’

Cause:

Due to inconsistent state of the datafile, i was not able to open the database without recover of archivelogs apply

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 07/28/2021 23:55:21
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/apps01/oradata/orcl19xsystem01.dbf'

Workaround:

After recover of the database, i was able to open the database

RMAN> recover database;

Starting recover at 28-JUL-21
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 152 is already on disk as file /data01/ORCL19X/archivelog/2021_07_28/o1_mf_1_152_jj2w0xl1_.arc
archived log for thread 1 with sequence 153 is already on disk as file /apps01/oradata/orcl19xredo03.log
archived log file name=/data01/ORCL19X/archivelog/2021_07_28/o1_mf_1_152_jj2w0xl1_.arc thread=1 sequence=152
archived log file name=/apps01/oradata/orcl19xredo03.log thread=1 sequence=153
media recovery complete, elapsed time: 00:00:03
Finished recover at 28-JUL-21

Open the database

RMAN> alter database open resetlogs;

Statement processed

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s