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?

    Requires Free Membership to View

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top