Oracle Database Files

This is a handy script to retrieve Database File Lists.


 select name from v$datafile
 union
 select name from v$controlfile
 union
 select member from v$logfile;


Output:


 NAME
-----------------------------------
/ababildatafs/ABABIL_AUDIT_TS.DBF
/ababildatafs/ABABIL_DATA_TS01.DBF
/ababildatafs/ABABIL_DATA_TS02.DBF
/ababildatafs/ababil_data_ts03.dbf
/ababildatafs/ababil_data_ts04.dbf
/ababilimagefs/ABABIL_IMAGE_TS01.DBF
/ababilimagefs/ABABIL_IMAGE_TS02.DBF
/controlbkp/ABABIL_CONTROL03.CTL
/database/ababil/ABABIL_CONTROL01.CTL
/database/ababil/ABABIL_CONTROL02.CTL
/database/ababil/ABABIL_REDO01.LOG
/database/ababil/ABABIL_REDO02.LOG
/database/ababil/ABABIL_REDO03.LOG
/database/ababil/ABABIL_UNDO_TS01.DBF
/database/ababil/sysaux01.dbf
/database/ababil/system01.dbf
/database/ababil/users.dbf
/indexfs/ABABIL_INDEX_TS01.DBF
/indexfs/ABABIL_INDEX_TS02.DBF

Thanks
A Rahim Khan

Advertisements
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: