Hi
I've got a problem to understand Oracle® Data Guard, Concepts and Administration Doc.
It reads:
If a license for the Oracle Active Data Guard option has been purchased, Redo Apply
can be active while the physical standby database is open, thus allowing queries to
return results that are identical to what would be returned from the primary database.
This capability is known as the real-time query feature. See Section 9.2.1 for more
details.
Later it reads:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> ALTER DATABASE OPEN;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;
Does this mean that the last SQL Statement is only ok, if I've purchases Active Data Guard?
Resulting from this question:
If I have opend the database for reading, let's say for a few hours, shut it down, mount it an start recover again:
It will detect the gap between the SCNs, get the archivefiles from the primary ( FAL_SERVER) and recover until it's up to date again?
Regards
Christian