RE: Tablespace Backup question

sean.hull_at_pobox.com wrote:

>It places the underlying datafiles of the tablespace in a frozen state,
>that is Oracle will not write to these files while in hotbackup mode

Actually, no. Oracle continues to write to the file *exactly* the same when in hot-backup mode, with the exception of the checkpoint SCN. Also, full blocks (not change vectors) are written to the redo log. You can find more details about this at various web sites or in Velpuri's Backup Handbook. Not sure if it's discussed in the Oracle Docs.

Colin.

-----Original Message-----
From: sean.hull_at_pobox.com [mailto:sean.hull_at_pobox.com] Sent: Monday, June 05, 2000 1:45 PM
To: Multiple recipients of list ORACLE-L Subject: Re: Tablespace Backup question

On Fri, 2 Jun 2000, Mayan Cheriya wrote:

> I have a small basic question. If I say
> Alter Tablespace 't.s name' Begin Backup, where is
> this
> backup getting stored. Is there any init.ora
> parameter which controls this one. couldn't
> find anything in the manual.

Mayan:

You need to do some reading in the Backup and Recovery manual, and concepts manual. This command does not back anything up. It places the underlying datafiles of the tablespace in a frozen state, that is Oracle will not write to these files while in hotbackup mode. You have to do the work of backing up the file while it's in this mode. You can use an OS command like cp (or dd if you're using raw I/O). Copy the datafiles to another disk, or to tape, then take the tablespace out of backup mode.

Sean

-- 
Author: 
  INET: sean.hull_at_pobox.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).