一. 查看数据文件
SQL> select name from v$datafile;
NAME
——————————————————–
/u01/app/oracle/oradata/orcl/SYSTEM01.DBF
/u01/app/oracle/oradata/orcl/UNDOTBS01.DBF
/u01/app/oracle/oradata/orcl/SYSAUX01.DBF
/u01/app/oracle/oradata/orcl/USERS01.DBF
二. 查看控件文件
SQL> select name from v$controlfile;
NAME
———————————————————-
/u01/app/oracle/oradata/orcl/CONTROL01.CTL
/u01/app/oracle/oradata/orcl/CONTROL02.CTL
/u01/app/oracle/oradata/orcl/CONTROL03.CTL
三. 查看日志文件
SQL> select member from v$logfile;
MEMBER
————————————————–
/u01/app/oracle/oradata/orcl/REDO03.LOG
/u01/app/oracle/oradata/orcl/REDO02.LOG
/u01/app/oracle/oradata/orcl/REDO01.LOG