ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-1146 tablespace is already in backup mode

ORA-1146 tablespace is already in backup mode

原创 Linux操作系统 作者:licheng79 时间:2012-01-18 12:38:12 0 删除 编辑

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

shttp://docs.oracle.com/cd/B13789_01/server.101/b10755/dynviews_1023.htm

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26136400/viewspace-715139/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-09-07

  • 博文量
    54
  • 访问量
    67300