oracle 10g physical standby 切換操作
primary庫操作:
SQL> select name,open_mode,protection_mode,database_role from v$database;
NAME OPEN_MODE PROTECTION_MODE DATABASE_ROLE
--------- ---------- -------------------- ----------------
YGH READ WRITE MAXIMUM PERFORMANCE PRIMARY
--------- ---------- -------------------- ----------------
YGH READ WRITE MAXIMUM PERFORMANCE PRIMARY
SQL> alter database commit to switchover to physical standby with session shutdown;
Database altered.
SQL> shutdown immediate
ORA-01507: database not mounted
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 264241152 bytes
Fixed Size 1218868 bytes
Variable Size 88082124 bytes
Database Buffers 171966464 bytes
Redo Buffers 2973696 bytes
SQL> alter database mount standby database;
Fixed Size 1218868 bytes
Variable Size 88082124 bytes
Database Buffers 171966464 bytes
Redo Buffers 2973696 bytes
SQL> alter database mount standby database;
Database altered.
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> select name,open_mode,protection_mode,database_role from v$database;
NAME OPEN_MODE PROTECTION_MODE DATABASE_ROLE
--------- ---------- -------------------- ----------------
YGH MOUNTED MAXIMUM PERFORMANCE PHYSICAL STANDBY
--------- ---------- -------------------- ----------------
YGH MOUNTED MAXIMUM PERFORMANCE PHYSICAL STANDBY
standby庫操作:
SQL> select name,open_mode,protection_mode,database_role from v$database;
NAME OPEN_MODE PROTECTION_MODE DATABASE_ROLE
--------- ---------- -------------------- ----------------
YGH MOUNTED MAXIMUM PERFORMANCE PHYSICAL STANDBY
--------- ---------- -------------------- ----------------
YGH MOUNTED MAXIMUM PERFORMANCE PHYSICAL STANDBY
SQL> alter database commit to switchover to primary;
Database altered.
SQL> shutdown immediate
ORA-01109: database not open
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 264241152 bytes
Fixed Size 1218868 bytes
Variable Size 88082124 bytes
Database Buffers 171966464 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> select name,open_mode,protection_mode,database_role from v$database;
Fixed Size 1218868 bytes
Variable Size 88082124 bytes
Database Buffers 171966464 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> select name,open_mode,protection_mode,database_role from v$database;
NAME OPEN_MODE PROTECTION_MODE DATABASE_ROLE
--------- ---------- -------------------- ----------------
YGH READ WRITE MAXIMUM PERFORMANCE PRIMARY
--------- ---------- -------------------- ----------------
YGH READ WRITE MAXIMUM PERFORMANCE PRIMARY
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/90618/viewspace-2146564/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Physical Standby Database 切換到 Snapshot Standby DatabaseDatabase
- oracle 10g physical standby database creationOracle 10gDatabase
- 在Oracle 10g下單機Physical StandbyOracle 10g
- Oracle physical standbyOracle
- 配置 Oracle 10g RAC primary + RAC physical standby dataguardOracle 10g
- oracle 之dataguard standby 切換Oracle
- Oracle DG建立Physical Standby DatabaseOracleDatabase
- oracle Physical Standby failover stepOracleAI
- Oracle 11.2.0.4 physical dataguard和snapshot dataguard切換Oracle
- oracle dg切換操作示例Oracle
- 【DataGuard】10g物理standby主備switchover方式切換詳述
- ORACLE 10G Data Guard 模式切換Oracle 10g模式
- oracle實驗記錄 (oracle 10G dataguard(7)physical dg轉換)Oracle
- GP standby切換成masterAST
- 【DataGuard】Oracle 11g physical standby switchoverOracle
- Oracle10G Physical Standby Database setupOracleDatabase
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(10)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(9)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(8)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(7)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(6)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(5)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(4)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(3)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(2)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(1)LinuxOracle 10g
- 10g Data Guard physical standby的主備庫角色轉換測試(switchover & failover)AI
- ORACLE10g DataGuard 配置Physical Standby DatabaseOracleDatabase
- DataGuard:Physical Standby Switchover
- oracle 10g dg切換步驟記錄Oracle 10g
- 建立Local Physical Standby Oracle9i standby 資料庫筆記Oracle資料庫筆記
- oracle實驗記錄 (flashback,physical standby resetlogs)Oracle
- GoldenGate的Primary-Standby切換Go
- dataguard之物理standby 日誌切換
- DATA GUARD物理STANDBY的 SWITCHOVER切換
- RAC環境STANDBY的SWITCHOVER切換
- DataGuard:Physical Standby FailoverAI
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase