Re: Another crazy hot backup theory in a book

Well, it is true. When you are running a hot tablespace backup, any changes to that tablespace is in the redo log buffer (which is part of the SGA) until the END backup is issued. However, the passage that you quoted never tells the user that he/she must be running in Archive Mode. Maybe it does, but I will never pay money for a book that says that you can learn oracle in 21 days!!! Thanks for looking out for everyone...

In article <Pine.OSF.3.95.980923215727.10554B-100000_at_gonzo.wolfenet.com>,   Jeremiah Wilton <jeremiah_at_wolfenet.com> wrote:
>
> 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
>
>

--
Satar Naghshineh
Oracle DBA/ UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle,

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Sep 24 1998 - 11:24:11 CDT