SQL Script Database Datafile Listing

Updated: 01-Jun-1998
Version: 1.0

Description

This script lists all the database datafiles, control files and redo log files which make up the database. 

This list is a definitive list of the files to be copied in a full cold database backup. This script could easily be modified to automate a cold database backup.

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

set pages 100 
col file_name form a60
col name form a60
col member form a50
col m0 form 99999 heading "Size (Mb)"

spool datafile.lst

select file_name,bytes/(1024*1024) m0 from dba_data_files;
select NAME,status from v$controlfile;
select group#,member,status from v$logfile;

spool off

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links