Oracle Data Guard – How Real-Time Apply Works in Logical Standby

dataguardoraclestandby

I am a little bit confused about real-time apply services.
I've read a documentation about the services and I still have a question.
Does archived redo logs required for logical standby or not?
I've configure logical standby and there are 3 destination for db_recovery_file dest.
1st is local storage, 2nd transmits logs on standby and the 3d is for switchover.
But still I do not purely understand how it works.
Please, clarify or give some useful links.

Best Answer

Does archived redo logs required for logical standby or not? Yes, it does.

https://docs.oracle.com/cd/B19306_01/server.102/b14239/create_ls.htm#g105412

The archived redo logs (archivelogs, commonly) contain SQL statements to apply the changes being made to the database, as well as SQL statements to undo the work if a rollback occurs later on the primary's activity.

Related Solutions

Oracle: How to gather stats in a logical standby database

You cannot run any DML in a logical standby database unless you deactivate, temporary, the guard feature. To overcome you isse you can do:

SQL> ALTER DATABASE GUARD NONE;
SQL> SELECT GUARD_STATUS FROM V$DATABASE; 
GUARD_STATUS 
-------------------- 
NONE

And then run your dbms_stats.

Oracle Standby License – Understanding Licensing Requirements

Short version: no.

Active Data Guard is an optional feature that allows you to open the standby database in read-only mode while applying logs from the primary. If you need the standby database only in case of disaster, then you don't need to buy this option.

Best Answer

Related Solutions

Oracle: How to gather stats in a logical standby database

Oracle Standby License – Understanding Licensing Requirements

Related Question