Q

Taking a backup of an Oracle 8i database in Linux

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?

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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close