LLI Wiki — My Digital Knowledge Base

Oracle: ORA-10873, datafile left in backup mode

Fix ORA-10873 at startup after a shutdown during a hot backup.

Error ORA-10873: file 1 needs to be either taken out of backup mode or media recovered appears at startup when the database went down while datafiles were still in hot backup mode.

Cause

The database was in backup mode (ALTER TABLESPACE ... BEGIN BACKUP) when it stopped.

Solution

  1. Connect as SYSDBA and mount the database:
sqlplus / as sysdba
startup mount
  1. Check which datafiles are in backup mode:
select * from v$backup;
  1. Take all datafiles out of hot backup mode:
alter database end backup;
  1. Open the database:
alter database open;

Notes

Source: doyensys.com.

Mastodon LLIMastodon SocialFosstodon