Ramin Hossaini (blog)

Listing key Oracle Database files

To get a list of all datafiles, redo-log files and control-files, run the following in SQL*Plus (database must be mounted):

1
2
3

SELECT MEMBER FROM V$LOGFILE;
SELECT NAME FROM V$DATAFILE;
SELECT VALUE FROM V$PARAMETER WHERE NAME = 'control_files';

An easier way of displaying your control-files is:

1

SHOW PARAMETER control_files;

Related posts:

1. Oracle: List all database-links
2. Basic Auditing in Oracle
3. Backing up an Oracle database without RMAN
4. Enabling Trace
5. Turning Archive-log mode on and off