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 Content Component encountered an error
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.