Oracle11g RAC (ASM) 及Active Dataguard開啟與關閉 [final]
一, Oracle11g RAC (ASM) Primary DB開關機 關機 : 1. 首先以grid使用者在任意一個節點執行crs_stat -t查詢當前RAC的狀態 (注意:其中有一些服務本身就是offline的) wsjrac01$crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.DATA.dg ora....up.type ONLINE ONLINE wsjrac01 ora.INDX.dg ora....up.type ONLINE ONLINE wsjrac01 ora....ER.lsnr ora....er.type ONLINE ONLINE wsjrac01 ora....N1.lsnr ora....er.type ONLINE ONLINE wsjrac02 ora.asm ora.asm.type ONLINE ONLINE wsjrac01 ora.cvu ora.cvu.type ONLINE ONLINE wsjrac02 ora.gsd ora.gsd.type OFFLINE OFFLINE ora....network ora....rk.type ONLINE ONLINE wsjrac01 ora.oc4j ora.oc4j.type ONLINE ONLINE wsjrac02 ora.ons ora.ons.type ONLINE ONLINE wsjrac01 ora....ry.acfs ora....fs.type ONLINE ONLINE wsjrac01 ora.scan1.vip ora....ip.type ONLINE ONLINE wsjrac02 ora.wsjdell.db ora....se.type ONLINE ONLINE wsjrac01 ora....SM1.asm application ONLINE ONLINE wsjrac01 ora....01.lsnr application ONLINE ONLINE wsjrac01 ora....c01.gsd application OFFLINE OFFLINE ora....c01.ons application ONLINE ONLINE wsjrac01 ora....c01.vip ora....t1.type ONLINE ONLINE wsjrac01 ora....SM2.asm application ONLINE ONLINE wsjrac02 ora....02.lsnr application ONLINE ONLINE wsjrac02 ora....c02.gsd application OFFLINE OFFLINE ora....c02.ons application ONLINE ONLINE wsjrac02 ora....c02.vip ora....t1.type ONLINE ONLINE wsjrac02 ora....SM3.asm application ONLINE ONLINE wsjrac03 ora....03.lsnr application ONLINE ONLINE wsjrac03 ora....c03.gsd application OFFLINE OFFLINE ora....c03.ons application ONLINE ONLINE wsjrac03 ora....c03.vip ora....t1.type ONLINE ONLINE wsjrac03 wsjrac01$ 2. 以grid使用者登入, 然後保留grid環境, 切換到root 許可權 , 停止Oracle11g RAC 環境 (在任意一個node執行) ------------------------------------------------ 其實也可以直接root登入, 在執行命令的時候需要執行絕對路徑: [root@rac01 bin]# pwd /u01/grid/11.2.0/bin [root@rac01 bin]# ./crsctl stop cluster -all ------------------------------------------------ crsctl stop cluster –all 命令中不加入 -all 就是關閉本機例項 . 下面我們以第一種方式執行關閉整個RAC: wsjrac01$id uid=500(grid) gid=500(oinstall) groups=500(oinstall),501(asmadmin),502(asmdba),503(asmoper) wsjrac01$su ---- su 切換到root許可權但是保留grid環境 Password: wsjrac01$id uid=0(root) gid=0(root) groups=0(root),1(bin),2(daemon),3(sys),4(adm),6(disk),10(wheel),105(pkcs11) wsjrac01$crsctl stop cluster –all CRS-2673: Attempting to stop 'ora.crsd' on 'wsjrac02' CRS-2673: Attempting to stop 'ora.crsd' on 'wsjrac01' CRS-2673: Attempting to stop 'ora.crsd' on 'wsjrac03' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'wsjrac01' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'wsjrac01' CRS-2673: Attempting to stop 'ora.registry.acfs' on 'wsjrac01' CRS-2673: Attempting to stop 'ora.wsjdell.db' on 'wsjrac01' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'wsjrac02' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'wsjrac02' CRS-2673: Attempting to stop 'ora.registry.acfs' on 'wsjrac02' CRS-2673: Attempting to stop 'ora.wsjdell.db' on 'wsjrac02' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'wsjrac03' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'wsjrac03' CRS-2673: Attempting to stop 'ora.registry.acfs' on 'wsjrac03' CRS-2673: Attempting to stop 'ora.wsjdell.db' on 'wsjrac03' CRS-2673: Attempting to stop 'ora.cvu' on 'wsjrac03' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'wsjrac03' CRS-2673: Attempting to stop 'ora.oc4j' on 'wsjrac03' CRS-2677: Stop of 'ora.cvu' on 'wsjrac03' succeeded CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'wsjrac01' succeeded CRS-2673: Attempting to stop 'ora.wsjrac01.vip' on 'wsjrac01' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'wsjrac02' succeeded CRS-2673: Attempting to stop 'ora.wsjrac02.vip' on 'wsjrac02' CRS-2677: Stop of 'ora.wsjrac01.vip' on 'wsjrac01' succeeded CRS-2677: Stop of 'ora.wsjrac02.vip' on 'wsjrac02' succeeded CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'wsjrac03' succeeded CRS-2673: Attempting to stop 'ora.scan1.vip' on 'wsjrac03' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'wsjrac03' succeeded CRS-2673: Attempting to stop 'ora.wsjrac03.vip' on 'wsjrac03' CRS-2677: Stop of 'ora.scan1.vip' on 'wsjrac03' succeeded CRS-2677: Stop of 'ora.wsjrac03.vip' on 'wsjrac03' succeeded CRS-2677: Stop of 'ora.registry.acfs' on 'wsjrac01' succeeded CRS-2677: Stop of 'ora.registry.acfs' on 'wsjrac02' succeeded CRS-2677: Stop of 'ora.registry.acfs' on 'wsjrac03' succeeded CRS-2677: Stop of 'ora.wsjdell.db' on 'wsjrac01' succeeded CRS-2673: Attempting to stop 'ora.DATA.dg' on 'wsjrac01' CRS-2673: Attempting to stop 'ora.INDX.dg' on 'wsjrac01' CRS-2677: Stop of 'ora.wsjdell.db' on 'wsjrac02' succeeded CRS-2673: Attempting to stop 'ora.DATA.dg' on 'wsjrac02' CRS-2673: Attempting to stop 'ora.INDX.dg' on 'wsjrac02' CRS-2677: Stop of 'ora.wsjdell.db' on 'wsjrac03' succeeded CRS-2673: Attempting to stop 'ora.DATA.dg' on 'wsjrac03' CRS-2673: Attempting to stop 'ora.INDX.dg' on 'wsjrac03' CRS-2677: Stop of 'ora.INDX.dg' on 'wsjrac01' succeeded CRS-2677: Stop of 'ora.INDX.dg' on 'wsjrac02' succeeded CRS-2677: Stop of 'ora.oc4j' on 'wsjrac03' succeeded CRS-2677: Stop of 'ora.INDX.dg' on 'wsjrac03' succeeded CRS-2677: Stop of 'ora.DATA.dg' on 'wsjrac01' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'wsjrac01' CRS-2677: Stop of 'ora.asm' on 'wsjrac01' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'wsjrac01' CRS-2677: Stop of 'ora.DATA.dg' on 'wsjrac02' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'wsjrac02' CRS-2677: Stop of 'ora.asm' on 'wsjrac02' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'wsjrac02' CRS-2677: Stop of 'ora.DATA.dg' on 'wsjrac03' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'wsjrac03' CRS-2677: Stop of 'ora.asm' on 'wsjrac03' succeeded CRS-2677: Stop of 'ora.ons' on 'wsjrac01' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'wsjrac01' CRS-2677: Stop of 'ora.net1.network' on 'wsjrac01' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'wsjrac01' has completed CRS-2677: Stop of 'ora.ons' on 'wsjrac02' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'wsjrac02' CRS-2677: Stop of 'ora.net1.network' on 'wsjrac02' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'wsjrac02' has completed CRS-2673: Attempting to stop 'ora.ons' on 'wsjrac03' CRS-2677: Stop of 'ora.ons' on 'wsjrac03' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'wsjrac03' CRS-2677: Stop of 'ora.net1.network' on 'wsjrac03' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'wsjrac03' has completed CRS-2677: Stop of 'ora.crsd' on 'wsjrac01' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'wsjrac01' CRS-2673: Attempting to stop 'ora.evmd' on 'wsjrac01' CRS-2673: Attempting to stop 'ora.asm' on 'wsjrac01' CRS-2677: Stop of 'ora.crsd' on 'wsjrac02' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'wsjrac02' CRS-2673: Attempting to stop 'ora.evmd' on 'wsjrac02' CRS-2673: Attempting to stop 'ora.asm' on 'wsjrac02' CRS-2677: Stop of 'ora.crsd' on 'wsjrac03' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'wsjrac03' CRS-2673: Attempting to stop 'ora.evmd' on 'wsjrac03' CRS-2673: Attempting to stop 'ora.asm' on 'wsjrac03' CRS-2677: Stop of 'ora.asm' on 'wsjrac01' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'wsjrac01' CRS-2677: Stop of 'ora.asm' on 'wsjrac02' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'wsjrac02' CRS-2677: Stop of 'ora.evmd' on 'wsjrac02' succeeded CRS-2677: Stop of 'ora.asm' on 'wsjrac03' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'wsjrac03' CRS-2677: Stop of 'ora.evmd' on 'wsjrac03' succeeded CRS-2677: Stop of 'ora.evmd' on 'wsjrac01' succeeded CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'wsjrac03' succeeded CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'wsjrac01' succeeded CRS-2677: Stop of 'ora.ctssd' on 'wsjrac01' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'wsjrac01' CRS-2677: Stop of 'ora.ctssd' on 'wsjrac02' succeeded CRS-2677: Stop of 'ora.ctssd' on 'wsjrac03' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'wsjrac03' CRS-2677: Stop of 'ora.cssd' on 'wsjrac01' succeeded CRS-2673: Attempting to stop 'ora.diskmon' on 'wsjrac01' CRS-2677: Stop of 'ora.cssd' on 'wsjrac03' succeeded CRS-2673: Attempting to stop 'ora.diskmon' on 'wsjrac03' CRS-2677: Stop of 'ora.diskmon' on 'wsjrac01' succeeded CRS-2677: Stop of 'ora.diskmon' on 'wsjrac03' succeeded CRS-2675: Stop of 'ora.cluster_interconnect.haip' on 'wsjrac02' failed CRS-2679: Attempting to clean 'ora.cluster_interconnect.haip' on 'wsjrac02' CRS-2681: Clean of 'ora.cluster_interconnect.haip' on 'wsjrac02' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'wsjrac02' CRS-2677: Stop of 'ora.cssd' on 'wsjrac02' succeeded CRS-2673: Attempting to stop 'ora.diskmon' on 'wsjrac02' CRS-2677: Stop of 'ora.diskmon' on 'wsjrac02' succeeded wsjrac01$ 3. 檢視現在RAC的狀態(在每個node下) wsjrac03$crs_stat -t CRS-0184: Cannot communicate with the CRS daemon. --全部關閉的狀態 wsjrac03$crs_stat -t CRS-0184: Cannot communicate with the CRS daemon. wsjrac03$crs_stat -t CRS-0184: Cannot communicate with the CRS daemon. 4. 然後# init 0 (#shutdown -h now)關閉伺服器(如果重新啟動#init 6) 關機 : 開機過程中, 如果Linux有重新啟動, ASM及RAC都會自動開啟, 不需要手工 干預. 如果開啟有問題或OS沒有重新啟動, 手工開啟的命令差不多 (stop換start即可). [root@rac01 bin]# pwd /u01/grid/11.2.0/bin [root@rac01 bin]# ./crsctl stop resource -all 二, Oracle11g RAC Active Dataguard DB (ASM單機) 開關機 關閉Active Dataguard (單機oracle 11.2.0.2+ASM) 1. 首先關閉Oracle資料庫例項: [root@wsjdelll10sty ~]# su - oracle wsjdelll10sty$sqlplus '/as sysdba' SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. 2. 然後關閉ASM例項 : [root@wsjdelll10sty ~]# su - grid wsjdelll10sty$sqlplus '/as sysasm' SQL>shutdown immediate; ASM diskgroups dismounted ASM instance shutdown 3. 最後 # init 0 PS: 後來注意到ASM的standby也是由grid使用者管理,使用clusterware的一些命令好像也可以對他操作 可能我按照先關閉database再關閉ASM的順序,直接使用crsctl stop cluster可能也可以成功關閉 standby,待驗證。 開啟Active Dataguard (單機oracle 11.2.0.2+ASM) 1. 如果OS有重新啟動, 那麼當server啟動後ASM自動被掛載上,standby database會 自動startup到read only狀態(都是透過crs來管理的),listener自動start,過程如同RAC 的啟動,不需要手動啟動。可以使用crs_stat -t檢視狀態 。 wsjdelll10sty$crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.DATA.dg ora....up.type ONLINE ONLINE wsjd...0sty ora.INDX.dg ora....up.type ONLINE ONLINE wsjd...0sty ora....ER.lsnr ora....er.type ONLINE ONLINE wsjd...0sty ora.asm ora.asm.type ONLINE ONLINE wsjd...0sty ora.cssd ora.cssd.type ONLINE ONLINE wsjd...0sty ora.diskmon ora....on.type ONLINE ONLINE wsjd...0sty ora.evmd ora.evm.type ONLINE ONLINE wsjd...0sty ora.ons ora.ons.type ONLINE ONLINE wsjd...0sty ora.wsjdell.db ora....se.type ONLINE ONLINE wsjd...0sty 2. 切換到Oracle使用者, 檢視資料庫狀: [root@wsjdelll10sty ~]# su - oracle wsjdelll10sty$sqlplus '/as sysdba' Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP, Data Mining, Oracle Database Vault and Real Application Testing options SQL> select open_mode from v$database; OPEN_MODE -------------------- READ ONLY 3. 檢視監聽狀態, 是開啟狀態 : wsjdelll10sty$lsnrctl status 4. 這時只需要開啟standby的redo real-time apply(實時運用) (目前只是啟動到read only) [root@wsjdelll10sty ~]# su - oracle wsjdelll10sty$sqlplus '/as sysdba'; SQL> alter database recover managed standby database using current logfile disconnect; SQL> select open_mode from v$database; OPEN_MODE -------------------- READ ONLY WITH APPLY 如果OS沒有重新啟動, 那麼整個過程就需要手工操作: 1. 首先需要開啟ASM wsjdelll10sty$id uid=500(grid) gid=500(oinstall) groups=500(oinstall),501(asmadmin),502(asmdba),503(asmoper),504(dba) wsjdelll10sty$export ORACLE_SID=+ASM wsjdelll10sty$sqlplus "/as sysasm" SQL> startup ASM instance started Total System Global Area 283930624 bytes Fixed Size 2225792 bytes Variable Size 256539008 bytes ASM Cache 25165824 bytes ASM diskgroups mounted 也可以 : SQL>startup nomount; SQL>select name,state from v$asm_diskgroup; SQL>alter diskgroup all mount; 2. 繼續開啟Oracle DB standby : [root@wsjdelll10sty ~]# su - oracle wsjdelll10sty$ wsjdelll10sty$lsnrctl start wsjdelll10sty$sqlplus "/as sysdba" SQL> startup ORACLE instance started. Total System Global Area 2.6724E+10 bytes Fixed Size 2239112 bytes Variable Size 1.2818E+10 bytes Database Buffers 1.3892E+10 bytes Redo Buffers 12128256 bytes Database mounted. Database opened. SQL> SQL> select open_mode from v$database; OPEN_MODE -------------------- READ ONLY SQL>alter database recover managed standby database using current logfile disconnect; SQL> select open_mode from v$database; OPEN_MODE -------------------- READ ONLY WITH APPLY --------------------------------------------------------------- PS: 如何使用crsctl 等命令關閉及開啟ASM單機 . [root@wsjdelll10sty ~]# su - grid wsjdelll10sty$crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.DATA.dg ora....up.type ONLINE ONLINE wsjd...0sty ora.INDX.dg ora....up.type ONLINE ONLINE wsjd...0sty ora....ER.lsnr ora....er.type ONLINE ONLINE wsjd...0sty ora.asm ora.asm.type ONLINE ONLINE wsjd...0sty ora.cssd ora.cssd.type ONLINE ONLINE wsjd...0sty ora.diskmon ora....on.type ONLINE ONLINE wsjd...0sty ora.evmd ora.evm.type ONLINE ONLINE wsjd...0sty ora.ons ora.ons.type ONLINE ONLINE wsjd...0sty ora.wsjdell.db ora....se.type ONLINE ONLINE wsjd...0sty wsjdelll10sty$crsctl stop resource -all CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'wsjdelll10sty' CRS-2673: Attempting to stop 'ora.diskmon' on 'wsjdelll10sty' CRS-2673: Attempting to stop 'ora.DATA.dg' on 'wsjdelll10sty' CRS-2673: Attempting to stop 'ora.INDX.dg' on 'wsjdelll10sty' CRS-2673: Attempting to stop 'ora.wsjdell.db' on 'wsjdelll10sty' CRS-2673: Attempting to stop 'ora.evmd' on 'wsjdelll10sty' CRS-2673: Attempting to stop 'ora.ons' on 'wsjdelll10sty' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'wsjdelll10sty' succeeded CRS-2677: Stop of 'ora.ons' on 'wsjdelll10sty' succeeded CRS-2677: Stop of 'ora.evmd' on 'wsjdelll10sty' succeeded CRS-2677: Stop of 'ora.diskmon' on 'wsjdelll10sty' succeeded CRS-2675: Stop of 'ora.INDX.dg' on 'wsjdelll10sty' failed CRS-2675: Stop of 'ora.DATA.dg' on 'wsjdelll10sty' failed CRS-2677: Stop of 'ora.wsjdell.db' on 'wsjdelll10sty' succeeded CRS-4000: Command Stop failed, or completed with errors. wsjdelll10sty$crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.DATA.dg ora....up.type OFFLINE ONLINE wsjd...0sty ora.INDX.dg ora....up.type OFFLINE ONLINE wsjd...0sty ora....ER.lsnr ora....er.type OFFLINE OFFLINE ora.asm ora.asm.type OFFLINE ONLINE wsjd...0sty ora.cssd ora.cssd.type OFFLINE ONLINE wsjd...0sty ora.diskmon ora....on.type OFFLINE OFFLINE ora.evmd ora.evm.type OFFLINE OFFLINE ora.ons ora.ons.type OFFLINE OFFLINE ora.wsjdell.db ora....se.type OFFLINE OFFLINE wsjdelll10sty$ 發現停止Diskgroup失敗 , 只有用sqlplus關閉: wsjdelll10sty$sqlplus '/as sysasm' Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Automatic Storage Management option SQL> shutdown immediate ASM diskgroups dismounted ASM instance shutdown wsjdelll10sty$crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.DATA.dg ora....up.type OFFLINE OFFLINE ora.INDX.dg ora....up.type OFFLINE OFFLINE ora....ER.lsnr ora....er.type OFFLINE OFFLINE ora.asm ora.asm.type OFFLINE OFFLINE ora.cssd ora.cssd.type OFFLINE ONLINE wsjd...0sty ora.diskmon ora....on.type OFFLINE OFFLINE ora.evmd ora.evm.type OFFLINE OFFLINE ora.ons ora.ons.type OFFLINE OFFLINE ora.wsjdell.db ora....se.type OFFLINE OFFLINE 奇怪的是,開啟的時候使用 crsctl start resource -all 可以開啟diskgroup相關的 。 wsjdelll10sty$crsctl start resource -all CRS-5702: Resource 'ora.DATA.dg' is already running on 'wsjdelll10sty' CRS-5702: Resource 'ora.INDX.dg' is already running on 'wsjdelll10sty' CRS-5702: Resource 'ora.LISTENER.lsnr' is already running on 'wsjdelll10sty' CRS-5702: Resource 'ora.asm' is already running on 'wsjdelll10sty' CRS-5702: Resource 'ora.cssd' is already running on 'wsjdelll10sty' CRS-2672: Attempting to start 'ora.evmd' on 'wsjdelll10sty' CRS-2672: Attempting to start 'ora.ons' on 'wsjdelll10sty' CRS-2672: Attempting to start 'ora.diskmon' on 'wsjdelll10sty' CRS-2676: Start of 'ora.evmd' on 'wsjdelll10sty' succeeded CRS-2676: Start of 'ora.diskmon' on 'wsjdelll10sty' succeeded CRS-2676: Start of 'ora.ons' on 'wsjdelll10sty' succeeded CRS-2672: Attempting to start 'ora.wsjdell.db' on 'wsjdelll10sty' CRS-5010: Update of configuration file "/u01/product/oracle/11.2.0/db_1/srvm/admin/oratab.bak.wsjdelll10sty" failed: details at "(:CLSN00011:)" in "/u01/product/grid/11.2.0/crs/log/wsjdelll10sty/agent/ohasd/oraagent_grid/oraagent_grid.log" CRS-2676: Start of 'ora.wsjdell.db' on 'wsjdelll10sty' succeeded CRS-4000: Command Start failed, or completed with errors. wsjdelll10sty$crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.DATA.dg ora....up.type ONLINE ONLINE wsjd...0sty ora.INDX.dg ora....up.type ONLINE ONLINE wsjd...0sty ora....ER.lsnr ora....er.type ONLINE ONLINE wsjd...0sty ora.asm ora.asm.type ONLINE ONLINE wsjd...0sty ora.cssd ora.cssd.type ONLINE ONLINE wsjd...0sty ora.diskmon ora....on.type ONLINE ONLINE wsjd...0sty ora.evmd ora.evm.type ONLINE ONLINE wsjd...0sty ora.ons ora.ons.type ONLINE ONLINE wsjd...0sty ora.wsjdell.db ora....se.type ONLINE ONLINE wsjd...0sty wsjdelll10sty$
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-713041/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle10g RAC (ASM) 資料庫及服務開啟關閉OracleASM資料庫
- Oracle RAC 啟動與關閉Oracle
- RAC+ASM+DATAGUARDASM
- ORACLE DataGuard 關閉啟動Oracle
- 【RAC】啟動/關閉CRS, OHAS, ASM & RDBMS 的步驟ASM
- oracle 11.2.0.1 rac 的 active dataguard的啟動步驟Oracle
- Oracle11g RAC啟動關閉情況大概總結Oracle
- oracle11g dataguard完全手冊--failover &active dataguard(完)OracleAI
- 11g rac ASM下最簡單歸檔開啟/關閉方法ASM
- Oracle10g RAC 關閉及啟動Oracle
- Oracle單例項+ASM啟動與關閉Oracle單例ASM
- Oracle 11g rac 的 active dataguard的啟動步驟Oracle
- RAC常用開啟關閉命令 – SRVCTL用法
- Mongodb開啟與關閉MongoDB
- RAC 資料庫的啟動與關閉資料庫
- Oracle 10g RAC 啟動與關閉Oracle 10g
- Oracle RAC+ASM 關閉全過程OracleASM
- Oracle 11g Data Guard (physical standby - active dataguard) [final]Oracle
- oracle11g RAC 啟動時無法識別ASMOracleASM
- Oracle10g RAC 關閉及啟動步驟Oracle
- rac下啟動關閉與更改歸檔模式模式
- Oracle11g RAC下ASM 的管理與維護OracleASM
- Oracle10g RAC (OCFS) 開啟關閉及日常檢查(總結)Oracle
- RAC常用開啟關閉命令 - CRSCTL和SRVCTL 用法
- Oracle10g RAC開啟關閉過程Oracle
- Oracle 10g RAC正常關閉及啟動順序Oracle 10g
- Oracle10g RAC開啟關閉時候究竟在關閉什麼Oracle
- rac下啟動關閉與更改歸檔模式(zt)模式
- ASM CRS 例項啟動和關閉ASM
- Oracle9i / 10g RAC 啟動與關閉Oracle
- 開啟與關閉oracle的歸檔Oracle
- dataguard standby資料庫的關閉和啟動資料庫
- rac 管理 啟動關閉資料庫資料庫
- ubuntu下開啟/關閉防火牆 及埠 - 命令Ubuntu防火牆
- MySQL服務開啟關閉及登陸- 2MySql
- 【RAC,DATAGUARD】Creating a physical standby from ASM (RAC ) primary之四ASM
- 關閉EBS後重新開啟出現concurrent manager異常及cmclean.sql慢問題[final]SQL
- Oracle11g RAC在例項關閉後自動在啟動例項上歸檔Oracle