Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Backup Solutions
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFE2DC.451EEB80
Content-Type: text/plain;
charset="windows-1252"
It will do a self discovery of any db you ask it to, and will rediscover said db each time you back it up there-after.
Cost is around +-5k for a 50g db, maybe +-10k for a 100g db. All things are negotiable based on volume, etc.
Features:
Various DB's to include Oracle; Most UNIX's and NT; Parallel backup threads; Supports Oracle Parallel Server; Backup to disk, tape, or tape juke box (via OBSI to a juke box manager); On the fly compression of backups; Aging / Retention; An almost auto recovery 99% of the time (ask it to recover a db, it check it, reports what it is going to do, and you hit enter to okay it); Allows for Export, Hot, Cold, Control File, Init.Ora, and Archive backups; Understands the oracle block structure so you can do things like: Single table extraction from a hot/cold backup; Fast begin/end tablespace hot backups; Incremental backups; Allows you to test recovery from backups without actually overlaying anything; Supports raw disk (again the Oracle Parallel Server);
Blah, Blah, Blah (I should get paid for writing this, or at least a free t-shirt or something).
Brian P. Mac Lean
Senior Oracle Database Administrator
OCPv8/Oracle Master
HomeBid.Com
8700 N. Gainey Center Drive
Scottsdale, AZ 85258
Tel:480.609.4624 Cel:602.617.6075 Fax:480.609.4646 Net:brian.maclean_at_homebid.com
-----Original Message-----
From: David Lee [mailto:dba_lee_at_hotmail.com]
Sent: Friday, June 30, 2000 8:05 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Backup Solutions
Brian,
Thanks for the reply.
I am definitely interested. I have couple of more questions:
Are they easy to set up?
How much does it cost?
Thanks again
David
>From: Brian MacLean <bmaclean_at_homebid.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Backup Solutions
>Date: Thu, 29 Jun 2000 15:56:25 -0800
>
>One product, multiple platforms, multiple DB's, and in my opinion the best
>solution is SQL-BackTrack. I've played with EBU, RMAN, and KSH to do
>backups and I always come back to it. If you need more info call me.
>
>http://www.bmc.com/products/prod_directory.html#S
>
>http://www.bmc.com/products/proddocview.html?id=1059&r=Americas&l=en
>
>
>If you need more info call me.
>
>Brian P. Mac Lean
>Senior Oracle Database Administrator
>OCPv8/Oracle Master
>HomeBid.Com
>8700 N. Gainey Center Drive
>Scottsdale, AZ 85258
>Tel:480.609.4624
>Cel:602.617.6075
>Fax:480.609.4646
>Net:brian.maclean_at_homebid.com
>
>
>
>
>
>-----Original Message-----
>Sent: Thursday, June 29, 2000 10:31 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Howdy,
>We are looking for a good exterprise database backup strategy. Our shop
>is fairly new and new databases are set up on a monthly basis and they
>are growing rapidly. Right now we are using shell scripts to schedule
>backups and I am not sure if this is a good long-term solution for us
>because we have to set it up for each database and it becomes a hassle
>when you have to verfify the new backups. We need something more
>centralized, easier to setup and verify.
>So I just want to know what other DBAs are using to backup their data.
>
>TIA
>
>David
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>--
>Author: David Lee
> INET: dba_lee_at_hotmail.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).
-- Author: David Lee INET: dba_lee_at_hotmail.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). ------_=_NextPart_001_01BFE2DC.451EEB80 Content-Type: text/html; charset="windows-1252" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dwindows-1252"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: Backup Solutions</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2 FACE=3D"Arial">It will do a self discovery of any db = you ask it to, and will rediscover said db each time you back it up = there-after. </FONT></P> <P><FONT SIZE=3D2 FACE=3D"Arial">Cost is around +-5k for a 50g = db, maybe +-10k for a 100g db. All things are negotiable = based on volume, etc.</FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial">Features:</FONT> <BR> <FONT SIZE=3D2 = FACE=3D"Arial">Various DB's to include Oracle;</FONT> <BR> <FONT SIZE=3D2 = FACE=3D"Arial">Most UNIX's and NT;</FONT> <BR> <FONT SIZE=3D2 = FACE=3D"Arial">Parallel backup threads;</FONT> <BR> <FONT SIZE=3D2 = FACE=3D"Arial">Supports Oracle Parallel Server;</FONT> <BR> <FONT SIZE=3D2 = FACE=3D"Arial">Backup to disk, tape, or tape juke box (via OBSI to a = juke box manager);</FONT> <BR> <FONT SIZE=3D2 = FACE=3D"Arial">On the fly compression of backups;</FONT> <BR> <FONT SIZE=3D2 = FACE=3D"Arial">Aging / Retention;</FONT> <BR> <FONT SIZE=3D2 = FACE=3D"Arial">An almost auto recovery 99% of the time (ask it to = recover a db, it check it, reports what it is going to do, and you hit = enter to okay it);</FONT></P> <P> <FONT SIZE=3D2 = FACE=3D"Arial">Allows for Export, Hot, Cold, Control File, Init.Ora, = and Archive backups;</FONT> <BR> <FONT SIZE=3D2 = FACE=3D"Arial">Understands the oracle block structure so you can do = things like:</FONT> <BR> = <FONT SIZE=3D2 = FACE=3D"Arial">Single table extraction from a hot/cold backup;</FONT> <BR> = <FONT SIZE=3D2 = FACE=3D"Arial">Fast begin/end tablespace hot backups;</FONT> <BR> = <FONT SIZE=3D2 = FACE=3D"Arial">Incremental backups;</FONT> <BR> <FONT SIZE=3D2 = FACE=3D"Arial">Allows you to test recovery from backups without = actually overlaying anything;</FONT> <BR> <FONT SIZE=3D2 = FACE=3D"Arial">Supports raw disk (again the Oracle Parallel = Server);</FONT> <BR> =20 </P> <BR> <P><FONT SIZE=3D2 FACE=3D"Arial">Blah, Blah, Blah (I should get paid = for writing this, or at least a free t-shirt or something).</FONT> </P> <BR> <BR> <P><B><FONT COLOR=3D"#0000FF" FACE=3D"Comic Sans MS">Brian P. Mac = Lean</FONT></B> <BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Comic Sans MS">Senior = Oracle Database Administrator</FONT> <BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Comic Sans = MS">OCPv8/Oracle Master</FONT> <BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Comic Sans = MS">HomeBid.Com</FONT> <BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Comic Sans MS">8700 N. = Gainey Center Drive</FONT> <BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Comic Sans MS">Scottsdale, = AZ 85258</FONT> <BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Comic Sans = MS">Tel:480.609.4624</FONT> <BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Comic Sans = MS">Cel:602.617.6075</FONT> <BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Comic Sans = MS">Fax:480.609.4646</FONT> <BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Comic Sans = MS">Net:brian.maclean_at_homebid.com</FONT> </P> <BR> <P><FONT SIZE=3D2 FACE=3D"Arial">-----Original Message-----</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">From: David Lee [<A = HREF=3D"mailto:dba_lee_at_hotmail.com">mailto:dba_lee_at_hotmail.com</A>]</FON= T> <BR><FONT SIZE=3D2 FACE=3D"Arial">Sent: Friday, June 30, 2000 8:05 = AM</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">To: Multiple recipients of list = ORACLE-L</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Subject: RE: Backup Solutions</FONT> </P> <BR> <P><FONT SIZE=3D2 FACE=3D"Arial">Brian,</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Thanks for the reply.</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">I am definitely interested. I have = couple of more questions:</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Are they easy to set up?</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">How much does it cost?</FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial">Thanks again</FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial">David</FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial">>From: Brian MacLean = <bmaclean_at_homebid.com></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>Reply-To: = ORACLE-L_at_fatcity.com</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>To: Multiple recipients of list = ORACLE-L <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>Subject: RE: Backup = Solutions</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>Date: Thu, 29 Jun 2000 15:56:25 = -0800</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>One product, multiple platforms, = multiple DB's, and in my opinion the best</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>solution is SQL-BackTrack. = I've played with EBU, RMAN, and KSH to do</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>backups and I always come back to = it. If you need more info call me.</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">><A = HREF=3D"http://www.bmc.com/products/prod_directory.html#S" = TARGET=3D"_blank">http://www.bmc.com/products/prod_directory.html#S</A><= /FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">><A = HREF=3D"http://www.bmc.com/products/proddocview.html?id=3D1059&r=3DAmeri= cas&l=3Den" = TARGET=3D"_blank">http://www.bmc.com/products/proddocview.html?id=3D1059= &r=3DAmericas&l=3Den</A></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>If you need more info call = me.</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>Brian P. Mac Lean</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>Senior Oracle Database = Administrator</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>OCPv8/Oracle Master</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>HomeBid.Com</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>8700 N. Gainey Center = Drive</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>Scottsdale, AZ 85258</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>Tel:480.609.4624</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>Cel:602.617.6075</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>Fax:480.609.4646</FONT> <BR><FONT SIZE=3D2 = FACE=3D"Arial">>Net:brian.maclean_at_homebid.com</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>-----Original Message-----</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>Sent: Thursday, June 29, 2000 = 10:31 AM</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>To: Multiple recipients of list = ORACLE-L</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>Howdy,</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>We are looking for a good = exterprise database backup strategy. Our shop</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>is fairly new and new databases = are set up on a monthly basis and they</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>are growing rapidly. Right now we = are using shell scripts to schedule</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>backups and I am not sure if this = is a good long-term solution for us</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>because we have to set it up for = each database and it becomes a hassle</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>when you have to verfify the new = backups. We need something more</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>centralized, easier to setup and = verify.</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>So I just want to know what other = DBAs are using to backup their data.</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>TIA</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>David</FONT> <BR><FONT SIZE=3D2 = FACE=3D"Arial">>_____________________________________________________= ___________________</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>Get Your Private, Free E-mail = from MSN Hotmail at <A HREF=3D"http://www.hotmail.com" = TARGET=3D"_blank">http://www.hotmail.com</A></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>--</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>Author: David Lee</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> INET: = dba_lee_at_hotmail.com</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>Fat City Network = Services -- (858) 538-5051 FAX: (858) = 538-5051</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2 = FACE=3D"Arial">>-----------------------------------------------------= ---------------</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>To REMOVE yourself from this = mailing list, send an E-Mail message</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>to: ListGuru_at_fatcity.com (note = EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>the message BODY, include a line = containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>(or the name of mailing list you = want to be removed from). You may</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">>also send the HELP command for = other information (like subscribing).</FONT> </P> <P><FONT SIZE=3D2 = FACE=3D"Arial">_________________________________________________________= _______________</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Get Your Private, Free E-mail from = MSN Hotmail at <A HREF=3D"http://www.hotmail.com" = TARGET=3D"_blank">http://www.hotmail.com</A></FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Author: David Lee</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial"> INET: = dba_lee_at_hotmail.com</FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial">Fat City Network = Services -- (858) 538-5051 FAX: (858) = 538-5051</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2 = FACE=3D"Arial">---------------------------------------------------------= -----------</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">To REMOVE yourself from this mailing = list, send an E-Mail message</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru') and in</FONT>Received on Fri Jun 30 2000 - 16:43:40 CDT