Issue/Symptom/Question

Need to make a 'cold' backup of a database.  

Applies To

Linux Server

Databases

Resolution/Fix/Answer

A 'Cold' backup means the database is not running while you back it up.

• Shutdown the database you wish to backup.
• Go to the directory where the database files are located.
  • The standard is under the /u02/app/oracle/oradata directory and under the /u03/app/oracle/flash_recovery_area directory.
  • Use the 'tar' command to create a condensed file of the database files. 

tar -czvf tarfilename.tgz  ORACLE_SID

i.e.  tar -czvf prod.tgz  PROD

• Restart the database