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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Carel-Jan Engel
Sent: Tuesday, September 28, 2004 11:58 PM
To: DWILLIAMS@xxxxxxxxxxxxx
Cc: 'oracle-l@xxxxxxxxxxxxx '
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

Other related posts: