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.

Error:


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'

Cause:

Database in backup mode while it went down.

Solution:

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:
            ALTER DATABASE END BACKUP;
Step 5 : Alter database open

11 comments:

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.

Att.
Richard

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...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

Moses Thanraj said...

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

Anonymous said...

thanks dude