Taking a backup of an Oracle 8i database in Linux
I'm having some problems in taking a backup of my database. Can you let me know
how to take a backup in Linux for Oracle 8i? What is the location of my
datafiles, redo files and control files?
To take a cold backup, shut down your database and then copy your control files, online redo logs and database datafiles to a backup location or device using OS commands. Once backed up, start the database.
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.
This was first published in October 2005