Re: backup versus export of db

From: Phillip D. Jackson <delphi_at_mail.iag.net>
Date: 1995/11/14
Message-ID: <48b662$aug_at_news.iag.net>#1/1


The third party is indeed correct and if an O/S tool is used outside of Oracle the backup is indeed worthless. But a hot backup can be done while these files are open. From within SQLDBA, issue the following:

     ALTER TABLESPACE tablespacename BEGIN BACKUP;
     Then use an O/S backup utilitly to backup all files belonging to 
       this tablespace.
     ALTER TABLESPACE tablespacename END BACKUP;

  Repeat for each tablespace.

Also you might want to get a copy of

      Rama Velpuri's
      Oracle:  Backup & Recovery Handbook, Oracle Press, 
      Osborne-McGraw-Hill
Received on Tue Nov 14 1995 - 00:00:00 CET

Original text of this message