======================================================= Oracle: noarchivelog mode physical backup ======================================================= :Title: Oracle: noarchivelog mode physical backup :Author: Douglas O'Leary <dkoleary@olearycomputers.com> :Description: Oracle: noarchivelog mode physical backup :Date created: 07/20/2010 :Date updated: 07/20/2010 :Disclaimer: Standard: Use the information that follows at your own risk. If you screw up a system, don't blame it on me... Process to follow to create a cold backup of an oracle database in noarchivelog mode #. Shutdown the database #. Copy all database datafiles, control files, and online redo logs #. Restart the database Pretty straight forward. Obvious drawbacks are no online backups and no point in time backups - unless you consider when the backup was done as the point in time...