Oracle Data Guard : Active Data Guard 11G (5)

28 Feb

17. Active Data Guard 11G
standby server untuk reporting READ ONLY, tetapi tidak bisa READ WRITE,
tetapi juga siap menerima pengiriman redo data

a. ubah setting standby server (server standby)
SQL> alter database recover managed standby database cancel;
SQL> alter database open read only;
SQL> alter database recover managed standby database disconnect;
SQL> select DATABASE_ROLE, open_mode from v$database;
DATABASE_ROLE OPEN_MODE
—————- ———-
PHYSICAL STANDBY READ ONLY

b. saldo awal (server standby)
SQL> conn scott/tiger;
Connected.
SQL> select * from dept;
DEPTNO DNAME LOC
———- ————– ————-
43 MK SBY
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
41 IT SBY
42 AU SBY

c. server primary menambah record [44, VA,SBY] (server primary)
SQL> conn scott/tiger
SQL> insert into dept values(44,’VA’,’SBY’);
SQL> commit;

d. standby server, apakah sudah menerima perubahan data [44, VA,SBY]? (server standby)
SQL> select * from dept;
DEPTNO DNAME LOC
———- ————– ————-
43 MK SBY
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
41 IT SBY
42 AU SBY

e. server primary dipaksa mengirim redo data (server primary)
SQL> conn / as sysdba
SQL> alter system switch logfile;

f. standby server, apakah sudah menerima perubahan data [44, VA,SBY] ? (server standby)
SQL> select * from dept;
DEPTNO DNAME LOC
———- ————– ————-
43 MK SBY
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
41 IT SBY
42 AU SBY
44 VA SBY

1. oracle data guard pengertian

2. demo oracle data guard physical standby database

3. oracle data guard test pengiriman logfile

4. oracle data guard standby server untuk reporting

5. oracle data guard active data guard 11g

6. oracle data guard switchover failover

7. oracle data guard test switchover failover

8. oracle data guard lampiran initora

2 Responses to “Oracle Data Guard : Active Data Guard 11G (5)”

  1. Jack Nickolson May 4, 2010 at 8:41 pm #

    Active Data Guard is best feature of Oracle 11g. Good marking.

  2. Jack Nickolson May 4, 2010 at 8:50 pm #

    Good tip.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: