ORACLE查看数据文件, 控制文件及日志文件

-- 查看数据文件

SQL> select name from v$datafile;

NAME
---------------------------------------------
C:\ORACLE\ORADATA\MYORA1\SYSTEM01.DBF
C:\ORACLE\ORADATA\MYORA1\UNDOTBS01.DBF
C:\ORACLE\ORADATA\MYORA1\CWMLITE01.DBF
C:\ORACLE\ORADATA\MYORA1\DRSYS01.DBF
C:\ORACLE\ORADATA\MYORA1\EXAMPLE01.DBF
C:\ORACLE\ORADATA\MYORA1\INDX01.DBF
C:\ORACLE\ORADATA\MYORA1\ODM01.DBF
C:\ORACLE\ORADATA\MYORA1\TOOLS01.DBF
C:\ORACLE\ORADATA\MYORA1\USERS01.DBF
C:\ORACLE\ORADATA\MYORA1\XDB01.DBF

已选择10行。

 

-- 查看控制文件

SQL> select name from v$controlfile;

NAME
---------------------------------------------
C:\ORACLE\ORADATA\MYORA1\CONTROL01.CTL
C:\ORACLE\ORADATA\MYORA1\CONTROL02.CTL
C:\ORACLE\ORADATA\MYORA1\CONTROL03.CTL

 

-- 查看重做日志文件

SQL> select member from v$logfile;

MEMBER
---------------------------------------------
C:\ORACLE\ORADATA\MYORA1\REDO03.LOG
C:\ORACLE\ORADATA\MYORA1\REDO02.LOG
C:\ORACLE\ORADATA\MYORA1\REDO01.LOG