Ryn,

I know nothing about the VxFS/UFS snapshot utlities,
but from a backup standpoint, other than using RMAN,
the only way a valid backup can be taken with the
database up and running is to put the tablespaces in
backup mode before the datafiles, or the filesystems
on which they reside, are copied.

If this is similar to a disk split, for example, you
can restore the split and open the database because
this is essentially the same case as starting up a db
after a shutdown abort and SMON will do instance
recovery.  This is NOT a valid backup, however, and
attempting to do media recovery and apply archived
logs will write warnings to the alert.log that you are
attempting to recover from a fuzzy backup and the db
will not open.

HTH,

--Anita

--- Ryn <[EMAIL PROTECTED]> wrote:
> Hello folks,
> 
> We are looking into the VxFS/UFS snapshot utlities,
> and I am curious how you can
> quiesce an Oracle instance? I would like all changes
> to the buffer cache to be
> flushed
> to the file system and checkpoints to occur. What
> would I need to run to do
> this? I
> assume this would give the file system a consistent
> view of the database. We are
> going
> to play with this in our test environment.
> 
> Thanks for any info,
> 
> - Ryn


__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to