This Content Component encountered an error

Oracle on Linux tips, tutorials and expert advice

Backup and recovery of Oracle data on Linux <<previous|next>> :Scheduling backup jobs in Linux

Oracle database backup and recovery

Taking a backup of an Oracle 8i database in Linux

Taking a backup of an Oracle 8i database in Linux

By  Brian Peasland, Database Administrator, SGT, Inc.

SearchOracle.com

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.

05 Oct 2005