Re: Backups

You do not have to shut the Oracle Database down to back it up. It has the capability of performing hot backups using a product you get with the RDBMS product. Depending on what version of Oracle you are currently working under, it will most likely be SQL*DBA but the newer versions will be using something simular. To perform the hot backup, all you need to do is to tell the database that you are backing the tablespaces up. This is done by using the alter tablespace command. ALTER TABLESPACE [tablespace name] BEGIN BACKUP; copy the file to a disk or other medium, then ALTER TABLESPACE [tablespace name] END BACKUP;

Keep in mind that it is best to use this in conjunction with archive mode. Received on Sat Jul 15 1995 - 00:00:00 CEST