Oracle11g, the most attractive feature is the Active Data Guard, that is, the physical library open read only prepared at the same time, you can apply log.To enable this feature is very simple, first of all to ensure that compatible = 11.0.0.0 above, and then open read only the implementation of the state can recover managed standby database disconnect.Open the properties can be open simultaneously the best real-time logging application, in order to reduce the standby delay between the databases of the data, so prepare a good base to add standby logfile:
recover managed standby database cancel;
alter database open;
alter database add standby logfile group 10 ('/u01/oracle/oradata/test/stbredo01.dbf') size 100m reuse;
alter database add standby logfile group 11 ('/u01/oracle/oradata/test/stbredo02.dbf') size 100m reuse;
alter database add standby logfile group 12 ('/u01/oracle/oradata/test/stbredo03.dbf') size 100m reuse;
alter database add standby logfile group 13 ('/u01/oracle/oradata/test/stbredo04.dbf') size 100m reuse;
Preparation of library and then placed in real-time log application:
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ ONLY
SQL> alter database recover managed standby database using current logfile disconnect;
Database altered.
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ ONLY WITH APPLY
In the main library to create a test table and insert the data:
SQL> create table ningoo.test_table(i int);
Table created.
SQL> insert into ningoo.test_table values(1);
1 row created.
SQL> commit;
Commit complete.
SQL> alter system archive log current;
System altered.
Exambible offers free demo for 1z0-042 exam. Candidates can check the interface, question quality and usability of our practice exams before purchasing.