Rac 操作:
关闭 22 节点:
SQL> select NAME ,DB_UNIQUE_NAME ,open_mode,DATABASE_ROLE,PROTECTION_MODE from v$database;
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
--------- ------------------------------ ---------- ----------------
PROTECTION_MODE
--------------------
HELLODB std01 READ WRITE PRIMARY
MAXIMUM PERFORMANCE
SQL> SQL>
SQL>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down
21 节点
SQL> SELECT * FROM V$DATAGUARD_STATS;
no rows selected
SQL> SQL>
SQL> select NAME ,DB_UNIQUE_NAME ,open_mode,DATABASE_ROLE,PROTECTION_MODE from v$database;
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE PROTECTION_MODE
--------- ------------------------------ ---------- ---------------- --------------------
HELLODB std01 READ WRITE PRIMARY MAXIMUM PERFORMANCE
SQL> SQL>
SQL>
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
--------------------
TO STANDBY
SQL> SQL>
SQL>
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;
Database altered.
SQL> SQL> SQL>
SQL>
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 4294967296 bytes
Fixed Size 2101808 bytes
Variable Size 788532688 bytes
Database Buffers 3489660928 bytes
Redo Buffers 14671872 bytes
Database mounted.
SQL> alter database recover managed standby database disconnect from session using current logfile;
Database altered.
单机52 操作
SQL> select NAME ,DB_UNIQUE_NAME ,open_mode,DATABASE_ROLE from v$database;
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
--------- ------------------------------ ---------- ----------------
HELLODB pri MOUNTED PHYSICAL STANDBY
1 row selected.
SQL> SQL>
SQL>
SQL> recover managed standby database disconnect from session;
Media recovery complete.
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
--------------------
SESSIONS ACTIVE
1 row selected.
SQL> SQL>
SQL>
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
*
ERROR at line 1:
ORA-01013: user requested cancel of current operation
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
Database altered.
SQL> ALTER DATABASE OPEN;
Database altered.
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
--------------------
TO STANDBY
1 row selected.
SQL> select NAME ,DB_UNIQUE_NAME ,open_mode,DATABASE_ROLE from v$database;
NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE
--------- ------------------------------ ---------- ----------------
HELLODB pri READ WRITE PRIMARY
1 row selected.
SQL> alter system switch logfile;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/758322/viewspace-680902/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/758322/viewspace-680902/