查看控制文件的存储路径

官方文档：​​V$CONTROLFILE (oracle.com)​​

SQL> select name from v$controlfile;

NAME
-----------------------------------------------------
+DATA/B19C0/CONTROLFILE/current.261.1113227175

查看日志文件存储路径

V$LOGFILE contains information about redo log files.包含关于redo log files 的信息。

官方文档：​​V$LOGFILE (oracle.com)​​

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
+DATA/B19C0/ONLINELOG/group_2.262.1113227179
+DATA/B19C0/ONLINELOG/group_1.263.1113227179
+DATA/B19C0/ONLINELOG/group_3.270.1113228729
+DATA/B19C0/ONLINELOG/group_4.271.1113228735

查看数据(表空间)文件的存储路径

官方文档：​​V$DATAFILE (oracle.com)​​

SQL> select name from v$datafile;

NAME
------------------------------------------------------------------------------------
+DATA/B19C0/E6E0D4F9C4A768BBE0533D00A8C0D97D/DATAFILE/system.314.1113477263
+DATA/B19C0/E6E0D4F9C4A768BBE0533D00A8C0D97D/DATAFILE/sysaux.292.1113477263
+DATA/B19C0/E6E0D4F9C4A768BBE0533D00A8C0D97D/DATAFILE/undotbs1.293.1113477263
+DATA/B19C0/E6E0D4F9C4A768BBE0533D00A8C0D97D/DATAFILE/default_tbs.285.1113479873
+DATA/B19C0/E6E0D4F9C4A768BBE0533D00A8C0D97D/DATAFILE/undo_2.282.1113481017
+DATA/B19C0/E6E0D4F9C4A768BBE0533D00A8C0D97D/DATAFILE/default_tbs.334.1114446509
+DATA/B19C0/E6E0D4F9C4A768BBE0533D00A8C0D97D/DATAFILE/test_tb.332.1114518211

7 rows selected.