RE: Shadow Image....
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <cjpengel.dbalert@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 8 Oct 2004 14:57:01 -0400
Carel-Jan, It's interesting that Oracle provided this enhancement. The message I thought I was hearing (with the introduction of RMAN, and then with the requirement to use RMAN if you go w/ ASM), was that conventional backups were *eventually* going away. Perhaps the rumors of the conventional backup's demise have been a bit exaggerated..... -Mark -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Carel-Jan Engel Sent: Friday, October 08, 2004 2:48 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Shadow Image.... And with 10g, you can use 'alter DATABASE begin backup' :-) >From alertl10g.log: Fri Oct 8 20:31:38 2004 alter database begin backup Completed: alter database begin backup Fri Oct 8 20:31:51 2004 alter database end backup Completed: alter database end backup Best regards, Carel-Jan Engel =3D=3D=3D If you think education is expensive, try ignorance. (Derek Bok) =3D=3D=3D On Fri, 2004-10-08 at 18:50, John Kanagaraj wrote:=20 > Manish, >=20 > >Has any one of you configured a workable solution using=20 > >Hitachi shadow image and 9205 for duplicate database creation? I am > looking for=20 > >some reference on doing it without putting the source database in hot > backup mode? >=20 > Regardless of whether you use Hitachi ShadowImage or EMC SnapCopy (or > similar), you _will_ need to place the whole Database in Hot Backup = mode > prior to splitting the mirror. There is a definite time period between = start > to finish of the various behind-the-scenes operations and any DB level > changes that occur during this period would otherwise result in a = fuzzy > backup that can be avoided only by a Hot backup. In any case, the = whole > point of using a ShadowImage is to reduce the time taken to backup an = online > database while the tablespaces are in hot backup mode (which otherwise = would > lead to a large amount of redo generation). Sorry buddy - needs to be = done! > [And we have been using this for a 300Gb Apps database for the past 4 = years > with no issues - one of my fellow DBAs did try a non-hotbackup = recovery test > and ended up with fuzzy files]. >=20 > Hth, > John Kanagaraj <>< > DB Soft Inc > Phone: 408-970-7002 (W) >=20 > Fear connects you to the Negative, but Faith connects you to the = Positive! I > Jn 4:18 >=20 > ** The opinions and facts contained in this message are entirely mine = and do > not reflect those of my employer or customers ** > -- > http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l