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


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/AZKKPROD/system01.dbf'
Cause:
Database in backup mode while it went down.
Solution:
  1. Sqlplus “/as sysdba”
  2. startup mount
  3. select * from V$BACKUP
  4. ALTER DATABASE END BACKUP
  5. Alter database open

2 comments

  1. Kalicharan singh · · Reply

    Thank you so much for the solution.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: