Home » Server Options » Data Guard » Logical Standby DB
Logical Standby DB [message #246301] Wed, 20 June 2007 10:07 Go to next message
babuknb
Messages: 1734
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 ?

Re: Logical Standby DB [message #246306 is a reply to message #246301] Wed, 20 June 2007 10:18 Go to previous messageGo to next message
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 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


give me solution...
Re: Logical Standby DB [message #246312 is a reply to message #246311] Wed, 20 June 2007 10:27 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
yes thinking about sound strange case.
Previous Topic: Oracle 9i Database Failover
Next Topic: Error while Restoring a Oracle 9i image on Oracle 10g
Goto Forum:
  


Current Time: Sat Dec 20 13:48:43 CST 2014

Total time taken to generate the page: 0.13303 seconds