RE: Converting from physical to logical standby

Thanks.

RE
> converting PSB to LSB is not possible.
What about creating LSB from scratch... Can it be done without making the primary inaccessible?

Follow up question... Anyone have much experience with LSB vs PSB? I know PSB performs better but is LSB just as dependable? If performance is okay with LSB is it otherwise just as good as PSB?

Performing a full export on the primary could impact performance but could be quite suitable on a standby. One possible advantage of LSB is that you don't have to toggle the recovery/database open status.

Other thoughts on PSB vs. LSB? Any reason whatsoever not to perform RMAN backups on the standby?

Standing by...
Steve Orr

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Carel-Jan Engel Sent: Tuesday, September 28, 2004 11:58 PM To: DWILLIAMS_at_LIFETOUCH.COM
Cc: 'oracle-l_at_freelists.org '
Subject: RE: Converting from physical to logical standby

Steve,
For 9iR2 I attempted to extend my instatiate scripts for Physical Standby (PSB) with Logical Standby (LSB) capabilities. It actually worked, using vanilla hot backups.....4 out of 5 times. The quiesce database is still needed, although it didn't take too long. So, no major outage/standstill was needed. But, a real instantiation 'on the fly' is not possible. AFAIK converting PSB to LSB is not possible.=20

Whenever the script failed, for no obvious reason the next run went OK most of the times. I haven't put too much effort into solving this, because of the instability and restrictions of LSB, and lack of demand for LSB. I'm a poor self-employed contractor ;-)

Best regards,

Carel-Jan Engel

=3D=3D=3D
If you think education is expensive, try ignorance. (Derek Bok) = =3D=3D=3D=20

On Tue, 2004-09-28 at 19:02, DENNIS WILLIAMS wrote:=20

Steve - In answer to question #2, Robert Freeman on page 417 of Oracle9i RMAN Backup & Recovery says "RMAN backups cannot be used to create a logical Standby database, because RMAN cannot quiesce a database". =20
Dennis Williams
DBA
Lifetouch, Inc.

--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l