Re: Backups

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Sun, 09 Dec 2001 22:48:56 -0800
Message-ID: <F001.003D8933.20011209222521@fatcity.com>

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 <matty91_at_bellsouth.net> 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: abardeen1_at_yahoo.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).

Received on Mon Dec 10 2001 - 00:48:56 CST