RE: Converting from physical to logical standby

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".

Dennis Williams
DBA
Lifetouch, Inc.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Orr, Steve
Sent: Tuesday, September 28, 2004 10:05 AM To: oracle-l_at_freelists.org
Subject: Converting from physical to logical standby

Howdy! (Been awhile since I've been on this list...)

2 Questions:
1) What's the best way to convert a physical standby to a logical standby? The physical has been running for awhile now.

2) How can I create a logical standby with RMAN? MetaStink indicates this is not possible but this doesn't seem reasonable. I've created physical standby's from RMAN without requiring primary downtime and I'd like to do the same with a logical standby creation.

3) How can I have a physical and logical standby on the same server where they both have the same primary? I.E. the same database name. (I lied, this was the 3rd question.)=20

Steve Orr
Bozeman, Montana
--

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

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

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 28 2004 - 12:00:04 CDT