Oracle Community Network
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 ?
May be SQL Apply service is not started.
ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;
SELECT PROCESS FROM V$MANAGED_STANDBY;
I will try this today..
want to ask u what is the disadvantage using logical datagaurd rather than using active dataguard?
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.