Oracle View data files, control files, and log file commands

I. Viewing data files
Sql> select name from V$datafile;

NAME
--------------------------------------------------------
D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSTEM01. Dbf
D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\UNDOTBS01. Dbf
D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSAUX01. Dbf
D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\USERS01. Dbf
D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\EXAMPLE01. Dbf

Two. View Control files

Sql> select name from V$controlfile;

NAME
----------------------------------------------------------
D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\CONTROL01. Ctl
D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\CONTROL02. Ctl
D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\CONTROL03. Ctl

Three. View Log files

Sql> Select member from V$logfile;

MEMBER
--------------------------------------------------
D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO03. LOG
D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO02. LOG
D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO01. LOG

Sql> Select member from V$logfile;

MEMBER
--------------------------------------------------
D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO03. LOG
D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO02. LOG
D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO01. LOG

This article from "Unrivaled Jia Yuan" blog, reproduced please contact the author!

Oracle View data files, control files, and log file commands