On-line backups

From: Joe Fulson-Woytek <joefw_at_eosdev1.gsfc.nasa.gov>
Date: Wed, 7 Apr 1993 15:16:53 GMT
Message-ID: <C54D48.MBF_at_skates.gsfc.nasa.gov>

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

Or do you have to do each tablespace separately; eg: SQLDBA

	CONNECT INTERNAL
	ALTER TABLESPACE TB1 BEGIN BACKUP 
	EXIT

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

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

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

	CONNECT INTERNAL
	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 Received on Wed Apr 07 1993 - 17:16:53 CEST