????Oracle?????鵵??(NOARCHIVELOG) ??鵵??(ARCHIVELOG)????鵵?????????鵵??????????????????????????????????????????????????????????????????????????????????????????????????????????????????Oracle?????????鵵?????????????????????????ù鵵????????????鵵???????????????????????????????Oracle?????????????????????????
????????????????????????????????
????select name??log_mode from v$database;
???????????????????
????archive log list??(?÷??????as sysdba)
?????????鵵????????????鵵?????????Oracle 10g??ο?????????2??裺
????1. SQL> alter system set log_archive_dest_1='location=/oracle/oracle10g/log/archive_log';
????????京????????鵵?????·?????????Oracle 10g??????????????????????????λ??????????
???????????????????λ?????????????
????SQL>alter system set log_archive_dest_2='location=/oracle/oracle10g/log2/archive_log';
????2.????????
????SQL> shutdown immediate
????3.???????mount????
????SQL> startup mount;
????4????????????鵵????
????SQL> alter database archivelog;
????5??????????????
????SQL> alter database open;
??????????????????????
????SQL> alter system set log_archive_max_processes = 5;
????SQL> alter system set log_archive_format = "archive_%t_%s_%r.log" scope=spfile;
??????????????????????????????
????????????????Oracle 9i?л????????alter system set log_archive_start = true??????Ч??oracle 10g??????????ò?????????????????ò?????