-- 查看数据文件
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