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. Backing up an Oracle database without RMAN
2. Oracle: List all database-links
3. Basic Auditing in Oracle
4. Oracle: Forcing a checkpoint
5. Oracle: Recycle listener.log