[20140429]ora-01149.txt

[20140429]ora-01149.txt

$ oerr ora 1149
01149, 00000, "cannot shutdown - file %s has online backup set"
// *Cause: An attempt to shutdown normally found that an online backup is
//        still in progress.
// *Action: End the backup of the offending tablespace and retry this command.

--昨天测试环境,发现在shutdown immediate时出现错误,估计有人学习使用了用户备份模式.
--结束备份模式就可以解决这个问题,自己在模拟看看.

SYS@test> @ver
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

SYS@test> alter tablespace test begin backup;
Tablespace altered.

SYS@test> select * from v$backup ;
     FILE# STATUS                CHANGE# TIME
---------- ------------------ ---------- -------------------
         1 NOT ACTIVE                  0
         2 NOT ACTIVE                  0
         3 NOT ACTIVE                  0
         4 NOT ACTIVE                  0
         5 NOT ACTIVE                  0
         6 NOT ACTIVE         3011239824 2012-11-08 15:43:19
         7 NOT ACTIVE                  0
         8 ACTIVE             3269974823 2014-04-29 08:59:13
         9 NOT ACTIVE                  0
        10 NOT ACTIVE                  0

10 rows selected.

--file#=8 ,在备份模式.

SYS@test> shutdown immediate
ORA-01149: cannot shutdown - file 8 has online backup set
ORA-01110: data file 8: '/u01/app/oracle11g/oradata/test/test01.dbf'

--不知道以前的版本有这些提示吗?自己从来没有使用这种模式备份.
SYS@test> alter tablespace test end backup;
Tablespace altered.

SYS@test> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SYS@test> select * from v$backup ;
     FILE# STATUS                CHANGE# TIME
---------- ------------------ ---------- -------------------
         1 NOT ACTIVE                  0
         2 NOT ACTIVE                  0
         3 NOT ACTIVE                  0
         4 NOT ACTIVE                  0
         5 NOT ACTIVE                  0
         6 NOT ACTIVE         3011239824 2012-11-08 15:43:19
         7 NOT ACTIVE                  0
         8 NOT ACTIVE         3269974823 2014-04-29 08:59:13
         9 NOT ACTIVE                  0
        10 NOT ACTIVE                  0

10 rows selected.

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

转载于:http://blog.itpub.net/267265/viewspace-1151276/