dbTalk Databases Forums  

Logical standby database

comp.databases.oracle.server comp.databases.oracle.server


Discuss Logical standby database in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
minamdar@carterbloodcare.org
 
Posts: n/a

Default Logical standby database - 01-26-2006 , 02:42 PM






I am trying to create a logical standby database. I followed the Oracle
guidelines and did the following:
Created a backup control file on primary.
Built the logmnr dictionary on primary
Copied the data files, backup control files and the archived logs (with
logmnr dictionary) to the backup server
Started the logical standby database
Registered the archived logs
Tried to apply the archived logs using ALTER DATABASE START LOGICAL
STANDBY APPLY INITIAL command

This step fails the logmnr data dictionary tables do not get built.

This is what I see in the alert log:
Thu Jan 26 09:47:16 2006
LOGSTDBY event: ORA-01332: internal Logminer Dictionary error
Thu Jan 26 09:47:16 2006
Errors in file /usr19/admin/qa9/bdump/qa9_lsp0_2393.trc:
ORA-01332: internal Logminer Dictionary error

Has anyone run intom this problem? Any suggestions?

Thanks in advance.

Madan


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.