Re: Online backups on NT? How?

To perform an on-line backup you must set a tablespace into "backup mode" by issuing "Alter tablespace <tablespacename> begin backup;". Then do your OS backup of the data files for that tablespace. Then activate the tablespace by issuing "Alter tablespace <tablespacename> end backup;". You have to do this for each tablespace. There is third party backup software that automates this procedure. One is ArcServe. It has an add-in agent for Oracle that will do the on-line backup commands for you, rather than you having to write some script to do it.

Dave

Nuno Souto wrote:

> NT doesn't allow backups of files currently opened by a process. Given
> that even dropping an entire tablespace still doesn't free up the files
> from the ORACLEserver process, how can we do on-line backups in NT? Is
> there a third-party backup that will do it no matter what? V7.3.
>
> Thanx in advance.
>
> --
> Cheers
> Nuno Souto
> D.C.S. P/L
> e-mail: nsouto_at_acay.com.au
Received on Thu Sep 10 1998 - 09:16:08 CDT