ORA-01113: File 1 needs media recovery if it was restored from backup, or END BACKUP if it was not.

[manoj2910]

Hi,

I'm facing the below issue while restoring the production online backup.

I have restored the Online backup Successfully and also recovered database with archive logs not only that are generated during the Production backup but also a day ahead.

But still I'm facing the error when I give the below command.

alter database open noresetlogs;

The errors I'm facing are:

ORA-01113: File 1 needs media recovery if it was restored from backup, or END BACKUP if it was not.

ORA-01110: Data file 1: '/oracle/ACC/sapdata1/system_1/system.data1'

[manoj2910 · Accepted solution]

Hi,

Thanks for the valuable suggestions. I have tried every possible way. But it didn't work.

I tired to restore the database again with a fresh backup. Then it worked fine.

Regards,

Manoj

[janos_mucsi-besze]

Hi Manoj,

Instead of manual restore and recovery (which very often fail, like here) I suggest you the usage of BRRECOVER. This tool makes everything for you and decides itself how the database can be opened. I never faced any issues with BRRECOVER in the past and nowadays as well.

Regards,

János

[rafaelgalindo]

Hi,

Try use this:

RECOVER DATABASE UNTIL CANCEL

ALTER DATABASE OPEN RESETLOGS

Maybe you can open using a backup control file too:

RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE

[tan_michael]

Hi,

Have you really restored it successfully? May I know your steps in restoring your online backup? I think you missed some procedures during restoration.

[Former Member]

Hi Manoj,

Did you try recovering DB until cancel ?

Regards,

Harish Karrra

[manoj2910]

Hi Harish,

I have tried recover DB until cancel. But no use