Another crazy hot backup theory in a book

I also found this passage in "Teach Yourself Oracle8 in 21 Days." I don't think it is correct at all. Once again, everything seems fine until you get to the last paragraph, then it all starts to get very shaky. I guess that's what I get for trying to learn "Oracle8 in 21 Days."

From Teach Yourself Oracle8 in 21 Days (SAMS Pub.) by Ed Whalen ISBN: 0672311593

• begin citation/

Online Backup

The online backup is not actually a full backup because each tablespace is backed up separately. You can think of it as a set of online tablespace backups that make up the entire database. To perform an online tablespace backup, follow this procedure:

1. Mark the beginning of the tablespace backup using the SQL command

ALTER TABLESPACE tsname BEGIN BACKUP;

2. Back up the datafiles that constitute that tablespace using OS or third-party utilities.

3. Mark the end of the tablespace backup using the SQL command

ALTER TABLESPACE tsname END BACKUP;

When you mark the beginning of the backup, Oracle will divert writes from those datafiles to the SGA until the backup has completed and you have marked the end of the backup. This is all that is necessary to perform the online tablespace backup.

• end citation/

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Thu Sep 24 1998 - 00:02:33 CDT