DG swithover

primary操作：
SQL> select switchover_status from v$database;


SWITCHOVER_STATUS
--------------------
SESSIONS ACTIVE


SQL> alter database commit to switchover to physical standby with session shutdown;


Database altered.


SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.


Total System Global Area  409194496 bytes
Fixed Size    2253744 bytes
Variable Size  322964560 bytes
Database Buffers   79691776 bytes
Redo Buffers    4284416 bytes
Database mounted.
开始备库操作：
SQL> select switchover_status from v$database;


SWITCHOVER_STATUS
--------------------
SESSIONS ACTIVE


SQL> select database_role from v$database;


DATABASE_ROLE
----------------
PHYSICAL STANDBY


SQL> alter database commit to switchover to primary with session shutdown;


Database altered.


SQL> select open_mode from v$database;


OPEN_MODE
--------------------
MOUNTED
此刻备库转换成主库，执行数据库open操作
SQL> alter database open;


Database altered.


SQL> select open_mode from V$database;


OPEN_MODE
--------------------
READ WRITE


SQL> select database_role from v$database;


DATABASE_ROLE
----------------
PRIMARY
查看数据库保护模式：
SQL> select protection_mode,protection_level from v$database;


PROTECTION_MODE      PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY
将主库应用日志：
SQL> alter database open;


Database altered.


SQL> alter database recover managed standby database using current logfile disconnect from session;


Database altered.
测试DG
主库操作：
SQL> alter system switch logfile;


System altered.


SQL> select * from test;


     EMPNO ENAME      JOB       MGR HIREDATE    SAL       COMM
---------- ---------- --------- ---------- --------- ---------- ----------
    DEPTNO
----------
      7369 SMITH      CLERK      7902 17-DEC-80    800
20


      7499 ALLEN      SALESMAN      7698 20-FEB-81   1600        300
30


      7521 WARD       SALESMAN      7698 22-FEB-81   1250        500
30




     EMPNO ENAME      JOB       MGR HIREDATE    SAL       COMM
---------- ---------- --------- ---------- --------- ---------- ----------
    DEPTNO
----------
      7566 JONES      MANAGER      7839 02-APR-81   2975
20


      7654 MARTIN     SALESMAN      7698 28-SEP-81   1250       1400
30


      7698 BLAKE      MANAGER      7839 01-MAY-81   2850
30




     EMPNO ENAME      JOB       MGR HIREDATE    SAL       COMM
---------- ---------- --------- ---------- --------- ---------- ----------
    DEPTNO
----------
      7782 CLARK      MANAGER      7839 09-JUN-81   2450
10


      7788 SCOTT      ANALYST      7566 19-APR-87   3000
20


      7839 KING       PRESIDENT   17-NOV-81   5000
10




     EMPNO ENAME      JOB       MGR HIREDATE    SAL       COMM
---------- ---------- --------- ---------- --------- ---------- ----------
    DEPTNO
----------
      7844 TURNER     SALESMAN      7698 08-SEP-81   1500  0
30


      7876 ADAMS      CLERK      7788 23-MAY-87   1100
20


      7900 JAMES      CLERK      7698 03-DEC-81    950
30




     EMPNO ENAME      JOB       MGR HIREDATE    SAL       COMM
---------- ---------- --------- ---------- --------- ---------- ----------
    DEPTNO
----------
      7902 FORD       ANALYST      7566 03-DEC-81   3000
20


      7934 MILLER     CLERK      7782 23-JAN-82   1300
10




14 rows selected.


SQL> drop table test;


Table dropped.


SQL> commit;


Commit complete.






SQL> select * from v$archive_gap;


no rows selected
备库操作:


SQL>select * from test
              *
ERROR at line 1:
ORA-00942: table or view does not exist






[END] 2017/4/30 10:07:43