一. 查看数据文件
SQL> select name from v$datafile;
NAME ----------------------------------------
C:\APP\APPLE3\ORADATA\ORCL\SYSTEM01.DBF C:\APP\APPLE3\ORADATA\ORCL\SYSAUX01.DBF C:\APP\APPLE3\ORADATA\ORCL\UNDOTBS01.DBF C:\APP\APPLE3\ORADATA\ORCL\USERS01.DBF C:\APP\APPLE3\ORADATA\ORCL\EXAMPLE01.DBF
二. 查看控件文件
SQL> select name from v$controlfile;
NAME ---------------------------------------------------------- C:\APP\APPLE3\ORADATA\ORCL\CONTROL01.CTL C:\APP\APPLE3\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL
三. 查看日志文件
SQL> select member from v$logfile;
MEMBER -------------------------------------------------- C:\APP\APPLE3\ORADATA\ORCL\REDO03.LOG C:\APP\APPLE3\ORADATA\ORCL\REDO02.LOG C:\APP\APPLE3\ORADATA\ORCL\REDO01.LOG