Replies to This Discussion

Permalink Reply by David Karplin on May 28, 2013 at 11:03am

Hi,

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

ps; It is not support side.

• ▶ Reply

Permalink Reply by Fausto Felch on May 28, 2013 at 11:03am

I have no error ,

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

what could be the reason ?

• ▶ Reply

Permalink Reply by David Karplin on May 28, 2013 at 11:04am

Hi,

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

SELECT PROCESS FROM V$MANAGED_STANDBY;

• ▶ Reply

Permalink Reply by Fausto Felch on May 28, 2013 at 11:05am

Thanks

I will try this today..

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

• ▶ Reply

Permalink Reply by David Karplin on May 28, 2013 at 11:07am

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

▶ Reply to Discussion