DBA Notes: 2012/01/18

Cheng Li

(Database: Oracle 9i, OS: AIX)

ORA-1146 tablespace is already in backup mode

We meet alert error message ORA-1146 on a 9i database for a hot back-up.
What would be a root cause of the situation?

Solution:

Some tablespace is already in backup mode.
identified by

SQL> select * from v$backup where status

FILE# STATUS CHANGE# TIME

---------- ------------------ ---------- ---------

177 NOT ACTIVE 9.9902E+12 20-JAN-12

178 NOT ACTIVE 9.9902E+12 20-JAN-12

179 NOT ACTIVE 9.9902E+12 20-JAN-12

180 NOT ACTIVE 9.9902E+12 20-JAN-12

181 NOT ACTIVE 9.9902E+12 20-JAN-12

182 NOT ACTIVE 9.9902E+12 20-JAN-12

183 NOT ACTIVE 9.9902E+12 20-JAN-12

184 NOT ACTIVE 9.9902E+12 20-JAN-12

185 NOT ACTIVE 9.9902E+12 20-JAN-12

186 NOT ACTIVE 9.9902E+12 20-JAN-12

187 NOT ACTIVE 9.9902E+12 20-JAN-12

188 rows selected.

And end the backup by of particuler tablespace
alter tablespace end backup;

Reference:

V$BACKUP

V$BACKUP displays the backup status of all online datafiles.

Column	Datatype	Description
FILE#	NUMBER	File identifier
STATUS	VARCHAR2(18)	File status: NOT ACTIVE, ACTIVE (backup in progress), OFFLINE NORMAL, or description of an error
CHANGE#	NUMBER	System change number when backup started
TIME	DATE	Time the backup started