10g物理standby：switchover

主库switchover：

SQL> select sid,serial#,username from v$session where username is not null;

SID SERIAL# USERNAME
---------- ---------- ------------------------------
124 10 SYSMAN
126 9 SYSMAN
127 2 SYSMAN
128 2 SYSMAN
129 2 SYSMAN
130 8 SYSMAN
131 10 SYSMAN
144 51 DBSNMP
151 105 SYSMAN
157 3 SYS

10 rows selected.

[@more@]

SQL> alter system kill session '128,2';

System altered.

SQL> alter system kill session '129,2';

System altered.

SQL> alter system kill session '130,8';

System altered.

SQL> alter system kill session '131,10';

System altered.

SQL> alter system kill session '144,51';

System altered.

SQL> alter system kill session '151,105';

System altered.

SQL> alter system kill session '151,1051';
alter system kill session '151,1051'
*
ERROR at line 1:
ORA-00030: User session ID does not exist.

SQL>
SQL> alter system kill session '151,105';

System altered.

SQL>
SQL> select sid,serial#,username from v$session where username is not null;

SID SERIAL# USERNAME
---------- ---------- ------------------------------
124 10 SYSMAN
126 9 SYSMAN
127 2 SYSMAN
128 2 SYSMAN
129 2 SYSMAN
130 8 SYSMAN
131 10 SYSMAN
144 51 DBSNMP
151 107 SYSMAN
157 3 SYS

10 rows selected.

SQL>
SQL> select sid,serial#,username from v$session where username is not null;

SID SERIAL# USERNAME
---------- ---------- ------------------------------
157 3 SYS

SQL>
SQL> select switchover_status from v$database;

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

SQL>
SQL> insert into t2 (deptno) values (50);

1 row created.

SQL> commit;

Commit complete.

SQL> select sid,serial#,username from v$session where username is not null;

SID SERIAL# USERNAME
---------- ---------- ------------------------------
157 3 SYS

SQL>
SQL> alter database commit to switchover to physical standby;

Database altered.

SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
SQL>
SQL> startup nomount
ORACLE instance started.

Total System Global Area 1258291200 bytes
Fixed Size 1250548 bytes
Variable Size 343935756 bytes
Database Buffers 905969664 bytes
Redo Buffers 7135232 bytes
SQL> alter database mount standby database;

Database altered.

SQL>

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
--------------------
TO PRIMARY

SQL>
SQL>

从库switchover：

SQL> select status from v$instance;

STATUS
------------------------
MOUNTED

SQL>
SQL> select switchover_status from v$instance;
select switchover_status from v$instance
*
第 1 行出现错误:
ORA-00904: "SWITCHOVER_STATUS": ?????

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
----------------------------------------
SWITCHOVER PENDING

SQL>
SQL> alter database commit to switchover to primary;
alter database commit to switchover to primary
*
第 1 行出现错误:
ORA-16139: ??????

SQL> alter session set nls_language=american;

Session altered.

SQL> alter database commit to switchover to primary;
alter database commit to switchover to primary
*
ERROR at line 1:
ORA-16139: media recovery required

SQL>
SQL> alter database recover managed standby database ;

Database altered.

SQL> alter database commit to switchover to primary;

Database altered.

SQL> select switchover_status from v$database;

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

SQL>
SQL> alter database open;

Database altered.

SQL> select switchover_status from v$database;

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

SQL>
SQL> select database_role from v$database;

DATABASE_ROLE
--------------------------------
PRIMARY

SQL>
SQL> select * from t2;

DEPTNO DNAME LOC
---------- ---------------------------- --------------------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
50

原来的主库已经切换为PHYSICAL STANDBY：

SQL> select database_role from v$database;

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

SQL>
SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/593324/viewspace-1007311/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/593324/viewspace-1007311/