Has anyone configured a logical standby database using dataguard ie dgmgrl.
I've done the following but i get an error, see bottom, has anyone done this, this is my first attempt at creating a logical standby, do I need to follow the steps in the Oracle DataGuard manual chapter 4 (Creating a logical standby) or does dgmgrl take care of everything!
Am trying to add repn as the logical standby.
Any help would be greatly appreciated.
DGMGRL> add database 'repn' as connect identifier is repn maintained as logical; Database "repn" added. DGMGRL> show configuration;
-- ---- ---- ---- ---- ---- ----- Yahoo! Photos ? NEW, now offering a quality print service from just 8p a photo. <div>Has anyone configured a logical standby database using dataguard ie dgmgrl.</div> <div> </div> <div>I've done the following but i get an error, see bottom, has anyone done this, this is my first attempt at creating a logical standby, do I need to follow the steps in the Oracle DataGuard manual chapter 4 (Creating a logical standby) or does dgmgrl take care of everything!< /div> <div> </div> <div>Am trying to add repn as the logical standby.< /div> <div> </div> <div> </div> <div>Any help would be greatly appreciated.</div> <div> </div> <div>DGMGRL> add database 'repn' as connect identifier is repn maintained as <BR>logical;<BR>Database "repn" added. <BR>DGMGRL> show configuration;<BR><BR>Configuration<BR>Name: atex_nationals <BR>Enabled: YES<BR>Protection Mode: MaxPerformance<BR>Databases:<BR>caprn - Primary database<BR>raprn - Physical standby database<BR>repn - Logical standby database (disabled)<BR><BR>Current status for "atex_nationals":<BR>SUCCESS<BR><BR>DGMGRL> enable database repn;<BR><BR >Enabled.<BR>DGMGRL> DGMGRL> show configuation;<BR>show configuation;<BR>^ <BR>Syntax error before or at "configuation"<BR>DGMGRL> show configuration; <BR><BR>Configuration<BR>Name: atex_nationals<BR>Enabled: YES<BR>Protection Mode : MaxPerformance<BR>Databases:<BR>caprn - Primary database<BR>raprn - Physical standby database<BR>repn - Logical standby database<BR><BR>Current status for "atex_nationals":<BR>Warning: ORA-16607 (See ORA-16607.ora-code.com): one or more databases have failed<BR> <BR><BR>DGMGRL><BR></div> <div> </div> <div> </div><p> <hr size=1><font face="Arial" size="2"><a href="http://us.rd.yahoo.com/mail /uk/taglines/default/photos/*http://uk.photos.yahoo.com/"><b>Yahoo! Photos</b>< /a> ? <font color="red">NEW</font>, now offering a <a href="http://us.rd.yahoo .com/mail/uk/taglines/default/photos/*http://uk.photos.yahoo.com/">quality print service</a> from just 8p a photo.</font>
