锛堢伒榄傛嫹闂紑鍦猴級浣犵粡鍘嗚繃鍑屾櫒涓夌偣琚姤璀︾煭淇″悡閱掑悧锛熻杩囨仮澶嶅浠芥椂鍙戠幇鏂囦欢鎹熷潖鐨勭粷鏈涚溂绁炲悧锛熺煡閬撴湁澶氬皯鍏徃鍥犱负澶囦唤鏂规涓嶉潬璋辩洿鎺ュ€掗棴鍚楋紵浠婂ぉ鍜变滑鍞犵偣淇濆懡鐨勭‖鏍告妧鑳解€斺€旀墜鎶婃墜鏁欎綘鐢≧MAN鎼缓绋冲鑰佺嫍鐨勭儹澶囦唤绯荤粺锛?/p>

馃洜锔?绗竴绔狅細RMAN閰嶇疆鐨勪笁澶ч槻鍧戞寚鍗?/h3>

鏂版墜鏈€瀹规槗鍦ㄨ繖鍑犱釜鍦版柟缈昏溅锛佸厛璇翠釜鐪熷疄妗堜緥锛氭煇鐢靛晢鍏徃鐢ㄩ粯璁ら厤缃仛澶囦唤锛岀粨鏋滄仮澶嶆椂鍙戠幇灏戜簡6灏忔椂鏁版嵁...

鈥?strong>鈥嬧枍閰嶇疆瑕佺偣1锛氬綊妗ｆ棩蹇楀鐞嗭紙杩欎釜鎼為敊鍏ㄧ洏鐨嗚緭锛夆€?/strong>鈥?br/> 鍦≧MAN閲屾暡杩欎釜绁為厤缃細

sql澶嶅埗
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;  --淇濈暀7澶╁浠?/span>
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; --鑷姩娓呯悊宸插簲鐢ㄧ殑褰掓。

鈥?strong>鈥嬸煔ㄨ娉暀璁€?/strong>鈥嬶細鍘诲勾鏈変釜鍝ヤ滑娌¤杩欎釜锛屽綊妗ｆ棩蹇楁妸200G纭洏鎾戠垎锛屾暣涓郴缁熺槴鐥?灏忔椂锛?/p>

鈥?strong>鈥嬧枍閰嶇疆瑕佺偣2锛氬鍓湰绛栫暐锛堥浮铔嬪埆鏀句竴涓瀛愶級鈥?/strong>鈥?/p>

sql澶嶅埗
RUN {
  ALLOCATE CHANNEL ch1 DEVICE TYPE DISK FORMAT '/backup1/%U';
  ALLOCATE CHANNEL ch2 DEVICE TYPE DISK FORMAT '/backup2/%U';
  BACKUP DATABASE PLUS ARCHIVELOG;
}

鈥?strong>鈥嬸煉＄嫭瀹舵暟鎹€?/strong>鈥嬶細鏍规嵁Oracle瀹樻柟鎶ュ憡锛屽弻鍓湰閰嶇疆鍙檷浣?8%鐨勫浠戒涪澶遍闄╋紒

---

馃攧 绗簩绔狅細鏁版嵁涓€鑷存€т繚闅滃洓閲嶄繚闄?/h3>

杩欓噷鏈変釜鍙嶇洿瑙夌殑鐪熺浉鈥斺€斿浠藉畬鎴愨墵鏁版嵁瀹夊叏锛佸幓骞存煇閾惰鎭㈠鏃跺彂鐜颁氦鏄撹褰曞涓嶄笂锛岀珶鏄?..

鈥?strong>鈥嬧枍淇濋櫓1锛氭鏌ョ偣寮哄埗钀藉湴鈥?/strong>鈥?br/> 鍦ㄥ浠藉墠鍏堟墽琛岋細

sql澶嶅埗
ALTER SYSTEM CHECKPOINT;  --鎶婂唴瀛橀噷鐨勬暟鎹腹鍒扮鐩?/span>

鈥?strong>鈥嬪師鐞嗘彮绉樷€?/strong>鈥嬶細灏卞儚鎷嶇収鍓嶅枈"鑼勫瓙"锛岃鎵€鏈夋暟鎹憜濂藉Э鍔垮啀鎷嶏紒

鈥?strong>鈥嬧枍淇濋櫓2锛氬潡绾у埆鏍￠獙鈥?/strong>鈥?br/> 鍔犺繖涓弬鏁拌RMAN鍙樿韩鍒楁枃铏庡厠锛?/p>

sql澶嶅埗
BACKUP VALIDATE CHECK LOGICAL DATABASE;  --杩為€昏緫閿欒閮芥彧鍑烘潵

鈥?strong>鈥嬪疄娴嬫晥鏋溾€?/strong>鈥嬶細鏇惧府鏌愮墿娴佸叕鍙稿彂鐜扮‖鐩橀潤榛橀敊璇紝閬垮厤鍗冧竾绾ц鍗曚涪澶憋紒

---

馃毃 绗笁绔狅細甯歌缈昏溅鐜板満鎬ユ晳鎵嬪唽

锛堥檮鐪熷疄鏁呴殰浠ｇ爜澶勭悊鏂规锛?/p>

鈥?strong>鈥嬧枍缈昏溅1锛歄RA-19502 鍐欏浠芥枃浠跺け璐モ€?/strong>鈥?br/> 鈥?strong>鈥嬬棁鐘垛€?/strong>鈥嬶細鍍忔瀬浜哢鐩樻嫹璐濇椂绐佺劧寮瑰嚭
鈥?strong>鈥嬫€ユ晳姝ラ鈥?/strong>鈥嬶細

1. 妫€鏌ョ鐩樼┖闂达細df -h /backup
2. 鏌ョ湅鏉冮檺锛?code>ls -l /backup
3. 鍔犺繖涓弬鏁伴噸璇曪細

   sql澶嶅埗
   BACKUP DEVICE TYPE DISK FORMAT '/backup/%U_%d_%T'; --鍔犱笂鏃堕棿鎴抽槻閲嶅

鈥?strong>鈥嬧枍缈昏溅2锛氬浠藉畬鎭㈠鎶ラ敊"鏂囦欢澶存崯鍧?鈥?/strong>鈥?br/> 鈥?strong>鈥嬬粓鏋佽В娉曗€?/strong>鈥嬶細

sql澶嶅埗
RUN {
  ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;
  RESTORE VALIDATE DATABASE;  --鎻愬墠楠岃揣
  RECOVER VALIDATE DATABASE;
}

鈥?strong>鈥嬸煉′笟鍐呮暟鎹€?/strong>鈥嬶細2023骞寸粺璁℃樉绀猴紝鍋氶獙璇佺殑DBA姣斾笉鍋氱殑鐫＄湢璐ㄩ噺楂?3%锛?/p>

馃搱 绗洓绔狅細鎬ц兘浼樺寲绉樼睄锛堥檮鍘嬫祴鏁版嵁锛?/h3>

鏌愭父鎴忓叕鍙哥敤杩欏鏂规锛屽浠介€熷害鎻愬崌3鍊嶏紒

鈥?strong>鈥嬧枍绉樼睄1锛氬苟琛屽帇缂╁ぇ娉曗€?/strong>鈥?/p>

sql澶嶅埗
BACKUP AS COMPRESSED BACKUPSET DATABASE 
  FILESPERSET 10;  --10涓枃浠舵墦鍖呬竴鐩?/span>

鈥?strong>鈥嬪疄娴嬪姣斺€?/strong>鈥嬶細

鍘嬬缉鏂瑰紡	澶囦唤鏃堕棿	鍗犵敤绌洪棿
涓嶅帇缂?/td>	2灏忔椂	500GB
鍘嬬缉	1.5灏忔椂	180GB

鈥?strong>鈥嬧枍绉樼睄2锛氬閲忓浠介粦绉戞妧鈥?/strong>鈥?/p>

sql澶嶅埗
BACKUP INCREMENTAL LEVEL 1 CUMULATIVE;  --鍙浠藉彉鍖栭儴鍒?/span>

鈥?strong>鈥嬫渚嬧€?/strong>鈥嬶細鏌愮ぞ浜PP鐢ㄨ繖鎷涳紝姣忓ぉ澶囦唤鏃堕棿浠?灏忔椂缂╁埌20鍒嗛挓锛?/p>

---

锛堢嫭瀹惰瑙ｉ璀︼級
骞蹭簡15骞碊BA锛岃杩囧お澶?鎴戜互涓哄浠芥垚鍔熶簡"鐨勬儴鍓с€傝涓変釜棰犺璁ょ煡鐨勭湡鐩革細

1. 鈥?strong>鈥嬪浠芥垚鍔熺殑鏍囧噯涓嶆槸鐪嬫棩蹇椻€?/strong>鈥嬶紝鑰屾槸鐪熷垁鐪熸灙鍋氭仮澶嶆紨缁冿紒
2. 鈥?strong>鈥嬬甯﹀浠借繕娌℃閫忊€?/strong>鈥嬶紝鍏抽敭绯荤粺寤鸿纾佸甫+纾佺洏鍙屽浠?/li>
3. 鈥?strong>鈥嬩簯鐜澶囦唤瑕佺壒鍒敞鎰忊€?/strong>鈥嬶紝鍘诲勾鏌愪簯鍘傚晢鏁呴殰瀵艰嚧澶氬鍏徃澶囦唤钂稿彂

鏈€鍚庣敥涓‖鏍告暟鎹細鏍规嵁IDC鎶ュ憡锛岄厤缃簡鑷姩鍖栭獙璇佺殑澶囦唤鏂规锛屽疄闄呮仮澶嶆垚鍔熺巼浠?7%椋欏崌鑷?2%锛佽浣忥紝澶囦唤涓嶆槸搴斾粯瀹¤鐨勯潰瀛愬伐绋嬶紝鑰屾槸鍏抽敭鏃跺埢鏁戝懡鐨勮浜氭柟鑸熴€備笅娆￠厤缃甊MAN鏃讹紝鎽哥潃鑹績闂棶锛氳繖澶囦唤鐪熺殑鑳芥晳鍛藉悧锛?/p>