Re: Online or Offline Backup

From: Darrell L Carden <dlcarden_at_buckman.com>
Date: Sun, 29 Nov 1998 01:35:17 -0600
Message-ID: <73qqti$l49$2@news.socomm.net>

There is a sample script that dynamically builds and executes a hot backup at www.midsoug.org. Choose "Technical Articles", then "Dynamic Hot Backup Process".

Offline backups (aka cold backups) are performed with the database down. Online backups (aka cold backups) are taken with the database up and is necessary in 24x7 shops. I like to take a complete snapshot (cold backup) whenever I can, with hot backups in between. You must be in archivelog mode to use hot backups (which you should be running in all production systems anyway).

Good luck! Received on Sun Nov 29 1998 - 01:35:17 CST