Summary
An Oracle database backup fails. The job log displays an error message similar to the following: ORA-01146: cannot start online backup." To resolve this issue, reset the backup status of tablespace ."
Symptoms
The job log reports messages similar to the following:
Tue May 19 22:21:37 2009 SNBOCL_015J Putting tablespace (PROD/TS) in backup mode
Tue May 19 22:21:37 2009 SNBAPP_002J java.sql.SQLException: ORA-01146: cannot start online backup - file 10 is already in backup ORA-01110: data file 10: 'D:\ORACLE\ORA10G\DBFPROD\TS.DBF' Query: alter tablespace TS begin backup Parameters: []
Tue May 19 22:21:37 2009 SNBAPH_126E Func(AHOpPfs:run): Exception (com.syncsort.bex.msg.bexException: <EXCEPTION CATEGORY="BEXEXCEPTION"><CODE>21005</CODE></EXCEPTION> )
Resolution
The Oracle ORA-01146 error message indicates that when the system starts an online backup, it detects an existing online backup for one of the data files.
This is caused by either:
- Another backup in process at the same time.
- A previous backup that does not complete successfully and leaves the tablespace in backup mode.
To resolve this issue, reset the backup status of tablespace <TS> with the following:
alter tablespace<TS>end backup