REAL TIME APPLY OF ARCHIVE LOG FILES IN READ ONLY MODE:SQL> select PROTECTION_MODE,PROTECTION_LEVEL FROM V$DATABASE;
PROTECTION_MODE PROTECTION_LEVEL
MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/oraarch/
Oldest online log sequence 250
Next log sequence to archive 0
Current log sequence 252
SQL> recover managed standby database using current logfile disconnect from session;
Media recovery complete.
SQL> alter database open read only;
Database altered.
NOW ON PRIMARY DATABASE I CREATE TABLE IN ONE OF USER ADD INSERT SOME DATA[[email protected] Desktop]$ sqlplus /”As sysdba”
SQL> select name,open_mode,db_unique_name,PROTECTION_MODE,PROTECTION_LEVEL FROM V$DATABASE;
NAME OPEN_MODE DB_UNIQUE_NAME PROTECTION_MODE PROTECTION_LEVEL
——– ——————– ——— ——————– ———
ORCL READ ONLY WITH APPLY ORCLSTB1 MAXIMUM PERFORMANCE MAXIMUM PERFORMAN
SQL> conn atoorpu/XXXXX;
Connected.
SQL> create table abcd (name varchar2(20));
Table created.
SQL> insert into abcd values (‘arvind’);
1 row created.
SQL> commit;
Commit complete.
SQL> alter system switch logfile;
System altered.
SQL> insert into abcd values (‘reddy’);
1 row created.
SQL> commit;
Commit complete.
SQL> create table abcds as select * from abcd;
Table created.
NOW ON STANDBY DATABASE LETS QUERY SAME DATA SOME DATA[[email protected] Desktop]$ sqlplus /”As sysdba”
SQL> select name,open_mode,db_unique_name,PROTECTION_MODE,PROTECTION_LEVEL FROM V$DATABASE;
NAME OPEN_MODE DB_UNIQUE_NAME PROTECTION_MODE PROTECTION_LEVEL
——– ——————– ——— ——————– ———
ORCL READ ONLY WITH APPLY ORCLSTB1 MAXIMUM PERFORMANCE MAXIMUM PERFORMAN
SQL> conn atoorpu/XXXXX;
Connected.
SQL> select * from abcd;
NAME
arvind
SQL> select * from abcd;
NAME
arvind
reddy
