Could you please explain me. What is the difference between AFFIRM/NOAFFIRM? and What is StaticConnectIdentifier property used for? in data guard
Here is the official explanation from Oracle, and it is pretty much say it all.
AFFIRM—specifies that a redo transport destination acknowledges received redo data after writing it to the standby redo log.
NOAFFIRM—specifies that a redo transport destination acknowledges received redo data before writing it to the standby redo log.
With regarding to StaticConnectIdentifier, it is a property that let the system know the tns entry to be used at startup time.
Hope it helps.
|Rating(1-10)||Knowledgeability = 10||Clarity of Response = 10||Politeness = 10|
- Ask a Question
I can answer questions with regarding to Oracle DB (8i, 9i, 10g, 11g) installation, configuration, administration, Data Guard, SQL, and PL/SQL (Procedures, triggers, functions).
I am an Oracle DBA, Senior PA, Project Manager, and Data Architect with 10 years of experience.
Bachelor of Science in Management System