OraFAQ Forum: Data Guard » Logical Standby DB

Home » Server Options » Data Guard » Logical Standby DB

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Logical Standby DB [message #246301]

Wed, 20 June 2007 10:07

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hi,

i try to create logical standby database using oracle 10g R2.

SQL> alter database create logical standby controlfile AS 'F:\oracle\product\10.2.0\oradata\SITECPHY\CONTROLSTDY01.CTL';
alter database create logical standby controlfile AS 'F:\oracle\product\10.2.0\oradata\SITECPHY\CONTROLSTDY01.CTL'
*
ERROR at line 1:
ORA-06550: line 1, column 36:
PLS-00201: identifier 'DBMS_LOGMNR_D.STORE_IN_REDO_LOGS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

What is the problem ?

Report message to a moderator

Re: Logical Standby DB [message #246306 is a reply to message #246301]

Wed, 20 June 2007 10:18

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

ORA-06550:	line string, column string: string
Cause:	Usually a PL/SQL compilation error.
Action:	none

[Updated on: Wed, 20 June 2007 10:18]

Report message to a moderator

Re: Logical Standby DB [message #246311 is a reply to message #246306]

Wed, 20 June 2007 10:25

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

give me solution...

Report message to a moderator

Re: Logical Standby DB [message #246312 is a reply to message #246311]

Wed, 20 June 2007 10:27

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

yes thinking about sound strange case.

Report message to a moderator

Previous Topic:	Oracle 9i Database Failover
Next Topic:	Error while Restoring a Oracle 9i image on Oracle 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Aug 07 09:54:23 CDT 2025