Fwd: Antw: Re: Multiple DBs vs Multiple instances

On not being able to restore a single database if multiple databases reside in a single instance... This is ALMOST true. If you are a careful and fastidious DBA and keep all of a single database segregated into its own dbspace(s) then you CAN restore just that one or few dbspace(s) effectively restoring a single database. Art S. Kagel ----- Original Message ----- From: Andreas.Kut.... <Andreas.KUTSCHE@spar.at> At: 3/14 5:20 ----LNX_Fri_Mar_14_2003_09:11:38_V3.33-- Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable >Datum: 2003.03.13 22:33:08 >Sender: Zev Berezin <zevb@bhphotovideo.com> > > Archive/Restore would be an issue. >Using multiple instances, would be a good method to archive a >single DB. On the other hand It would be cumbersome if you must >archive all the Production instances for Disaster recovery. > = I agree with that. If you have one instance you can't restore a single database (unless you take your backups with dbexport locking the database= s). You might be forced to restore the entire instance to another server and extract the needed older version of one database. That's certainly an issue. = On the other side you can provide more ressources (tmp dbspace, logicol logs space, locks, cpu vps etc.) with one big instance. In most situation= s not all applications have their peak loads at the same time. But if an application breaks all barriers (lock table overflow, exclusive= long transaction) all databases will suffer. = I don't advise to prefer one approach over the other. Some differences are a matter of personal preferences. = Regards, Andreas Kutsche = >HTH, >Zev Berezin >B&H Photo >> >>On 13 Mar 2003, at 12:57, Terrence Mu.... wrote: >> >> What are the pros/cons of have multiple databases in one instance as >> opposed to having multiple instances with just one database. ------------------------------------------------ SPAR Oesterreichische Warenhandels-AG Hauptzentrale Europastra=DFe 3 A-5015 Salzburg = Telefon : +43 662 4470 24423 E-Mail : Andreas.KUTSCHE@spar.at Internet: http://www.spar.at ------------------------------------------------ = ----LNX_Fri_Mar_14_2003_09:11:38_V3.33----