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

  1. Shutdown the database
  2. Copy all database datafiles, control files, and online redo logs
  3. 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...