本文(wén)檔主要(yào)提供一(yī)份Oracle 11G RAC數(shù)據庫∞↑σ存儲替換操作(zuò)過程
計(jì)劃更換RAC數(shù)據庫共享存儲，即将原存儲上(shàng)的(dΩε$∏e)數(shù)據全部遷移到(dào)新的(de)存₩✔&儲設備上(shàng)，主要(yào)涉及到(dào)OC★§R，VOTING DISK遷移，DATA遷移
| OS Version | Redhat Enterprise Linux 6.5 X86_64 |
| DB Version | Oracle Database 11g Release 2 (11.2.0.σ₹4.0) |
| GI Version | Oracle Grid Infrastructure 11g （11.2.0.4.0） |
| LUN | 設備名 | 大(dà)小(xiǎo) | ASM磁盤名 | ASM磁盤組 | 用(yòng)途 |
| 1 | /dev/ASM_LUN_OCR_01 | 10G | ASM_LUN_OCR_01 | OCR | 保存ocr和(hé)voting disk的(de)信息 |
| 2 | /dev/ASM_LUN_OCR_02 | 10G | ASM_LUN_OCR_02 | ||
| 3 | /dev/ASM_LUN_OCR_03 | 10G | ASM_LUN_OCR_03 | ||
| 4 | /dev/ ASM_LUN_DATA | 100G | ASM_LUN_DATA | DATA | 保存數(shù)據文(wén)件(jiàn) |
| 5 | /dev/ASM_LUN_ARCH | 50G | ASM_LUN_ARCH | ARCH | 保存歸檔日(rì)志(zhì) |
| LUN | 設備名 | 大(dà)小(xiǎo) | ASM磁盤名 | ASM磁盤組 | 用(yòng)途 |
| 1 | /dev/ASM_LUN_OCR_N_01 | 10G | ASM_LUN_OCR_N_01 | OCRN | 保存ocr和(hé)voting disk的(de)信♥←息 |
| 2 | /dev/ASM_LUN_OCR_N_02 | 10G | ASM_LUN_OCR_N_02 | ||
| 3 | /dev/ASM_LUN_OCR_N_03 | 10G | ASM_LUN_OCR_N_03 | ||
| 4 | /dev/ASM_LUN_DATA_N | 100G | ASM_LUN_DATA_N | DATAN | 保存數(shù)據文(wén)件(jiàn) |
| 5 | /dev/ASM_LUN_ARCH_N | 50G | ASM_LUN_ARCH_N | ARCHN | 保存歸檔日(rì)志(zhì) |
備注：新增存儲使用(yòng)UDEV方式管理(lǐ)，本文(wén)檔不(bù)δΩ®記錄新增存儲的(de)詳細處理(lǐ)過程
SQL> select name, TOTAL_MB✔±π, FREE_MB, state, typ $¥e, COMPATIBILITY from γ✔v$asm_diskgroup;
NAME TOTAL_MB≠§ FREE_MB STATE TYPE COMPATIBILITY♠≤₩
---------- ---------- -------←λ$--- ----------- -----±©→ - --------------------
ARCH ¥♣ 102400 100056←± MOUNTED EXTERN 11.2.0.0.0
D☆♣φATA 102400£♣λ 99686 MOUNTED ♥÷'EXTERN 11.2.0.0.0
OCR ©☆ 30720 29794 MOUNTE♥±≤∏D NORMAL 11.2.0.0.0
SQL> sel≤✘ ect GROUP_NUMBER, DISK_NUMBER,♦σ TOTAL_MB, FREE_MB, NAME, PATH from v$as♣$₹m_disk order by 1,2;
GROUP_NUMBER $÷ΩDISK_NUMBER TOTAL_MB FREεσE_MB NAME PATH
------------₩&≠ ----------- ---------- ---------- -± ÷--------- --------------------
1 0 "≠♣< 102400 100056 ARCH_0000 /dev/ASM_LUN_AR ≈λCH
2 0 10σ☆±2400 99686 DATA_0000 /dev/ASM_LUN↓★÷_DATA
3 0 10240 9930 ΩφOCR_0000 /dev/ASM_LUN_OCR_01
3 1 ≤ 10240 9933 OCR_000αΩ1 /dev/ASM_LUN_OCR_02
3 ₽σ≤φ 2 10240 9931 OCR_0<002 /dev/ASM_LUN_OCδ∏R_03
[root@rac2 dev]# ls -l ASM*
brw-rw---- 1 grid λ♥∑asmadmin 8, 96 Aug 23 12:08 ASM_♦↑LUN_ARCH
brw-rw---- 1 gσ♣rid asmadmin 8, 176 Aug 23 12:08 ASM_LUN_ARCH_N
b∑±rw-rw---- 1 grid asmadmin 8, 64 Aug 23 12 &φ:24 ASM_LUN_DATA
brw-rw---- 1 gri✔γ×≠d asmadmin 8, 160 Au'¥♦g 23 12:08 ASM_LUN_DATA_N
brw-rw-↕±γ--- 1 grid asmadmin 8, 16 A∏₽ug 23 12:08 ASM_LUN_OCR_0ε∏ 1
brw-rw---- 1 grid a÷✘& smadmin 8, 32 Aug 23 12:08 ASM_LUN_OCR_02
br>"w-rw---- 1 grid asmadmin 8, 48 Aug 23 12:08 ASM_σ&LUN_OCR_03
brw-rw---- 1 grid asmadmin ©>βφ8, 112 Aug 23 12:24 ASM_LUN_OCR_N_1←™↕
brw-rw---- 1 grid asmadmin 8, 14↔←↓4 Aug 23 12:24 ASM_LU∞N_OCR_N_2
brw-rw---- 1 grid asma∞↔'dmin 8, 128 Aug 23 12:2₽€4 ASM_LUN_OCR_N_3
SQL> create diskg×®¥>roup OCRN normal redundancy disk '/dev/ASM±£¥ _LUN_OCR_N_1','/dev/ASM_LUN_OCR_N_2',•×₩&'/dev/ASM_LUN_OCR_N_3' attribute 'compatible.as←'₽m'='11.2';
Diskgroup created.
查詢←↕©創建結果：
節點1狀态
SQL> select name, TOTAL_MB, FREE_"♣¥↕MB, state, type, COMPATIβ&≥BILITY from v$asm_diskgroup;
NAME TOT¶ ÷≈AL_MB FREE_MB STATE ♥☆→≥ TYPE COMPATIBILITY
---------- ----------₽✘ ---------- --------£±"←--- ------ -------------↔§←-------
ARCH 102400 10Ω0056 MOUNTED EXTERN 11.2.0.0.0
DATA ±→ 102400 99686 MOUNTED EXTERN 11.2.0.♠≠0.0
OCR 30720 ™¥₹§ 29794 MOUNTED NORMAL ♠π™Ω11.2.0.0.0
OCRN 153÷ σ60 15201 MOUNTED NORMAL 11.2.0.0.0€✘α
節點2狀态
SQL> select name, TOTAL_"€←≥MB, FREE_MB, state, type, COMPATIBILITY fro♥πγ✘m v$asm_diskgroup;
NAM≠σ♦E TOTAL_MB FREE_MB SΩ←↔¶TATE TYPE C£σ•πOMPATIBILITY
-----------→∏↔--- ---------- ---------- ->∞---------- ------ ------------
ARCH §σ$® 102400 100056 MOUN™δ&TED EXTERN 11.2.0.0.0
DATA ₽>102400 99686 ≤"₹ MOUNTED EXTERN 11.2.0.0.0
OCR ♥φ§ 30720 29794 ₩© MOUNTED NORM♣♥ AL 11.2.0.0.0
OCRN 0 0 Ωφ★ DISMOUNTED 0.0.0.↕₽π¥0.0
SQL> alter diskgroup OCRN mount≥∑;
Diskgroup altered.
SQL> se ↓$♦lect name, TOTAL_MB, FREE_MB, s♦•tate, type, COMPATIBILITY from v$asm_diskgroup;
N©<AME TOTAL_MB FREE_MB STATEφ" TYPE COMPATIBI♣↕§LITY
-------------- ---------- ---------- ----&••------- ------ -----------------♠εσ---
ARCH 102400 100056 $ MOUNTED EXTERN 11.2.0.0.0
DATA ≈ 102400 99686 MOUNTED EX♠£λTERN 11.2.0.0.0
OCR 30720 ¥≈∏♦ 29794 MOUNTED NOR× 'δMAL 11.2.0.0.0
OCRN 15360 15075 ♦≈↔ MOUNTED NOR¥∏MAL 11.2.0.0.0
[grid@rac1:/home/grid]$cat /etc↔€®</oracle/ocr.loc
ocrconfig_∑¥≠loc=+ocr
local_only=FALSE
[grid@rac1:/home/gr☆♣₩✘id]$ocrcheck -config
Oracl ≥α e Cluster Registry configurat£♦ion is :
Device/File Name : +ocr≥$®
[root@rac1 bin]#
[root@rac1 bin]# pwd
/u01/11.2&α.0/grid/bin
[root@rac1 bin]# ./ocrconf ✔ ig -add +OCRN
[root@rac1 bin]# α§≈./ocrcheck -config
Oracle Cluster Registry♣₹ configuration is :
Dev★<αβice/File Name : δ<+ocr
Device/File Name ><£ : +OCRN
[root@rac1 bin]# more /eβ♠tc/oracle/ocr.loc
#Device/file getting ✘↔replaced by device +OCRN
ocrcon↑fig_loc=+ocr
ocrmirrorconfig_loc=+OCR✔ N
local_only=false
[root@rac1 bin]# ./ocrche§ ck
Status of Oracle Cluster Regi☆≈stry is as follows :
Version∏← : 3
Total¥∏¥≈ space (kbytes) : 262120
§Used space (kbytes) <≥ : 3188
Available space (kbytes) :©δΩ 258932
ID : 2041187≤≤✘φ104
Device/File Name : +ocr
Device™ ↓/File integrity check succeede≠σ→d
Device/File Name : +OCRN
Device/F ↔ile integrity check succeeded
De↓εvice/File not configu₩δ ©red
Device/File not confiββ₽gured
Device/File not×δ configured
Cluster registry int$πegrity check succeeded
Logical cor₽♠≥βruption check succeede"≤ d
[root@rac1 bin]# ./crsctl querΩγφy css votedisk
## STATE File Universal Id∏☆™ File Name Disk gro♥∑"εup
-- ----- -----------------φ≈ -------¶Ω↑-- ---------
ONLINE >®↓™75babc4949ba4f38bf79d6Ω•51db251e26 (/dev/ASM_LUN_OCR_01)★✔∑ [OCR]
ONLINE a585d03909864f9ab<§±₹f259620c302d575 (/dev/ASM_LUN_OCR_↑♠λ↔02) [OCR]
ONLINE 73541e9160e04fafbf76f73§α✘782544288 (/dev/ASM_LUN_OC↕≥π÷R_03) [OCR]
Located 3 voting d±$ ∏isk(s).
[root@rac1 £♥☆γbin]#
[root@rac1 bin]# ./crsctl replace voβ tedisk +OCRN
Successful addition of vot®÷βing disk a12f08433fdc4f50bf9dbφ☆α48a99779782.
Successful addition o₩" f voting disk 2b71e53 ↕×bdb764fd5bf61ef3e351¥24048.
Successful addition of voting d₽αisk 3d59137860564f1dbf18c313f405b87f.
Succ₩∑•essful deletion of v±oting disk 75babc4949ba4f38bf7&∏₹9d651db251e26.
Successful deletion ÷≈of voting disk a585d03909864f✘¶∞×9abf259620c302d575.
Success∏™ful deletion of voting disk 73541e9160e04f↔☆α©afbf76f73782544288.
Successfu☆₹lly replaced voting disk group ✘→ ±with +OCRN.
CRS-4266: Voting file(s) suc₽↕cessfully replaced
查詢結果
su - grid
sqlplus§∞ / as sysasm
SQL> se✔×φ™lect group_number,name,state,type,total_mb,free←•↔≈_mb,voting_files,compa∑≈tibility from v$asm_d ©iskgroup;
GROUP_NUMBER ✘☆NAME STATE 'ε★£TYPE TOTAL_MB FREE_MB V C™ππ OMPATIBILITY
----------- ----- ----------λ÷∏- ------ --------- -----♠γ£∏--- - ----------
1 ARCH →∞"> MOUNTED EXTERN 102400 &∏≤β 100056 N 11.2.0.0.0
2<↕π¶ DATA MOUNTED EXTERN ε 102400 99686 N 11.2.0.0.0
3 ↑≤§ OCR MOUNTED δ• NORMAL 30720 29890 π×↓N 11.2.0.0.0
4 OCRN Mλ→OUNTED NORMAL 15360 ±→∞← 14436 Y 11.2.0.0.0
[root@rac1 bin]# ./o♠₩$φcrcheck
Status of Oracle Cluster Regisσ↔₽try is as follows :
Version : φ € 3
Total space (kbytes) : 262120
£¶Used space (kbytes) : ᧶ 3188
Available space (kbytes) : 258932
ID φ♦♣ ∞∞ : 2041187104
Device/File Name↑ ✔♥ : +ocr
Device/File integrityδ∏ check succeeded
Device/File Name : <ε +OCRN
Device/File integrit ☆'y check succeeded
Device/File not configure¶Ωd
Device/File not configured
Device/File not confφα₹igured
Cluster registry integrity check succeede∑α'→d
Logical corruption check su☆≤&★cceeded
[root@rac1 bin]# ./crsctl query css vot∑>edisk
## STATE File Universal Id αδ File Name Disk group
-- ----¥÷÷- ----------------- λ§ --------- λ∏£↔---------
ONLINE a12f08433fdc4f50bf9db48a9977978☆≥2 (/dev/ASM_LUN_OCR_N_1) [OCRN]
O★•✔←NLINE 2b71e53bdb764fd5bf61ef3e3512404↕δ→&8 (/dev/ASM_LUN_OCR_N_2) [OCRN]
ONLINE↑ 3d59137860564f1dbf18c313f405b87f (/de→♠↔v/ASM_LUN_OCR_N_3) [OCRN]
σ"δ♦Located 3 voting disk(s).
節點1
SQL> show parameter spfile
NAME ε ±∏↑ TYPE VALUE
--∏≥≤"--------------------------♠§×-------- ----------- ---------$←λ×---------------------σΩ←
spfile ★∑ string + ♣πOCR/uec-cluster-db/asmparamet
erfile/registry.2δ≤53.952171359
節點2
SQL> show parameter spfile
N↕£AME TYPE ¥>≥• VALUE
-----------------------÷↑------------- ----------- ----₩♣--------------------------
spfile ≈σ≤↑ string +OCR/uec-clustσ§♦€er-db/asmparamet
erfile/registry.25&λ→3.952171359
SQL> create pfile='/tmp/as↕∏♦≈mpfile.ora' from spfile;
File created★₩.
SQL> create spfile='+OCRN' from pfile★β₩♥='/tmp/asmpfile.ora';
File &§∑"created.
SQL> show parameter♦ > spfile
NAME ↔ TYPE VA≠α£LUE
------------------------------------ -♠ ---------- ---------------------------↔<---
spfile ☆ string +OC<εR/uec-cluster-db/asmparamet
erfile↕/registry.253.952171359
SQL>
[root@rac1 bin]# ./ocrconfig ₽ -delete +OCR
[root@rac1 bin]# ./ocrcheck
Status oδf Oracle Cluster Registry →≠α'is as follows :
Version : φγ☆♠ 3
Total space (kbytes) : 262120
Use™"d space (kbytes) : 3188
Available sp≈π±ace (kbytes) : 258932
ID ♥₽π₹ : 2041187104
Device/File Name :★♦> +OCRN
Device/File int←€↕∑egrity check succeeded
De≥α"£vice/File not configured
Device/File not c®•onfigured
Device/File not configured
Devi εce/File not configured
Cluster r✘βegistry integrity check succeeded
Logical™∏Ω> corruption check su♣γ<cceeded
[root@rac1 bin]# ☆ ♣./crsctl query css votedisk
#★<↕→# STATE File Universal Id π♣ File Name Disk group
-- ----- - ←---------------- --------- -------✔→--
ONLINE a12f08433f→&≠dc4f50bf9db48a99779782 (/dev/ASM_LUN_OCR₩&™_N_1) [OCRN]
ONLINE 2b71e53bdb764fd5bf61ef3e351π&÷24048 (/dev/ASM_LUN_OCR_N_2) [OCRNΩ>®]
ONLINE 3d591378605$"©64f1dbf18c313f405b87f (/dev/ASγ™>M_LUN_OCR_N_3) [OCRN]
Loc$ ≤ated 3 voting disk(s).
cd /u01 /u01/11.2.0/grid/bin/
cr ↓sctl stop cluster –all
crsctl start'¶↔ cluster –all
SQL> show parameter spfil®→•φe
NAME ♥ TYPE VALUE
--------------------------€Ω↔---------- ----------- -----------------------β§-------
spfile εε∑♠ string +OCRN/uec-cl✘¥♠♣uster-db/asmparame
terfile/registry.253.952617053↔λ♥&
SQL> select group_number,naγπme,state,type,total_mb,fr₩♥&ee_mb,voting_files,c∞ε×ompatibility from v$asm_diskgroup;
GROU↔Ω<&P_NUMBER NAME STATE TYPE ↔"→↔ TOTAL_MB FREE_♥÷↓MB V COMPATIBILITY✔↓β₩
------------ ----- -------- ---- £←--- ------- ------- -- -------------
1 ₹€∑ ARCH MOUNTED EXTE>RN 102400 100051 N 11.2.0.0.0
2 ♥÷δ¥ DATA MOUNTED EXTERN ≈≤102400 99686 ∞£€ΩN 11.2.0.0.0
3 OCRN MOUNTED ☆≥♦ NORMAL 15360 14434 Y 11.2.0.♣γ•0.0
0 OCR MOUNTED NOR©≥MAL 30720 298 φβ90 Y 11.2.0.0.0
SQL>
S₹β≠§QL> Select GROUP_NUMBER,NAME,STATE,ty←₹pe,TOTAL_MB,free_mb,VOT≠↕ING_FILES,COMPATIBILITY from v$asm_diskgr≤→oup;
GROUP_NUMBER NAME STATE TYPE ≤&TOTAL_MB FREE_MB V ★₩♦> COMPATIBILITY
-------≥<™----- ----- -------- ------∞σ≈"- ------- ------- ¥¥> -- -------------
1 ARCH ₽σ↑₽ MOUNTED EXTERN 102400 100051 N €₩ 11.2.0.0.0
2 DATA MOUNTED γ∏γEXTERN 102400 99686 N 11.2.0.≥>0.0
3 OCRN MOUNTED ¥ NORMAL 15360 14434 Y 11.2.0.0.0↕δ∞✔
0 OCR DISMOUNTED 0 ↓® 0 N 0.0.0.0.0
将一(yī)個(gè)節點的(de) OCR磁盤卸載
SQL> alter diskgro₽↓up ocr dismount;
Diskgroup alterαγed.
SQL> drop diskgroup OCR inclu¥'☆$ding contents;
Diskgroup droppeσ$d.
注：舊(jiù)的(de)磁盤組隻允許在一(yī)個(gè÷ ♦)節點mount，如(rú)果發現(xiàn)多(duō)個(gè)節點mount，需¶↔÷₩要(yào)在其他(tā)節點dismount，否則會(huì)删除不(bù)掉舊(©₩jiù)的(de)磁盤組。
SQL> drop diskgr≥φ✘→oup OCR including contents;
←→drop diskgroup OCR including contents
*
ERROR→φ at line 1:
ORA-15039: diskgroup n¥¥↔↕ot dropped
ORA-15073: diskgroup OCR is•→☆ mounted by another ASM instance
在節點1上(shàng)以grid用(yòng)戶登陸
sqlplus / as sysa ↔±∞sm
SQL> create diskgroup DATAN external re♠αdundancy disk '/dev/ASM_✔∏¶LUN_DATA_N' attribute 'compat€×ible.asm'='11.2';
SQL> create diskgroup ARCHN ₩✘₽external redundancy disk '/dev/ASM_LUN_AR♥£ ♣CH_N' attribute 'compatible.as" ε©m'='11.2';
節點1查詢
SQL> S₽↔←↔elect GROUP_NUMBER,NAME,STATE,ty≥¥δpe,TOTAL_MB,free_mb,VOTIN€πG_FILES,COMPATIBILITY from v$asm_diskgroup;
GRO ΩUP_NUMBER NAME STATE TYPσ♥∑∏E TOTAL_MB FREE_MB V COMPATI♥¥BILITY
------------ ------- ------→π----- ------ ---------•☆- ---------- - ---------------
1 ARCH MOσ♦ UNTED EXTERN 102400 97012 N 11.2.®λ¥0.0.0
2 DATA MOUNTED EXTERN 102400 ±≠ 99686 N 11.2.0.0.0
3 OCRN MOUNTED € ₽ NORMAL 15360 14434 Y 11.2.0.0.0
4 DA©®↑±TAN MOUNTED EXTERN '§ 20480 20428 N 11.2.0.0.0
→&₽5 ARCHN MOUNTED EXTERN 10240 ÷→10188 N 11.2.0.0.0
節點2查詢
SQL> Select GROUP_N×λ§UMBER,NAME,STATE,type,TO☆♦× TAL_MB,free_mb,VOTING_FILES,COMPAT↓ '↔IBILITY from v$asm_diskgroup∞♠;
GROUP_NUMBER NAME STATE TYPE T♥₽OTAL_MB FREE_MB V COMPATIBILI∞₽"TY
------------ ------- ----------- ------ -----Ω→÷----- ---------- - -----------$♣≠----
1 ARCH MOUNTED EXTERN "↑★102400 97012 N 11.2.0.0.0
2 DATA MOUNT→₩ED EXTERN 102400 99686 N 11.2.0.0.∑Ω★↔0
3 OCRN MOUNTED ≠₹γ NORMAL 15360 14434 Y 11≈☆.2.0.0.0
0 DATAN DISMOUNTED → •Ω 0 0 N 0.0.0.0.0
0 €α☆ARCHN DISMOUNTED ↑"≤0 0 N 0.0.0≈$.0.0
節點2上(shàng)手動mount磁盤組
Alt♠♠₹er diskgroup datan m☆ ♣£ount;
Alter diskgroup archn mount;
查詢spfile和(hé)控制(zhì)文(wén)件(jiàn ₹ )位置
SQL> show paramet™$↕±er spfile;
NAME ≤®♦ TYPE VALUE
-----------------₩↕------------------- --------φλ±™--- ------------------------------
spfile ↔↑≈ ±∏ string +DATA/uecdb/spfi♠¶leuecdb.ora
SQL> show paramσ"€÷eter control
NAME ±✘≥ ∏∏↑ TYPE VALUE
---------------♠®₹--------------------- -----------↔ ₽ ------------------------------
contro♠≠l_file_record_keep_time integer ☆>β÷ 7
control_files st€£¥ring +DATA/uecdb/controlε®01.ctl, +DA
TA/uecdb/control02.ct↔φ♠l
control_management_pack_access string ♦"♣≤ DIAGNOSTIC+TUNING
關閉數(shù)™>÷據庫
srvctl stop database -d uecdb
在節點1上(shàε§Ωng)将實例啓動到(dào)nomount狀态Ω™✘
Startup nomount
創建一(yī)個∏δ(gè)pfile
create pfil↕∞e='/tmp/racpfile' from spfile;
通(tōng)過rma♠•n将控制(zhì)文(wén)件(jiàn)還(hái)原到(dào)新的(de)存儲+DATAN☆↕✔
[oracle@rac1:/home/or®¥acle]$rman target /
Recovery Ma✘←nager: Release 11.2.0.4.0 - Production on We→€d Aug 23 13:26:07 2017
Copyright (c) 1982, β"δ↕2011, Oracle and/or its affiliat★¥es. All rights reserved.
connected to t₩<≥∑arget database: UECDB (not mounted) ¶
RMAN> restore controlfi↑&≥le to '+DATAN' from '+DATA/uecdb/control01.↕¶ ↓ctl';
Starting restor₽ e at 2017-08-23 13:27:5♠π 1
using target database cont•Ω±rol file instead of recovery catalo¥<$g
allocated channel: ORA_DIS®'K_1
channel ORA_DISK_1: S≤♥ΩαID=134 instance=uec1 devα→≥♦ice type=DISK
channel ORA_DISK_1: copied co©∑₩ntrol file copy
Finished restore at 2017-08-23 13↕€ε∑:27:59
RMAN> res∏€™☆tore controlfile to '+DATAN' f•€♠rom '+DATA/uecdb/control02.ctl';
Starting restor₽φ₹∏e at 2017-08-23 13:28:14
using c¶σ♦hannel ORA_DISK_1
ch♠☆γannel ORA_DISK_1: copied control file copy
Fin ₩♣ished restore at 2017-08-23 13:2≈ 8:21
對(duì)pfile文(wén)件(jià&δ£n)進行(xíng)修改，修改控制(zhì)文(wén)件(jiàn)位置，修改數(shù)據文↓Ω≠(wén)件(jiàn)默認創建位置，修改快(kuài)速恢∑←複區(qū)路(lù)徑
vi /tmp/racpfilφ→e
uec1.__db_cache_size=1560281088
uec2.__dε®b_cache_size=1761607680
uec1.__j•×ava_pool_size=16777216
uec♠♦≥↑2.__java_pool_size=16777216
uec1.__large_pool_s® ₽ize=33554432
uec2.__large_pool_size=335544Ω↑£→32
uec1.__oracle_base='/u01/app/o∏$φracle'#ORACLE_BASE set from environment
uec1.__p™εga_aggregate_target=838860800
u₽¶♥ec2.__pga_aggregate_target=838860800
uec1.__★γ₽sga_target=2483027968
uec2.__sga_target=2♠α ☆483027968
uec1.__shared_io_pool_siφ©ze=0
uec2.__shared_io_pool_size=0
uec1.__sha₩₽≠♠red_pool_size=838860800
uec2.__shared_™₩♦pool_size=637534208
uec1.__streams_pool_sizδ× e=0
uec2.__streams_pool_size=0
*.audit_file_dest∏¶='/u01/app/oracle/admin/uecdb/adump'
*.audit_t ↓rail='db'
*.cluster_database=true
*.compat✘¥₩ible='11.2.0.4.0'
#*.control_f>♠≠iles='+DATA/uecdb/cont↕< ♦rol01.ctl','+DATA/uecdb/control02.ctl'
*.co₽★&ntrol_files='+DATAN/UECDBλα∞/CONTROLFILE/current.256.952781275','+DATAN/☆♣UECDB/CONTROLFILE/current.257.952781295'
*.εγdb_block_size=8192
*.db_create_f γ"™ile_dest='+DATAN'
*.db_domain=''
*.σε£ db_name='uecdb'
#*.db_recov₹•ery_file_dest='+ARCH'
λγδ€*.db_recovery_file_dest='+ARCHN'
↕λ>*.db_recovery_file_de♦αst_size=6005194752
*.diagnostic_dest='/u01/app♠∏/oracle'
uec1.instance_number=1
uec>₽2.instance_number=2
#*.lo↔₽×g_archive_dest_1='LOCATION=+✔δΩARCH'
*.log_archive_dest_1='LOCATION=+ARCHN'
*.lo>♥©g_archive_format='%t_%s_%r.d>'÷bf'
*.open_cursors=300
*.pga_aggregate_ta"≠<$rget=825229312
*.processes=150
*.remote₽>≤≠_listener='rac-scan:1521'
*.r♥ε§emote_login_passwordfile='e±¶£xclusive'
*.sga_target=≠•♣≈2475687936
uec2.thread=2
ue♦<c1.thread=1
uec1.undo_tabl≠∞→☆espace='UNDOTBS1'
uec2.undo_tabl♥&€πespace='UNDOTBS2'
在節點1上(shàng)使用(yβ₽™≈òng)修改過的(de)pfile啓動到(dào)mount狀态
SQδ↓¥L> startup force mount pfile='/tmp/ra&Ωcpfile';
ORACLE instance start↑€ed.
Total System Glob₹'al Area 2471931904 bytes
Fixed S πize 2255752 bytes
V§<€ariable Size 88×∞₹9193592 bytes
Database Buffers 15 ∑60281088 bytes
Redo Buffers Ω 20201472 bytes
Database mounted.
SQL>
創建→φ₹spfile
SQL> creat♥↓¥€e spfile='+DATAN/uecdb/spfileuecdb.ora' & from pfile='/tmp/racpfile$£';
File created.
srv₽πεctl修改數(shù)據庫參數(shù)文(wén)件(jiàn)位置
srvctl modiΩ αγfy database -d uecdb -p +DATAN/uecdb/spfileuecdb✔ .ora
srvctl config database -d uecdb
Database uε<∑nique name: uecdb
Database n® ↕₹ame: uecdb
Oracle home: /u01"£/app/oracle/product/11.2.0/db_1
Or≠ ≠¶acle user: oracle
Spfile: +DATAN/uecdb/spfil÷ euecdb.ora
Domain:
Start options: open
Stop op♠←₩®tions: immediate
Database role: PRεIMARY
Management policy: AUTOMATIC
Seπεrver pools: uecdb
Database instance←'s: uec1,uec2
Disk Groups: DATA,ARCH↔¶€,DATAN
Mount point paths:
S©↓ervices:
Type: RAC
Database is administrator®∞ managed
啓動數(shù)據庫實例
srvctl↔≥♥≈ start database -d uecdb
使用(yòng)rman backup as copy遷移數(shù)據文(wén)件(ji₽εàn)
[oracle@rac1:/home/oracle]$rman target ∞↕/
Recovery Manager: Release 11.2.Ω ♦♠0.4.0 - Production on Wed Aug 23 17:29:30 ∏→2017
Copyright (c) 1982, 2011,<φ Oracle and/or its affili¶<'≤ates. All rights reserv∞πed.
connected to target database: UECDB (DB↑ ID=505357948)
RMAN> backup a§∞₽s copy database format '+D ★∑£ATAN';
Starting back♠£¶up at 2017-08-23 17:29:36
using tar"©αget database control file instead of r<>∞ ecovery catalog
allocated channe₽÷l: ORA_DISK_1
channel ORA_DI♣ 'SK_1: SID=13 instance=uec→↑€≤1 device type=DISK
channel α≈αORA_DISK_1: starting datafil↑e copy
input datafile file number=00001 name=+DAT™∞λA/uecdb/datafile/system.260.952182827
outpu≤Ωt file name=+DATAN/u§≈©ecdb/datafile/system.2≠δ59.952795781 tag=TAG20170823T172939 RECID=1 STAMP☆±δ =952795861
channel ORA_DISK_1:€≥ datafile copy complete, elapsed time: 00:01: ±™≠25
channel ORA_DISK_1: starting datafile ₽₽copy
input datafile fiδ→le number=00002 name=+DATA/uecdb/datafile/sysaδ£↑ux.261.952182897
outp≥★ut file name=+DATAN/uecdb/datafile/sysau'§₹x.260.952795865 tag=TAG2017082≠λ♦3T172939 RECID=2 STA αMP=952795936
channel ORA_DISK_1¥<": datafile copy complete, elap✘∑¶πsed time: 00:01:15
channel ORA_DISK_1: startin←☆α≠g datafile copy
input datafile file nuδ→mber=00003 name=+DATA/uecdb/data>"♥file/undotbs1.262.952182955
output file name γ=+DATAN/uecdb/datafile/undotbs1.261.↔£δ952795941 tag=TAG20170823T17¶ 2939 RECID=3 STAMP=952795966
channel ORA_DISK_1♠★¥≈: datafile copy complete, elapsed ti∞©≈₩me: 00:00:35
channel ORA_DISK_1: starting♣δ λ datafile copy
input datafile file number=00004 n£ ame=+DATA/uecdb/datafile/undotbs2.264.₽ 952182995
output file na¶₽me=+DATAN/uecdb/datafile/undotbs2.•₹♥262.952795977 tag=TAG20170823T172939 REC ∞≤ID=4 STAMP=952796000
cha βnnel ORA_DISK_1: datafile copyβα→∞ complete, elapsed time: 00:00:25
§σchannel ORA_DISK_1: starting datafile cop←≠y
input datafile file ₹←number=00005 name=+DATA/uecdb/d<☆≥atafile/users.265.952183015
output f'α∞±ile name=+DATAN/uecdb/datafile/use♠₽rs.263.952796001 tag=TAG20170823T17293×≈9 RECID=5 STAMP=952796002
channel←☆× ORA_DISK_1: datafile copy co↔σ'mplete, elapsed time§: 00:00:01
Finished backup at 2017-0≥α₽8-23 17:33:22
Starting Co≥Ω♠∏ntrol File and SPFILE Autobackup at 201λδ♦7-08-23 17:33:22
piece handle=+Aλ☆♥RCHN/uecdb/autobackup/2017_08_23/s_95279600∑← ✘2.257.952796005 comment=↔₽•¥NONE
Finished Control File and SPFILE Au✔★tobackup at 2017-08-23 17:33:29
RMAN>€α;
關閉數(shù)據庫并啓動到(dào)m♦Ω↔δount狀态，對(duì)數(shù)據文(wén)件(jiàn)路(lù)徑進行(xíng©→)調整
srvctl stop database -d uecdb - ∑'o immediate
[oracle@rac1:/home/oracle]$srvctπ©l stop database -d uecdb -o ∞ ≥immediate
[oracle@rac1:/home/ora★αcle]$sqlplus / as sysdba
SQL*Plus: Release 11.δ÷2.0.4.0 Production on Wed Aug 23 ✘>17:35:45 2017
Copyright (c) 1982, 2013, Or♠×&©acle. All rights reserved.
Connected to an idl✘αe instance.
SQL> star&'tup mount
ORACLE instance started.
Total S'>™≥ystem Global Area 2471931904 bytes
F×£Ωixed Size &✔ 2255752 bytes
Varia♦↔ble Size ±Ω 889193592 bytes
Database Buffers ≈↓ 1560281088 bytes
Redoα¶ε Buffers 20201472 bytes
Da€✘₩₩tabase mounted.
SQL>≠; exit
Disconnected from Oracle Databφ★★ase 11g Enterprise Editio↕§÷♦n Release 11.2.0.4.0♦₽ε - 64bit Production
With the Partitioni₽σδ ng, Real Application C₩↔♥lusters, Automatic Storage Management, ★≥OLAP,
Data Mining and Real Application Test"ing options
[oracle@rac1:/home/orδ♣πacle]$rman target /
αRecovery Manager: Release 11.2.0.4.0 - Prod★♥→×uction on Wed Aug 23 17:36:33 2017×≈
Copyright (c) 1982, 2011, Orac¥≈ le and/or its affiliates. > All rights reserved.
con ¶βnected to target database: UEC>™DB (DBID=505357948, not open)
RMANγ•> switch database to copy;
using target →↕'↔database control filπ÷¥e instead of recovery catalog
datafile ≥©©≥1 switched to datafile copy "+DATAN/uecdb/♥λ™datafile/system.259.9527957σ•→81"
datafile 2 switched to d£←₽atafile copy "+DATAN/uecdb/datafile/sysaux.γ∑260.952795865"
datafile 3 switched to datafile§≤> copy "+DATAN/uecdb/datafile/undotbs1.261.9♦✘≈52795941"
datafile 4 switched to datafile cop ♣←βy "+DATAN/uecdb/datafile/undotbs₹↓∞"2.262.952795977"
datafile 5 switched to dataf"α>×ile copy "+DATAN/uecdb/datafile/users.263.952✘↓π≤796001"
RMAN>
對(duì)數←©☆&(shù)據庫進行(xíng)recover一(yī)次
[oracle@rac1:↓€/home/oracle]$rman target /
Re"÷δ✔covery Manager: Release 11.2.0.4.0 - Production oφ©n Wed Aug 23 17:38:1↔ ×€0 2017
Copyright (c) 1982, 2011, Oracle an§♣→ d/or its affiliates.ε←™€ All rights reserved.
connected to target d✘₽atabase: UECDB (DBID=505357948, not ↓∑open)
RMAN> recover database;
Startin♠Ωπαg recover at 2017-08-23 17:38:26
u$¥↑sing target database control file insφ®tead of recovery catalog
allocated chann¶δ€αel: ORA_DISK_1
channel O↔ ÷ RA_DISK_1: SID=196 instance=uec1 device t§β•ype=DISK
starting media recovery
media r ¶ecovery complete, el₹$ ₩apsed time: 00:00:03
Finishe↕ ®"d recover at 2017-08-23 1σ₹≤$7:38:32
RMAN>
啓動數(shù)據庫
srvctl start data ↔base -d uecdb
SQL> select status,♣↔♣enabled,bytes/1024/1024,name from v$tempfil®✔e;
STATUS ENABLED BYTES/1024/1024 NAME
----♠¥§≥--- ---------- --------------- -------€↓------------------------------α♠--------
ONLINE READ WRITE 2>π0 +DATA/uecdb/tempfile/temp.263®™ .952182977
SQL> select tabl× espace_name,file_name←' ∏,status from dba_temp_files;
TABLESPACE_γNAME FILE_NAME Ω STATUS
----------------- ≥λ★&--------------------------------------------- -γ↑↔φ------
TEMP +DATA/uecdb/tempfε←$↕ile/temp.263.952182977 ×β∑ ONLINE
SQL> alter t<α×¥ablespace temp add te mpfile '+DATAN/uecdb/tempfile/tempfile01.dbfπ ∞' size 100M;
Tablespace al♦Ωtered.
SQL> alter database teδ★£mpfile '+DATA/uecdb/tempfile/temp.26↔↕3.952182977' drop including datafiles;
Database ₽∏ altered.
SQL> select a.group#,a.thread#≤"£,a.bytes/1024/1024,a.status,b.member from v$™"log a,v$logfile b where a.group#=b.Ω™←group#;
GROUP# THREAD# A.BYTES/1024/1024 STAT¥☆US MEMBER
---------- -δ →--------- ----------------- ---------- -----¶₽--------------------
1 ★↔ו 1 200 ™₩CURRENT +DATA/uecdb/redo01€∏.log
2 1 200 ©♠γ®INACTIVE +DATA/uecdb/redo02.log
3 δ♥ 2 200 CURRENT +DA$×TA/uecdb/redo03.log
4 ↕σ 2 200 I★׶NACTIVE +DATA/uecdb/redo04.log
SQL> al↕✔ter database add logfile thread 1 gβ<δ✔roup 5 '+DATAN/uecdb/redo05.log' size 200M;£≤
Database altered.
SQL> alter database add>→> logfile thread 1 group 6 '+DATAN/uecdb/redo06.§™✔πlog' size 200M;
Database altered.
SQL> altβ≠er database add logfile thread 2 group 7 '+DATAN↕™γ/uecdb/redo07.log' size 200M;
Database altered.
SQL> alter database add♠λ logfile thread 2 group 8 '+DATANΩ≈/uecdb/redo08.log' size 200M;
Database alter•εΩed.
SQL>
SQL> select a.groupα✘#,a.thread#,a.bytes/1024/1024,a.status,b.mem↑βber from v$log a,v$lπ♠®ogfile b where a.grou♣×p#=b.group#;
GROUP# THREAD# A.BYTES/1024δ✘♦/1024 STATUS MEMBER
------£≥<→---- ---------- ----------------- ---------- --ε¶-----------------------
1 1 ≤∑< 200 CURRENT +DAT→∑A/uecdb/redo01.log
2 ♦≈₩ 1 Ω200 INACTIVE +DATA/uecdb/redo02.log
5 ₽®→ 1 200 UNU ÷≥SED +DATAN/uecdb/redo05.log
3 '₩ 2 ÷®α 200 CURRENT +DATA/uecdb/redo03.log
4 →γ 2 200 IN←£•♣ACTIVE +DATA/uecdb/redo04.lo₹"₹g
6 1 200 UNUSED ♦ π +DATAN/uecdb/redo06.log
7 2 &×♣ 200 UNUSEDβ®γ® +DATAN/uecdb/redo07.log
8 ↔δ↕★ 2 200 UNUSED +DATAN/♦"≈uecdb/redo08.log
執行(xíngγ&™↑)日(rì)志(zhì)切換，将當前使用÷σ≠(yòng)的(de)切換到(dào)新的(d♦γγe)redo日(rì)志(zhì)
SQL> alter system archive ₩×φlog current;
System altered.
SQL> aφ§←↑lter system checkpoint ↔ δ;
System altered.
SQL> se•β♠lect a.group#,a.thread#,a.bytes/1024/1024,a.stα∞atus,b.member from v$log a,"σv$logfile b where a.group#♣¶Ω<=b.group#;
GROUP# THREAD# A.BYTES/↔∏™1024/1024 STATUS MEMBER
---------- -------≥&♣δ--- ----------------- -----¥----- -------------------∞&♥------
1 1 200 INAγCTIVE +DATA/uecdb/redo01.logε$₹
2 1 200 INACTIVE +DA↓£TA/uecdb/redo02.log
5 1 §←φ 200 CURRENT "€€γ +DATAN/uecdb/redo05.log
3 2 ®π 200 INACTIVE +DATA/uec ₽db/redo03.log
4 ≥✔₹ 2 200 INACTI®∑§§VE +DATA/uecdb/redo04.log
6 1 ✘≤ 200 UNUSED +DATAN/uecdb/∏αredo06.log
7 2 ★₩ 200 CURRENT +DATAN/uecdb/redo07.log≈€$♥
8 2 200 UNUSED +D↓α≈ATAN/uecdb/redo08.log
8 rows selec© ted.
SQL> alter database drop logβ≈•file group 1;
Database al↕™←¶tered.
SQL> alter databa≈☆♥se drop logfile group 2;
Database altered.
SQL>λ✔✘☆; alter database drop logfile gβπroup 3;
Database altered.
SQL>→₽ alter database drop log☆¥®file group 4;
Database ₽ ∑altered.
SQL> sele απ∏ct a.group#,a.thread#,a.bytes/1024/1024,a.statλ≤us,b.member from v$log a,v$logfile$₽¥ b where a.group#=b.group#;
GROUP# TH∑ε₹αREAD# A.BYTES/1024/1024 STATUS MEMBER
α×---------- ---------- ----------------®₹λ- ---------- ---------------------↕ ε----
5 1 ↕€™★ 200 CURRENT +DAT©☆αAN/uecdb/redo05.log
6 &׶ 1 200 UNUSED +DATAN/uecσΩ¥db/redo06.log
7 2 • 200 CURRENT +DATAN/uecdb/redo07.log
8 ♦<♠ε 2 ♣ 200 UNUSED +DATAN/uecd÷₹₩b/redo08.log
SQL> select name,state,total_mb,free_mbφ®♠ from v$asm_diskgroup;
NAME ★Ω£ STATE TOT קAL_MB FREE_MB
------------------------------∞£ ----------- ---------☆§Ωγ- ----------
ARCH ↓♦£÷ MOUNTED 102400 97012
DATAβ≈ε₹ MOUNTED ¥₽>★ 102400 99707
OCRN ★γ MOUNTED 15360 14434
γ€DATAN MOUNTED ★π 20480 17445
ARCHN ♦£ MOUNTED 10240 ♠★≈★ 6933
登陸節點2，将需要(yào)卸載的(de)磁盤組d≠♠₹ismount
SQL> alter diskgroup arcγ<↓h dismount;
Diskgroup altered.
SQL> alter di±↑skgroup data dismount;
Diskgroup altered.
注>∞<：舊(jiù)的(de)磁盤組隻允許在一(yī)個(gè)節點mount，如(φ★↔≤rú)果發現(xiàn)多(duō)個(gè)節點mount，£∏需要(yào)在其他(tā)節點dismount，否則會(huì)删₩π除不(bù)掉舊(jiù)的(de)磁盤組。
SQL> drop diskg✘roup ARCH including contents;
drop diskgr✔©oup ARCH including c✔πontents
*
ERROR at line 1:
ORA-15039: diskgro≥ββup not dropped
ORA-15073: diskg≠∏roup ARCH is mounted by another ASM instanc✔™e
删除diskgroup
SQL> dוσrop diskgroup arch including contents;★≥≠
Diskgroup dropped.
SQL>§≥★> drop diskgroup data including c✔↔ontents;
Diskgroup dr↓Ω'÷opped.
SQL> select name,state,total_mb,fre§≤↔e_mb from v$asm_diskgroup;
NAME ©βγ∑ ST• ATE TOTAL_MB FREE_MB
- ∑----------------------------- ------€γ↔----- ---------- ---------₩ '-
OCRN ∏©¥↕ MOUNTED 153&σ∞♦60 14434
DATAN MOUπ¥÷NTED 20480 17445
ARCHN ×←ε± MOUNTED Ω←π 10240 6933
[grid@rac1:/home/grid]$↓&crs_stat -t -v
Name ♥&Type R/RA F/FT Target St§↔♦ate Host
-------------------∑↔-----------------------------------------------€γ∏α----
ora.ARCH.dg ora....up.type 0/5 ∏$0/ ONLINE OFFLINE ©
ora.ARCHN.dg ora....up.type 0/5 €€☆'0/ ONLINE ONLINE rac1
ora.DATA.dg÷ ora....up.type 0/5 0/ λ<♥ ONLINE OFFLINE ✔§∑∞
ora.DATAN.dg ora....u≥δβ↓p.type 0/5 0/ ONLINE ON₩ΩLINE rac1
ora....ER.lsnr oraα↕....er.type 0/5 0/ φ§♣ONLINE ONLINE rac2
ora.×∞π...N1.lsnr ora....er.type 0∏/5 0/0 ONLINE ONLINE §™§ rac2
ora....N2.lsnr ora....er.type 0/5 0/₹$"0 ONLINE ONLINE rac1
ora....N3.l<λsnr ora....er.type 0/5 0/0 ≠$∑ONLINE ONLINE rac1
ora.OCRN.dg orΩβ•a....up.type 0/5 0/ O♥÷NLINE ONLINE rac1
ora.asm ora.asm.ty÷←✔☆pe 0/5 0/ ONLINE ONLINE rac1
ora.c ¶∑vu ora.cvu.type 0/5 0/0 ONLINE£≥' ONLINE rac1
ora.gsd β♦ ora.gsd.type ♣≠ 0/5 0/ OFFLINE OFFLINE
ora....netwo∞↕♣Ωrk ora....rk.type 0/5 0/ ONLINE ONLIN♣₽£←E rac1
ora.oc4j ©π ora.oc4j.type 1/1 0/2 ONLINE OFFLINE
€δora.ons ora.ons.type 1/3 0/ "€↑♠ ONLINE OFFLINE
ora....SM1.asm application ÷♣↑ 0/5 0/0 ONLINE ONLINE >" rac1
ora....C1.lsnr application $↑♦ 0/5 0/0 ONLINE OFFLINE
ora.rac1.g•≠§¶sd application 0/5 &β♦ 0/0 OFFLINE OFFLINE
ora.rac1.ons aπ ><pplication 1/3 0/0 ONLINE OFFLINE←≠
ora.rac1.vip ora....t1.type 0/©♦©>0 1/0 ONLINE ONLINE &< rac2
ora....SM2.asm a©®¶¶pplication 0/5 0/0 ONLINE ONLINEα€÷ rac2
ora....C2.lsnr application £™0/5 0/0 ONLINE ONLβINE rac2
ora.rac2.gsd applic₩£≈ation 0/5 0/0 OFFLINE §"•OFFLINE
ora.rac2.ons application α♥'< 0/3 0/0 ONLINE OFFLINE
ora.rac2.vi"✘ <p ora....t1.type 0/0 0/< 0 ONLINE ONLINE →♣λ™ rac2
ora....ry.acfs ora....fs.ty∑≈¥βpe 0/5 0/ ONLINE ONLINE rδ↓ε≥ac1
ora.scan1.vip ora....ip.type 0/0 0≤↕ ¥/0 ONLINE ONLINE rac¶φ<2
ora.scan2.vip ora....ip.type ™¥0/0 0/0 ONLINE ONLI→≥®NE rac1
ora.scan3.vip ora..♠₩..ip.type 0/0 0/0 ONLINE ONL©'£™INE rac1
ora.uecdb.db ora....se.δ≈type 0/2 0/1 ONLINE ₹∞↑ONLINE rac1
crsctl sto↔⧕p res ora.ARCH.dg -f
crsct¥€§l delete res ora.ARCH.d¶$±g -f
crsctl stop res ora.DATA.dg -f
↑↔crsctl delete res ora.DATA.πα÷dg -f
