FILE_NAME
------------------------------------------------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUT MAXBYTES MAXBLOCKS
---------- ------------------------------ ---------- ---------- --------- ------------ --- ---------- ----------
INCREMENT_BY USER_BYTES USER_BLOCKS ONLINE_
------------ ---------- ----------- -------
/u01/app/oracle/oradata/prod/tbs1.dbf
6 TBS1 10485760 1280 AVAILABLE 6 NO 0 0
0 9437184 1152 ONLINE
Elapsed: 00:00:00.02
14:14:42 SYS@ prod>
检查是否包含辅助集SYSTEM UNDO和CONTROLFILE：
14:14:38 SYS@ prod>select file_name name from dba_data_files t where T.TABLESPACE_NAME IN('SYSTEM','UNDOTBS1')
14:14:40 2 union
14:14:41 3 select max(name) from v$controlfile t;
NAME
-------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/prod/control01.ctl
/u01/app/oracle/oradata/prod/system01.dbf
/u01/app/oracle/oradata/prod/undotbs01.dbf
Elapsed: 00:00:00.03
检查TSP之后可能丢失的对象：
14:14:42 SYS@ prod>select * from TS_PITR_OBJECTS_TO_BE_DROPPED T where T.OWNER='TBS1';
no rows selected
Elapsed: 00:00:00.17