RE: NetApp (was utl_file_dir)

I will agree that both TEMP and INDEX are "easy" to rebuild. You sure that they don't require you to backup RBS? It is not easy to rebuild it at all! :D

Winnie

Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>@fatcity.com = on
12/04/2000 03:45:26 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Subject: RE: NetApp (was utl_file_dir)

NetApp is suggesting that the DBA doesn't have to backup the RBS, TEMP = and
INDEX tablespace. The "logic" behind that assumption is that one could easily re-create those tablespaces rather than backing them up everytim= e.
The Snapshot utility is generally pushed/prostituted in business environments (like in VLDB) in which backups must be fast and take up l= ess
space.

Regards,
Satar

PS My suggestions/comments are the result of the voices of my head only= ,
and do not represent NetApp Corp.

   -----Original Message-----
   From:=A0=A0 Suzy Vordos [SMTP:lvordos_at_datsit.com]    Sent:=A0=A0 Monday, December 04, 2000 10:11 PM    To:=A0=A0=A0=A0 Multiple recipients of list ORACLE-L    Subject:=A0=A0=A0=A0=A0=A0=A0 Re: NetApp (was utl_file_dir)

   Still working on the backup strategy and haven't tried a snapshot    restore yet.=A0 But, for the database files, you do need to put the    tablespaces in backup mode before taking a snapshot.=A0=A0 I mention=  this
   because of the impression I got from talking to different people fro= m

   NetApp.

   I was told that because snapshots are a read-only image of blocks on=  the
   volume, you could simply schedule snapshots and restore from them at=  any
   time.=A0 No mention of putting tablespaces in backup mode, or the im= pacts

   of snaprestore on the database.

   Okay, the snapshot feature is pretty slick, but in my mind that does= n't

   change basic Oracle backup and recovery concepts.=A0 Hot backups req= uire

   the tablespaces be in backup mode, cold backups require the database=  be
   down.=A0 Why would NetApp snapshots make this any different??

   The backup strategy I'm implementing follows    http://www.netapp.com/tech_library/3049.html, which explains the    tablespaces are put in backup mode, snapshot taken, tablespaces out = of

   backup mode.=A0 Although it does puzzle me why they suggest certain    tablespaces can be excluded, seems that would make recovery a little=

   more challenging.

   I'd be interested in hearing about the backup strategies other peopl= Received on Mon Dec 04 2000 - 18:54:07 CST