DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Thursday, August 1, 2013

ORA-10873: file 1 needs to be either taken out of backup mode or media recovered

Scenario :

Database went down due to power fluctuation and during that time hot backup was running.So once we started the database we face the following issue.


ORA-10873: file 1 needs to be either taken out of backup mode or media recovered
ORA-01110: data file 1: '/system/PROD/system01.dbf'


Database in backup mode while it went down.


Step 1 : Sqlplus  ‘/as sysdba’
Step 2 : startup mount
Step 3 : Check backup file using below command.
            select * from V$BACKUP
Step 4 : The following command can be used to take all of the data files out of hot backup mode:
Step 5 : Alter database open


Richard Sanchez said...
This comment has been removed by the author.
Richard Sanchez said...

Hi Sara

Thank you very much for your Blog.

Yesterday I helped solve a bug in our production system.

I hope you continue doing this kind of activities that help to many.

I hope you're happy day.


Shahin said...

hi Sara,
solution which you provided resolved our problem in live system.

thanks a lot :)

Ayesha said...

KPS Sir , our backups were failing due to this error .Following your solution resolved it .Thanks a lot !!

Anonymous said...

Thanks a ton. It works!!!

Anonymous said...

Thank you very much! So Helpful for me.

Varun Arya said...

Hi Sara,

Awsome help Thank you soo muchh for nice work and help.

pobby69 said...

Thanks for the article, this proved very useful.

Sridevi K said...

Sridevi Koduru (Senior Oracle Apps Trainer
LinkedIn profile -
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.

Moses Thanraj said...

Good article, useful and proved fine, what would happen for the active backup

Anonymous said...

thanks dude