Oracle on Linux tips, tutorials and expert adviceBackup and recovery of Oracle data on Linux <<previous|next>> :Scheduling backup jobs in Linux
Taking a backup of an Oracle 8i database in Linux
To find your control files, issue the following command:
SELECT name FROM v$controlfile;To find your online redo log files, issue the following command:
SELECT member FROM v$logfile;To find your database datafiles, issue the following command:
SELECT file_name FROM dba_data_files;The database must be opened for all of the above to run successfully, so perform these queries before you shut down the database.
05 Oct 2005