Oracle--记一起由Oracle心跳引起的生产库故障--其乐融融的IT技术小站

SQL> select name,status from v$datafile;

NAME STATUS
-------------------------------------------------------------------------------- -------
+DATA/hdls/datafile/system.306.1100288753 SYSTEM
+DATA/hdls/datafile/sysaux.264.1100288753 ONLINE
+DATA/hdls/datafile/undotbs1.263.1100288753 ONLINE
+DATA/hdls/datafile/users.260.1100288753 ONLINE
+DATA/hdls/datafile/undotbs2.277.1100288833 ONLINE
+DATA/hdls/oauser01.dbf ONLINE
+DATA/hdls/hdls2001.dbf ONLINE
+DATA/hdls/oa01.dbf ONLINE
+DATA/hdls/hdls01.dbf ONLINE
+DATA/hdls/hdls02.dbf ONLINE
+DATA/hdls/hdls03.dbf ONLINE
+DATA/hdls/hdls04.dbf ONLINE
+DATA/hdls/hdls05.dbf ONLINE
+DATA/hdls/hdls06.dbf ONLINE
+DATA/hdls/hdls07.dbf ONLINE
+DATA/hdls/hdls08.dbf ONLINE
+DATA/hdls/hdls09.dbf ONLINE
+DATA/hdls/hdls10.dbf ONLINE
+DATA/hdls/others01.dbf ONLINE
+DATA/hdls/others02.dbf ONLINE
+DATA/hdls/others03.dbf ONLINE
+DATA/hdls/indx01.dbf ONLINE
+DATA/hdls/indx02.dbf ONLINE
+DATA/hdls/indx03.dbf ONLINE
+DATA/hdls/indx04.dbf ONLINE
+DATA/hdls/indx05.dbf ONLINE
+DATA/hdls/indx06.dbf ONLINE
+DATA/hdls/indx07.dbf ONLINE
+DATA/hdls/hdls131701.dbf ONLINE
+DATA/hdls/hdls131702.dbf ONLINE
+DATA/hdls/hdls131703.dbf ONLINE
+DATA/hdls/hdls131704.dbf ONLINE
+DATA/hdls/hdls131705.dbf ONLINE
+DATA/hdls/hdls131706.dbf ONLINE
+DATA/hdls/cdc01.dbf ONLINE

35 rows selected.

SQL>

相关推荐