Ramin Hossaini

Listing key Oracle Database files

Feb
16

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;

Leave a Reply

Your email address will not be published. Required fields are marked *