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
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-HillReceived on Tue Nov 14 1995 - 00:00:00 CET