11g ???:Active Data Guard
- by JaneZhang(???)
?Oracle 11g??,????(physical Standby)???redo???,???????,???mount??11g??,???redo???,????????read-only??,????Active Data Guard ???Active Data Guard,?????????????????,?????????????? Active Data Guard???????????,??,????????????,????????,????redo??,????????????,???????????
Oracle Active Data Guard ?Oracle Database Enterprise Edition?????,?????????????? ????Active Data Guard, ??????? read-only ????,???? ALTER DATABASE RECOVER MANAGED STANDBY DATABASE????????????:??????COMPATIBLE ????????11.0.0? ???????Active Data Guard,???V$DATABASE????"READ ONLY WITH APPLY': SQL> SELECT open_mode FROM V$DATABASE; OPEN_MODE -------------------- READ ONLY WITH APPLY ????????????,???????real-time apply: SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE; ?????????read-only????????: • Issue SELECT statements, including queries that require multiple sorts that leverage TEMP segments • Use ALTER SESSION and ALTER SYSTEM statements • Use SET ROLE • Call stored procedures • Use database links (dblinks) to write to remote databases • Use stored procedures to call remote procedures via dblinks • Use SET TRANSACTION READ ONLY for transaction level read consistency • Issue complex queries (such as grouping SET queries and WITH CLAUSE queries) ??????????read-only????????: • Any DMLs (excluding simple SELECT statements) or DDLs • Query accessing local sequences • DMLs to local temporary tables ?????Active Data Guard ??: • ????????????????? • ???Oracle Real Application Clusters (Oracle RAC) ,?????? • RAC???RAC?? Oracle Data Guard ?????,,????????:
* ?????????????????: http://docs.oracle.com/cd/B28359_01/server.111/b28294/create_ps.htm * ???Oracle Real Application Clusters (Oracle RAC) ,??????: http://www.oracle.com/technetwork/database/features/availability/maa-wp-10g-racprimarysingleinstance-131970.pdf * RAC ???RAC ??: http://www.oracle.com/technetwork/database/features/availability/maa-wp-10g-racprimaryracphysicalsta-131940.pdf ??Active Data Guard???????,?????: http://www.oracle.com/technetwork/database/features/availability/maa-wp-11gr1-activedataguard-1-128199.pdf
??Oracle Maximum Availability Architecture Best Practices?????,???: http://www.oracle.com/goto/maa
