I am trying to setup logical dataguard as we dont have licenses for active-active and need to gernerate reports online from the standby database .

always getting error like the primary database cannot connect to standby database ?

Please help.

Thanks

Views: 53

Reply to This

Replies to This Discussion

Hi,

Can you paste here your error? alert log primary database.

ps; It is not support side.

I have no error ,

the things look better now but the files are shipped but not applying ?

what could be the reason ?

Hi,

May be SQL Apply service is not started.
ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;

SELECT PROCESS FROM V$MANAGED_STANDBY;

Thanks

I will try this today..

want to ask u what is the disadvantage using logical datagaurd rather than using active dataguard?

Hi,

Firstly, you can not use Active Data Guard with logical standby. Only can use physical standby.
As you know, transport service is don't support all datatypes (http://docs.oracle.com/cd/B19306_01/server.102/b14239/create_ls.htm...).
But if you are using logical standby, then you can create additional indexes, also you can use logical database as other database
for other schema because logical standby database opening READ/WRITE mode.

Reply to Discussion

RSS

© 2019   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service