[
杞?/p>
]Oracle9i RMAN
澶囦唤鍙婃仮澶嶆楠?/p>
鍦ㄨ繖閲屾病鏈夎璁哄涔堟繁鍏ョ殑
RMAN
鎶�鏈紝
涔熸病鏈夊憡璇夊ぇ瀹惰繖鏍峰幓缂栧啓澶囦唤鑴氭湰锛?/p>
杩欏苟涓嶆槸鎴戠殑
鍒濊》锛屾垜鍙兂鎶婃垜浼氱殑鍐欏嚭鏉ワ紝鍜屽ぇ瀹朵竴璧峰涔狅紝涓�璧疯繘姝ワ紝璋㈣阿銆?/p>
1
銆佸垏鎹㈡湇鍔″櫒褰掓。妯″紡锛屽鏋滃凡缁忔槸褰掓。妯″紡鍙烦杩囨姝ワ細
%sqlplus /nolog (
鍚姩
sqlplus)
SQL> conn / as sysdba (
浠?/p>
DBA
韬唤杩炴帴鏁版嵁搴?/p>
)
SQL> shutdown immediate; (
绔嬪嵆鍏抽棴鏁版嵁搴?/p>
)
SQL> startup mount (
鍚姩瀹炰緥骞跺姞杞芥暟鎹簱锛屼絾涓嶆墦寮�
)
SQL> alter database archivelog; (
鏇存敼鏁版嵁搴撲负褰掓。妯″紡
)
SQL> alter database open; (
鎵撳紑鏁版嵁搴?/p>
)
SQL> alter system archive log start; (
鍚敤鑷姩褰掓。
)
SQL> exit (
閫�鍑?/p>
)
2
銆佽繛鎺ワ細
%rman target=rman/rman@mydb (
鍚姩鎭㈠绠＄悊鍣?/p>
)
3
銆佸熀鏈缃細
RMAN> configure default device type to disk; (
璁剧疆榛樿鐨勫浠借澶囦负纾佺洏
)
RMAN> configure device type disk parallelism 2; (
璁剧疆澶囦唤鐨勫苟琛岀骇鍒紝閫氶亾鏁?/p>
)
RMAN> configure channel 1 device type disk fromat '/backup1/backup_%U'; (
璁剧疆
澶囦唤鐨勬枃浠舵牸寮忥紝鍙�傜敤浜庣鐩樿澶?/p>
)
RMAN> configure channel 2 device type disk fromat '/backup2/backup_%U'; (
璁剧疆
澶囦唤鐨勬枃浠舵牸寮忥紝鍙�傜敤浜庣鐩樿澶?/p>
)
RMAN> configure controlfile autobackup on; (
鎵撳紑鎺у埗鏂囦欢涓庢湇鍔″櫒鍙傛暟鏂囦欢鐨勮嚜
鍔ㄥ浠?/p>
)
RMAN>
configure
controlfile
autobackup
format
for
device
type
disk
to
'/backup1/ctl_%F'; (
璁剧疆鎺у埗鏂囦欢涓庢湇鍔″櫒鍙傛暟鏂囦欢鑷姩澶囦唤鐨勬枃浠舵牸寮?/p>
)
4
銆佹煡鐪嬫墍鏈夎缃細
RMAN> show all
5
銆佹煡鐪嬫暟鎹簱鏂规鎶ヨ〃锛?/p>
RMAN> report schema;
6
銆佸浠藉叏搴擄細
RMAN> backup database plus archivelog delete input; (
澶囦唤鍏ㄥ簱鍙婃帶鍒舵枃浠躲�佹湇鍔?/p>
鍣ㄥ弬鏁版枃浠朵笌鎵�鏈夊綊妗ｇ殑閲嶅仛鏃ュ織锛屽苟鍒犻櫎鏃х殑褰掓。鏃ュ織
)
7
銆佸浠借〃绌洪棿锛?/p>
RMAN> backup tablespace system plus archivelog delete input; (
澶囦唤鎸囧畾琛ㄧ┖闂?/p>
鍙婂綊妗ｇ殑閲嶅仛鏃ュ織锛屽苟鍒犻櫎鏃х殑褰掓。鏃ュ織
)
8
銆佸浠藉綊妗ｆ棩蹇楋細