Q

OS commands for copying files to a backup location

Can you please give me the OS commands to copy my files to my backup location? I am trying to do a cold backup on three servers on which I have Oracle Collaboration Suite 10g installed.

Can you please give me the OS commands to copy my files to my backup location?

I am trying to do a cold backup on three servers on which I have Oracle Collaboration Suite 10g installed, and before doing anything I want to do a cold backup to be able to easily recover my installation in case something happens.

My operating system is Linux Red Hat 4.

First, you'll have to shut down your database as follows:

sqlplus /nolog
connect / as sysdba
shutdown immediate
exit

At that point, you will simply copy the database files with the cp command as follows:

cd /backupdir
cp /sourcedir/file 

Repeate the cp command for each file. When performing a cold backup, you should copy all files listed in the DBA_DATA_FILES, V$LOGFILE and V$CONTROL_FILES views. So query these views before you shut down the database so you do not miss any important database files.

This was first published in September 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