[prev in list] [next in list] [prev in thread] [next in thread] 

List:       veritas-ha
Subject:    Re: [Veritas-ha] stopping monitoring a resource for a certain period
From:       Doug Hughes <doug () will ! to>
Date:       2007-03-01 21:18:52
Message-ID: 45E7433C.8080401 () will ! to
[Download RAW message or body]

JV wrote:
> I'm no expert, but isn't 
>
> /opt/VRTS/bin/hares -offline <sg> -sys <hostname>
>
> what you want to do? In the body of the sg start/stop script, I just
> call the $ORACLE_HOME/bin/dbshut (immediate).
>
> I'll offer my opinion on oracle hotbackup - it's an extra layer of
> complication, it requires extra tablespace (storage), it decreases the
> oracle instance performance during the hotbackup window, and I couldn't
> get a commitment that ALL the DBAs would use it in 100% of cases... so
> why do I want "special handling for 1 or 2 $SIDs? It's more supportable
> to go with cold backups and vxfs/ufs/netapp/emc snapshots in my case,
> 10 mins of downtime was acceptable, but YMMV.
>
> JV711
>
>   
Veritas DBED provides a nice mechanism to do it using just regular 
online backup mode (it sets all tablespaces into online backup mode and 
takes them out when done). I used to do that, create a checkpoint, 
detach a mirror, mount the filesystem, then take the backup of the 
checkpoint and undo it all. (combined with VVR).

There's more than one way to do it without resorting to taking the DB 
offline. ymmv.

_______________________________________________
Veritas-ha maillist  -  Veritas-ha@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-ha
[prev in list] [next in list] [prev in thread] [next in thread]