发表于 2009-1-5 19:48
| 
鏀规暟鎹簱鐨勫惎鍔ㄦ柟寮忎负archive褰掓。鏂瑰紡
鍙戝竷: 2008-6-30 14:56 | 浣滆: admin | 鏌ョ湅: 5娆
鏀规暟鎹簱鐨勫惎鍔ㄦ柟寮忎负archive褰掓。鏂瑰紡
鐑 鑽
銆愬瓧浣擄細灏 澶с
鏀规暟鎹簱鐨勫惎鍔ㄦ柟寮忎负archive褰掓。鏂瑰紡
浣滆咃細浣氬悕 鏂囩珷鏉ユ簮锛氫笉璇 鐐瑰嚮鏁帮細1000 鏇存柊鏃堕棿锛2006-4-17 
1銆佸厛鎸夋甯告柟寮忓叧闂暟鎹簱
鐒跺悗
%svrmgrl
SVRMGRL>connect internal
SVRMGRL>startup mount [database_name];
SVRMGRL>alter database [database_name] archivelog;
SVRMGRL>archive log list;
SVRMGRL>alter database open;
2銆佽缃暟鎹簱寮鍚悗鑷姩鍚姩archive杩涚▼
鏀瑰弬鏁版枃浠秈nitoraid.ora
涓 log_archive_start=true
log_archive_dest=directory or device name
log_archive_format=filename format
鍐嶉噸鏂板惎鍔ㄦ暟鎹簱锛屽嵆鍙
3銆佹敞鎰忎簨椤
鏈夎冻澶熺殑璧勬簮瀛樻斁褰掓。鏃ュ織鏂囦欢
瀹氫竴涓儹澶囦唤璁″垝锛屽畾鏈熷垹闄ゅ綊妗ｆ棩蹇楁枃浠
銉
