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.
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.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading