榫欐簮鏈熷垔缃?/p>
http://www.qikan.com.cn
Oracle
鏁版嵁搴撶殑澶囦唤涓庢仮澶嶇瓥鐣?/p>
浣滆�咃細闊﹀痉寮?/p>
鏉ユ簮锛氥�婄數鑴戠煡璇嗕笌鎶�鏈�?/p>
2010
骞寸
19
鏈?/p>
鎽樿
:Oracle
浣滀负涓绘祦鐨勫ぇ鍨嬪叧绯诲瀷鏁版嵁搴撶鐞嗙郴缁?/p>
,
瀹冩彁渚涗簡涓板瘜鐨勫浠戒笌鎭㈠鍔熻兘
,
淇濊瘉
绯荤粺鐨勫畨鍏ㄦ�с�傝鏂囩畝瑕侀槓杩颁簡
Oracle
鏁版嵁搴撳簲鐢ㄤ腑甯哥敤鐨勫浠戒笌鎭㈠鏂规浠ュ強鍚勮嚜鐨勯�傜敤鑼?/p>
鍥?/p>
,
骞跺湪姝ゅ熀纭�涓婄粰鍑轰簡澶囦唤鍜屾仮澶嶇瓥鐣ョ殑寤鸿鏂规
,
浠ュ姪浜庢暟鎹簱绠＄悊鍛樿繘琛屾瘮杈冨拰鍐崇瓥銆?/p>
鍏抽敭璇?/p>
:Oralce;
鏁版嵁搴撳浠?/p>
;
鏁版嵁搴撴仮澶?/p>
;RMAN
鎭㈠绠＄悊鍣?/p>
;
鏁版嵁娉?/p>
涓浘鍒嗙被鍙?/p>
:TP309.3
鏂囩尞鏍囪瘑鐮?/p>
:A
鏂囩珷缂栧彿
:1009-3044(2010)19-5367-04
Backup and Recovery Strategy of Oracle Database
WEI De-qiang
(Ningbo Municipal Bureau of National Land And Resource,Zhenhai Branch, Ningbo 315200,
China)
Abstract: As a widely used Relational Database Management Software(RDBMS), Oracle
database provides powerful backup and recovery technology to secure the system safety and integrity.
The paper introduces the common solution of data backup and recovery on Oracle database, and then
an appropriate strategy of backup and recovery will be covered, which helps database administrators
to compare with each other solution and make right decision.
Key words: Oracle; e4backup; recovery; RMAN; data pump
Oracle
鏁版嵁搴撶郴缁熸槸涓�涓姛鑳藉己澶у拰鐏垫椿鐨勫叧绯诲瀷鏁版嵁搴撶郴缁?/p>
,
瀹冪殑瀹夊叏銆佸彲闈犮�侀珮鏁?/p>
,
浠?/p>
鍙婂鍚勭楂樼纭欢骞冲彴銆佺綉缁滃拰瀛樺偍鎶�鏈殑鏀寔
,
浣垮叾鎴愪负涓氱晫涓绘祦鏁版嵁搴撶郴缁熶箣涓�銆?/p>
Oracle
鏁版嵁搴撳湪姝ｅ父鎯呭喌涓嬭兘澶熶繚璇佹暟鎹殑瀹夊叏鍜岀郴缁熺殑绋冲畾
,
涓虹敤鎴锋彁渚涙棩甯告湇鍔?/p>
,
浣嗙敱
浜庡湪浣跨敤杩囩▼涓绠楁満纭欢鏁呴殰銆佺郴缁熻蒋浠跺拰搴旂敤绋嬪簭鐨勯敊璇�佹搷浣滃憳鐨勫け璇瓑閮藉彲鑳藉奖鍝嶆暟
鎹簱涓暟鎹殑姝ｇ‘鎬у拰瀹夊叏鎬?/p>
,
閲嶅垯浣挎暟鎹簱涓殑鏁版嵁閮ㄥ垎鎴栧叏閮ㄤ涪澶?/p>
,
鐢氳嚦瀵艰嚧绯荤粺鐦棯銆傝繖
灏辫姹傛暟鎹簱绠＄悊鍛樺繀椤婚噰鐢ㄩ�傚綋鐨勬妧鏈墜娈靛拰鏂规硶
,
寤堕暱鏁版嵁搴撳钩鍧囨晠闅滅殑鍙戠敓鏃堕棿
,
骞跺綋鏁?/p>
鎹簱涓殑鏁版嵁閬埌鐮村潖鏃惰兘澶熷敖蹇粠鏁版嵁澶囦唤涓仮澶嶆暟鎹?/p>
,
浠庤�屽皢鎹熷け鍑忓皯鍒版渶灏?/p>
,
淇濋殰浼佷笟鐨?/p>
鏁堢泭銆?/p>
Oracle
涓虹敤鎴锋彁渚涗簡瀹屽杽鐨勫浠戒笌鎭㈠鍔熻兘
,
淇濊瘉绯荤粺鐨勫畨鍏ㄦ�с�傛湰鏂囧皢鍦ㄤ粙缁?/p>
Oracle
澶囦唤涓庢仮澶嶆妧鏈熀纭�涓?/p>
,
闃愯堪
Oracle
鏁版嵁搴撳浠戒笌鎭㈠鐨勭瓥鐣ャ�?/p>
1 Oralce
鏁版嵁搴撶殑澶囦唤鏂规