如何查看數據庫的各種數據文件？
2024-07-21 02:39:15
供稿：網友
系統環境： 1、操作系統：windows 2000，機器內存128M
2、數據庫： Oracle 8i R2 (8.1.6) for NT 企業版
3、安裝路徑：C:/ORACLE
實現方法：
SQL> set pages 100
SQL> col file_name form a60
SQL> col name form a60
SQL> col member form a50
SQL> col m0 form 99999 heading "Size (Mb)"
SQL>
SQL> spool datafile.lst
SQL>
1、查看數據文件
SQL> select file_name,bytes/(1024*1024) m0 from dba_data_files;
FILE_NAME Size (Mb)
------------------------------------------------------------ ---------
C:/ORACLE/ORADATA/ORADB/USERS01.DBF 20
C:/ORACLE/ORADATA/ORADB/DR01.DBF 20
C:/ORACLE/ORADATA/ORADB/TOOLS01.DBF 10
C:/ORACLE/ORADATA/ORADB/INDX01.DBF 20
C:/ORACLE/ORADATA/ORADB/RBS01.DBF 70
C:/ORACLE/ORADATA/ORADB/TEMP01.DBF 20
C:/ORACLE/ORADATA/ORADB/SYSTEM01.DBF 236
已選擇7行。
2、查看控制文件
SQL> select NAME,status from v$controlfile;
NAME STATUS
------------------------------------------------------------ -------
C:/ORACLE/ORADATA/ORADB/CONTROL01.CTL
C:/ORACLE/ORADATA/ORADB/CONTROL02.CTL
C:/ORACLE/ORADATA/ORADB/CONTROL03.CTL
3、查看日志文件
SQL> select group#,member,status from v$logfile;
GROUP# MEMBER STATUS
---------- -------------------------------------------------- -------
1 C:/ORACLE/ORADATA/ORADB/REDO03.LOG STALE
2 C:/ORACLE/ORADATA/ORADB/REDO02.LOG
3 C:/ORACLE/ORADATA/ORADB/REDO01.LOG STALE
