Ask the Expert

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: