我们可以通过查看试图v$backup能找到那些表空间还没结束备份状态;
SQL> 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 0
7 NOT ACTIVE 0
8 NOT ACTIVE 0
9 NOT ACTIVE 0
10 NOT ACTIVE 1193556 29-4月 -05
11 NOT ACTIVE 0
已选择11行。
SQL> alter tablespace test begin backup;
表空间已更改。
SQL> 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 0
7 NOT ACTIVE 0
8 NOT ACTIVE 0
9 NOT ACTIVE 0
10 ACTIVE 1193603 29-4月 -05
11 ACTIVE 1193603 29-4月 -05
(注:status为“active”表示是在备份状态)
已选择11行。
SQL> desc v$datafile;
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
FILE# NUMBER
CREATION_CHANGE# NUMBER
CREATION_TIME DATE
TS# NUMBER
RFILE# NUMBER
STATUS VARCHAR2(7)
ENABLED VARCHAR2(10)
CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME DATE
UNRECOVERABLE_CHANGE# NUMBER
UNRECOVERABLE_TIME DATE
LAST_CHANGE# NUMBER
LAST_TIME DATE
OFFLINE_CHANGE# NUMBER
ONLINE_CHANGE# NUMBER
ONLINE_TIME DATE
BYTES NUMBER
BLOCKS NUMBER
CREATE_BYTES NUMBER
BLOCK_SIZE NUMBER
NAME VARCHAR2(513)
PLUGGED_IN NUMBER
SQL> select ts# from v$datafile
2 where file# in (10,11);
TS#
----------
8
8
SQL> desc v$tablespace
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
TS# NUMBER
NAME VARCHAR2(30)
SQL> select name from v$tablespace
2 where ts#=8;
NAME
------------------------------
TEST
SQL> alter tablespace test end backup;
表空间已更改。