Message-Id: <10700.123603@fatcity.com> From: Winnie_Liu@infonet.com Date: Mon, 4 Dec 2000 16:54:07 -0800 Subject: 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 @fatcity.com = on 12/04/2000 03:45:26 PM Please respond to ORACLE-L@fatcity.com Sent by: root@fatcity.com To: Multiple recipients of list ORACLE-L 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@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=