??????ORACLE???????????????????????У??????????????????鵵????????????????????????????????????????????????鵵????????????????? ????????????????????????????????????????????????????鵵??????????????????????????????Ч??????????????????????????? ????????????????α???????????????????????Ч????????????κ??????????????????????????????????????????
??????? ??OARCLE ?????????????????鵵?????????????????飻
????1????????????????????(???Archive Mode ??No Archive Mode)??2????????鵵??????(Automatic archival?????Enabled ??Disabled)??
???????? ??β????????????????????鵵????????
????????archive log list ??????????
?????????????????鵵???μ????????????????£??????????????????
????SQL> archive log list
????Database log mode Archive Mode
????Automatic archival Enabled
????Archive destination /backup/archivelog
????Oldest online log sequence 2131
????Next log sequence to archive 2133
????Current log sequence 2133
??????????????????????????鵵?????????????????£????????????????
????SQL> archive log list
????Database log mode No Archive Mode
????Automatic archival Disabled
????Archive destination /u01/app/oracle/product/8.1.7/dbs/arch
????Oldest online log sequence 194
????Current log sequence 196
??????. ????????????????
???????????????????????CREATE DATABASE ??????????????????????????????????????NOARCHIVELOG ???????????????????????????Archive Mode????????????20%??????????????????INSTANCE ????????????????????????????????????????????????????ARCHIVE MODE ???
??????????????????????л???Archive Mode ??No Archive Mode ?????л???????????????£?
????1. ??????е?????????
????SQL> shutdown
???????????????л????????????е??????????????
????2. ?????????
???????????????????????????????????????????????????????鵵??????????????????????????????????????????????????
????3. ?????????????mount ?????????????
????SQL> startup mount
????4. ?л?????????????
????SQL> alter database archivelog;(???????????鵵?????)??
????SQL> alter database noarchivelog;(????????????鵵?????)
????5. ???????
????SQL> alter database open;
????6. ???????????????鵵???????
????SQL> archive log list;
????Database log mode Archive Mode
????Automatic archival Enabled
????Archive destination for example: $ORACLE_HOME/dbs/arch
????Oldest on-line log sequence 275
????Next log sequence 277
????Current log sequence 278
????7. ??????????redo logs ?鵵
????SQL> archive log all;
????8. ????2????????????????????鵵?????檔
??????. ????鵵??????(Automatic archival?????Enabled ??Disabled)??
??????????£????????????arch ???????????redo logs д?????鵵?豸?????????????????????????????ò????????????$ORACLE_HOME/dbs/init*.ora ????У???
????LOG_ARCHIVE_START=
????LOG_ARCHIVE_DEST=
????LOG_ARCHIVE_FORMAT=
????LOG_ARCHIVE_START:
?????????????鵵??????????TRUE??????????????鵵??????????FALSE
????LOG_ARCHIVE_DEST:
?????ò????趨??archive logs ?鵵????·????
????LOG_ARCHIVE_FORMAT:
?????ò????趨??archive logs ??????????????磬?罫??????: arch%s.arc
????log ??????: arch1.arc?? arch2.arc?? arch3.arc
????????????????????????????????????ò?????Ч?????????????????н??????????????Ч???????????????
?????????????????????У????????????????????????鵵???????????2?????
????SQL> ALTER SYSTEM ARCHIVE LOG START;
????????????????????鵵??(???????鵵)????
????SQL> ALTER SYSTEM ARCHIVE LOG STOP;
???????????????????????????????Ч???????鵵??????????????????????е?LOG_ARCHIVE_START ????????á?
??????. ?????????????
????1. Database log mode Archive Mode??Automatic archival Enabled
??????????????????????е?ORACLE ???????????鵵???????????????£???????????????????????????????鵵????????????Ч?????????????й鵵????????????
????2. Database log mode Archive Mode??Automatic archival Disabled
????????????£????????????鵵?????????????鵵??????????????????д?????????е???????????鵵?????????LGWR ??п?????????????д???????????????????н???????鵵???п????????????????????????????????????????????????
????????鵵???????£?
????SQL> ALTER SYSTEM ARCHIVE LOG ALL;
??????????????????????й鵵????
????3. Database log mode NO Archive Mode??Automatic archival Enabled
??????Щ????£????????????????????????????????LOG_ARCHIVE_START=TRUE?????????????????????ARCH ?鵵?????????????????????ORACLE ??????????????л???????????й鵵??????????????????????????????????????ARVHIVELOG ????redolog ????????鵵??
????4. Database log mode NO Archive Mode??Automatic archival Disabled
???????????????????oracle ??????????????????????????????????н??й鵵??
??????????????鵵?????????????????RMNA?????????????????
????????????????鵵??????
??????????RMAN????????????鵵?б????
????1) ??????????rman????????????????"rman target /"??????rman?????????????????????????
????2) ???鵵????????????
????RMAN> list archivelog all;
????3) ??????????е????????????????????????????????????????????
????4) ???鵵?????????и??£?
????RMAN> crosscheck archivelog all;
????RMAN> delete expired archivelog all; ??????????"yes"??
????RMAN> exit