查找oracle下的数据文件，控制文件和联机日志

1：数据文件：

SQL> select file#,status,enabled,name from v$datafile;

 

    FILE# STATUS  ENABLED      NAME

----------------------------------------------------------------

         1 SYSTEM  READ WRITE D:/Oracle/ORADATA/TEST/SYSTEM01.DBF

         2 ONLINE  READ WRITE D:/Oracle/ORADATA/TEST/RBS01.DBF

         3 ONLINE  READ WRITE D:/Oracle/ORADATA/TEST/USERS01.DBF

         4 ONLINE  READ WRITE D:/Oracle/ORADATA/TEST/TEMP01.DBF

         5 ONLINE  READ WRITE D:/Oracle/ORADATA/TEST/TOOLS01.DBF

         6 ONLINE  READ WRITE D:/Oracle/ORADATA/TEST/INDX01.DBF

2：控制文件：

SQL> select * from v$controlfile;

 

STATUS  NAME

---------------------------------------------------------------------

        D:/Oracle/ORADATA/TEST/CONTROL01.CTL

        D:/Oracle/ORADATA/TEST/CONTROL02.CTL

        D:/Oracle/ORADATA/TEST/CONTROL03.CTL

3：联机日志：

SQL> select * from v$logfile;

 

    GROUP# STATUS      MEMBER

---------------------------------------------------------------------

      1     STALE      D:/Oracle/ORADATA/TEST/REDO01.LOG

      2               D:/Oracle/ORADATA/TEST/REDO02.LOG

      3     STALE      D:/Oracle/ORADATA/TEST/REDO03.LOG