Re: On-line backups

From: <chris_at_tisdec.tis.tandy.com>
Date: 09 Apr 93 14:40 CDT
Message-ID: <50300004_at_tisdec.tis.tandy.com>

/* Written 10:16 am Apr 7, 1993 by joefw_at_eosdev1.gsfc.nasa.gov in tisdec.tis.tandy.com:comp.databases.oracle */
/* ---------- "On-line backups" ---------- */
Is the following sequence okay for on-line backups of multiple tablespaces?:

SQLDBA

	CONNECT INTERNAL
	ALTER TABLESPACE TB1 BEGIN BACKUP 
	ALTER TABLESPACE TB2 BEGIN BACKUP 
	EXIT

(Do system dependent backup of database files associated with TB1 and TB2) SQLDBA

	CONNECT INTERNAL
	ALTER TABLESPACE TB1 END BACKUP 
	ALTER TABLESPACE TB2 END BACKUP 
	EXIT

Thanks.

Joe Fulson-Woytek
Code 902/Goddard DAAC
NASA/Goddard Space Flight Center
joefw_at_eosdev1.gsfc.nasa.gov
/* End of text from tisdec.tis.tandy.com:comp.databases.oracle */

This is the way that I doit on the system that I administer, except that I do that about three time.

chris_at_tisdec.tis.tandy.com Received on Fri Apr 09 1993 - 21:40:00 CEST