ããoracle å½æ¡£æ¥å¿
ããå½æ¡£æ¥å¿(Archive Log)æ¯éæ´»å¨çéåæ¥å¿å¤ä»½.éè¿ä½¿ç¨å½æ¡£æ¥å¿,å¯ä»¥ä¿çææéååå²è®°å½,å½æ°æ®åºå¤äºARCHIVELOG模å¼å¹¶è¿è¡æ¥å¿åæ¢å¼,åå°è¿ç¨ARCHä¼å°éåæ¥å¿çå
容ä¿åå°å½æ¡£æ¥å¿ä¸.å½æ°æ®åºåºç°ä»è´¨å¤±è´¥æ¶,使ç¨æ°æ®æ件å¤ä»½,å½æ¡£æ¥å¿åéåæ¥å¿å¯ä»¥å®å
¨æ¢å¤æ°æ®åº.
ããæ¥å¿æä½æ¨¡å¼:ARCHIVELOG NOARCHIVELOG
ãã1,æ¹åæ¥å¿æä½æ¨¡å¼:
ããæ£æ¥å½åæ¥å¿æä½æ¨¡å¼
ããSELECT log_mode from v$database;
ããå
³éæ°æ®åº,ç¶åè£
è½½æ°æ®åº
ããSHUTDOWN IMMEDIATE
ããSTARTUP MOUNT
ããæ¹åæ¥å¿æä½æ¨¡å¼,ç¶åæå¼æ°æ®åº
ããALTER DATABASE ARCHIVELOG;
ããALTER DATABASE OPEN;
ãã2,æ§è¡æå·¥å½æ¡£
ããä»oracle database 10gå¼å§,å½å°æ¥å¿æä½æ¨¡å¼è½¬åæªARCHIVELOG模å¼æ¶,oracleä¼èªå¨å¯å¨ARCHè¿ç¨.å¦æè¦ä½¿ç¨æå·¥å½æ¡£.é£ä¹å¨æ¹åæ¥å¿æä½æ¨¡å¼æ¶å¿
须使ç¨å½ä»¤ALTER DATABASE ARCHIVELOG MANUAL.
ããéè¦æ³¨æ,使ç¨æå·¥å½æ¡£æ¹å¼,æ°æ®åºç®¡çåå¿
é¡»æå·¥æ§è¡å½æ¡£å½ä»¤.å¦æ没ææ§è¡æå·¥å½æ¡£å½ä»¤,æ¥å¿ç»çåæå
容å°ä¸è½è¢«è¦ç.ALTER DATABASE ARCHIVELOG MANUAL å½ä»¤æ¯ä¸ºäºä¸å
åççæ¬å
¼å®¹èä¿çç,.å°æ¥çoracleçæ¬ä¼æ·æ±°è¯¥å½ä»¤,使ç¨æå·¥å½æ¡£æ¹å¼æ¯,æ°æ®åºç®¡çåå¯ä»¥æ§è¡ä»¥ä¸å½ä»¤å½æ¡£éåæ¥å¿:
ããALTER SYSTEM ARCHIVELOG ALL;
ãã3,é
ç½®å½æ¡£è¿ç¨
ããåå§ååæ°LOG_ARCHIVE_MAX_PROCESSESç¨äºæå®ä¾ç¨åå§å¯å¨çæ大å½æ¡£è¿ç¨ä¸ªæ°,å½å°æ°æ®åºè½¬å为ARCHIVELOG模å¼æ¶,é»è®¤æ
åµä¸oracleä¼èªå¨å¯å¨ä¸¤ä¸ªå½æ¡£è¿ç¨.éè¿æ¹ååå§ååæ°LOG_ARCHIVE_MAX_PROCESSçå¼,å¯ä»¥å¨æå°å¢å æéä½å½æ¡£è¿ç¨ç个æ°:
ããALTER SYSTEM SET LOG_ARCHIVE_MAX_PROCESSES=3;é
ç½®å½æ¡£ä½ç½®åæä»¶æ ¼å¼
ããå½æ°æ®åºå¤äºARCHIVELOG模å¼æ¶,å¦æè¿è¡æ¥å¿åæ¢,åå°è¿ç¨å°èªå¨çæå½æ¡£æ¥å¿,å½æ¡£æ¥å¿çé»è®¤ä½ç½®ä¸º%oracle_home%rdbms,å¨oracle database 10gä¸,å½æ¡£æ¥å¿çé»è®¤æä»¶æ ¼å¼ä¸ºARC%S_%R.%T.为äºæ¹åå½æ¡£æ¥å¿çä½ç½®ååç§°æ ¼å¼,å¿
é¡»æ¹åç¸åºçåå§ååæ°,1,åå§ååæ°LOG_ARCHIVE_FORMATç¨äºæå®å½æ¡£æ¥å¿çæ件åæ ¼å¼,设置该åå§ååæ°æ¶,å¯ä»¥æå®ä»¥ä¸å¹é
符:
ãã%s: æ¥å¿åºåå·:
ãã%S: æ¥å¿åºåå·(带æå导0)
ãã%t: éå线ç¨ç¼å·.
ãã%T: éå线ç¨ç¼å·(带æå导0)
ãã%a: æ´»å¨IDå·
ãã%d: æ°æ®åºIDå·
ãã%r RESETLOGSçIDå¼.
ããä»10gå¼å§,é
ç½®å½æ¡£æ¥å¿æä»¶æ ¼å¼æ¶,å¿
须带æ%s,%tå%rå¹é
符,é
ç½®äºå½æ¡£æä»¶æ ¼å¼å,å¿
é¡»éå¯æ°æ®åº.
ãã2,使ç¨LOG_ARCHIVE_DESTé
ç½®å½æ¡£ä½ç½®
ããå¦æä¸ä½¿ç¨å¤ç¨æ°æ®åº,åªéè¦å°å½æ¡£æ¥å¿åæ¾å°æ¬å°ç®å½.é
ç½®æ¬å°å½æ¡£ä½ç½®å¯ä»¥ä½¿ç¨åå§ååæ°LOG_ARCHIVE_DESTåLOG_ARCHIVE_DUPLEX_DEST,å
¶ä¸,第ä¸ä¸ªåæ°ç¨äºè®¾ç½®ç¬¬ä¸ä¸ªå½æ¡£ä½ç½®,第äºä¸ªåæ°ç¨äºæå®ç¬¬äºä¸ªå½æ¡£ä½ç½®.
ããALTER SYSTEM SET log_archive_dest='d:demoarchive1';ALTER SYSTEM SET log_archive_duplex_dest='d:demoarchive2';3,使ç¨LOG_ARCHIVE_DEST_né
ç½®å¤ä¸ªå½æ¡£ä½ç½®.
ããåå§ååæ°LOG_ARCHIVE_DEST_nç¨äºæå®å¤ä¸ªå½æ¡£ä½ç½®,该åæ°æå¤å¯ä»¥æå®10个å½æ¡£ä½ç½®.éè¿ä½¿ç¨åå§ååæ°LOG_ARCHIVE_DEST_n,ä¸ä»
å¯ä»¥é
ç½®æ¬å°å½æ¡£ä½ç½®,è¿å¯ä»¥é
ç½®è¿ç¨å½æ¡£ä½ç½®.
ããå¦ææ¢è¦å¨ä¸»èç¹ä¸çæå½æ¡£æ¥å¿,åè¦å°å½æ¡£æ¥å¿ä¼ éå°å¤ç¨èç¹,é£ä¹å¿
须使ç¨åæ°LOG_ARCHIVE_DEST_n.该åæ°ä¸LOG_ARCHIVE_DESTå
·æå¦ä¸åºå«;åå§ååæ°LOG_ARCHIVE_DEST_nå¯ä»¥é
ç½®æ¬å°å½æ¡£ä½ç½®åè¿ç¨å½æ¡£ä½ç½®,èåå§ååæ°LOG_ARCHIVE_DESTåLOG_ARCHIVE_DUPLEX_DESTåªè½é
ç½®æ¬å°å½æ¡£ä½ç½®.
ããåå§ååæ°LOG_ARCHIVE_DEST_nå¯ä»¥é
ç½®å¤è¾¾10个å½æ¡£ä½ç½®,èåå§ååæ°LOG_ARCHIVE_DESTåLOG_ARCHIVE_DUPLEX_DESTæå¤åªè½é
置两个å½æ¡£ä½ç½®.
ããåå§ååæ°LOG_ARCHIVE_DEST_n ä¸è½ä¸åå§ååæ°LOG_ARCHIVE_DESTåLOG_ARCHIVE_DUPLEX_DESTåæ¶ä½¿ç¨.
ããå 为åå§ååæ°LOG_ARCHIVE_DEST_nä¸è½ä¸åå§ååæ°LOG_ARCHIVE_DESTåLOG_ARCHIVE_DUPLEX_DESTåæ¶ä½¿ç¨,æ以å¿
é¡»ç¦ç¨åå§ååæ°LOG_ARCHVE_DESTåLOG_ARCHIVE_DUPLEX_DEST.å½ä½¿ç¨åå§ååæ°LOG_ARCHIVE_DEST_né
ç½®æ¬å°å½æ¡£ä½ç½®æ¶,éè¦æå®LOCALTIONé项.å½é
ç½®è¿ç¨å½æ¡£ä½ç½®æ¶,éè¦æå®SERVICEé项.
ãã示ä¾å¦ä¸:
ããALTER SYSTEM SET log_archive_duplex_dest='';ALTER SYSTEM SET log_archive_dest='';
ããALTER SYSTEM SET log_archive_dest_1='location=d:demoarchive1';ALTER SYSTEM SET log_archive_dest_2='location=d:demoarchive2';ALTER SYSTEM SET log_archive_dest_3='location=d:demoarchive3';ALTER SYSTEM SET log_archive_dest_4='service=standby';é
ç½®è¿ç¨å½æ¡£ä½ç½®æ¶,SERVICEé项éè¦æå®è¿ç¨æ°æ®åºçç½ç»æå¡å(å¨tnsnames.oraæ件ä¸é
ç½®)4,使ç¨LOG_ARCHIVE_DEST_né项
ãã使ç¨åå§ååæ°LOG_ARCHIVE_DEST_né
ç½®å½æ¡£ä½ç½®æ¶,å¯ä»¥å¨å½æ¡£ä½ç½®ä¸æå®OPTIONALæMANDATORYé项.æå®MANDATORYé项æ¶,å¯ä»¥è®¾ç½®REOPENå±æ§.
ããOPTIONAL:该é项æ¯é»è®¤é项.使ç¨è¯¥é项æ¶,æ 论å½æ¡£æ¯å¦æå,é½å¯ä»¥è¦çéåæ¥å¿.
ããMANDATORY:强å¶å½æ¡£.使ç¨è¯¥é项æ¶,åªæå¨å½æ¡£æåä¹å,éåæ¥å¿æè½è¢«è¦ç.
ããREOPEN:该å±æ§ç¨äºæå®éæ°å½æ¡£çæ¶é´é´é,é»è®¤å¼ä¸º300ç§,å¿
é¡»è·å¨MANDATORYå.
ããä¾:
ããAlter system set log_archive_dest_1=âlocation=d:demoarchive1 mandatoryâ;Alter system set log_archive_dest_2=âlocation=d:demoarchive2 mandatory reopen=500â;Alter system set log_archive_dest_3=âlocation=d:demoarchive3 optionalâ;5,æ§å¶æ¬å°å½æ¡£æåçæå°ä¸ªæ°.
ãã使ç¨åå§ååæ°LOG_ARCHIVE_MIN_SUCCEED_DESTæ§å¶æ¬å°å½æ¡£çæå°æå个æ°Alter system set log_archive_min_succeed_dest=2;6,使ç¨åå§ååæ°LOG_ARCHIVE_DEST_STATE_næ§å¶å½æ¡£ä½ç½®çå¯ç¨æ§.设置该åæ°ä¸ºENABLE(é»è®¤å¼),表示ä¼æ¿æ´»ç¸åºçå½æ¡£ä½ç½®;设置该åæ°ä¸ºDEFER,表示ç¦ç¨ç¸åºå½æ¡£ä½ç½®.å½å½æ¡£æ¥å¿æå¨ç£çæåæ填满æ¶,DBAéè¦ææ¶ç¦ç¨è¯¥å½æ¡£ä½ç½®.
ããAlter system set log_archive_dest_state_3=defer;(ç¦ç¨)Alter system set log_archive_dest_state_3=enable;(å¯ç¨)æ¾ç¤ºå½æ¡£æ¥å¿ä¿¡æ¯
ãã1,使ç¨ARCHIVE LOG LISTå½ä»¤å¯ä»¥æ¾ç¤ºæ¥å¿æä½æ¨¡å¼,å½æ¡£ä½ç½®,èªå¨å½æ¡£æºå¨è¦å½æ¡£çæ¥å¿åºåå·çä¿¡æ¯.
ãã2æ¾ç¤ºæ¥å¿æä½æ¨¡å¼
ããSELECT name,log_mode FROM v$database;
ãã3,æ¾ç¤ºå½æ¡£æ¥å¿ä¿¡æ¯.
ããCol name format a46
ããSelect name, swquence#, first_change# FROM v$archived_log;Nameç¨äºè¡¨ç¤ºå½æ¡£æ¥å¿æ件å,sequence#ç¨äºè¡¨ç¤ºå½æ¡£æ¥å¿å¯¹åºçæ¥å¿åºåå·,firs_change#ç¨äºæ è¯å½æ¡£æ¥å¿çèµ·å§SCNå¼.
ãã4ãæ§è¡ä»è´¨æ¢å¤æ¶,éè¦ä½¿ç¨å½æ¡£æ¥å¿æ件,æ¤åå¿
é¡»åç¡®å®ä½å½æ¡£æ¥å¿çåæ¾ä½ç½®.éè¿æ¥è¯¢å¨ææ§è½è§å¾v$archive_destå¯ä»¥åå¾å½æ¡£æ¥å¿æå¨ç®å½.
ããSELECT destination FROM v$archive dest;
ãã5,æ¾ç¤ºæ¥å¿åå²ä¿¡æ¯
ããSELECT * FROM v$loghist;
ããTHREAD#ç¨äºæ è¯éå线ç¨å·,SEQUNCE#ç¨äºæ è¯æ¥å¿åºåå·,FIRST_CHANGE#ç¨äºæ è¯æ¥å¿åºåå·å¯¹åºçèµ·å§SCNå¼,FIRST_TIMEç¨äºæ è¯èµ·å§SCNçåçæ¶é´.SWICTH_CHANGE#ç¨äºæ è¯æ¥å¿åæ¢çSCNå¼.
ãã6.æ¾ç¤ºå½æ¡£è¿ç¨ä¿¡æ¯.
ããè¿è¡æ¥å¿åæ¢æ¶,ARCHè¿ç¨ä¼èªå¨å°éåæ¥å¿å
容å¤å¶å°å½æ¡£æ¥å¿ä¸,为äºå å¿«å½æ¡£é度,åºè¯¥å¯ç¨å¤ä¸ªARCHè¿ç¨.éè¿æ¥è¯¢å¨ææ§è½è§å¾V$ARCHIVE_PROCESSESå¯ä»¥æ¾ç¤ºææå½æ¡£è¿ç¨çä¿¡æ¯!
ããSELECT * FROM v$archive_processes;
ããPorcessç¨äºæ è¯ARCHè¿ç¨çç¼å·,statusç¨äºæ è¯ARCHè¿ç¨çç¶æ(ACTIVE:æ´»å¨,STOPPED:æªå¯å¨),log_sequenceç¨äºæ è¯æ£å¨è¿è¡å½æ¡£çæ¥å¿åºåå·,stateç¨äºæ è¯ARCHè¿ç¨çå·¥ä½ç¶æ==========================================ç¨Oracleå½æ¡£æ¥å¿è¿è¡æ¢å¤çæ¹æ³
ããç¨Oracleå½æ¡£æ¥å¿è¿è¡æ¢å¤çæ¹æ³
ããèæºéæ¼æ¥å¿æ²¡æ丢失åºä½¿ç¨å®ææ¢å¤ï¼å¦èæºéæ¼æ¥å¿æåï¼èå没æå¤ä»½ï¼å°±åªè½è¿è¡ä¸å®å
¨æ¢å¤ã
ããä¸ãå®å
¨æ¢å¤ï¼
ãã1ï¼ä½¿ç¨å½ä»¤âsvrmgrlâè°ç¨è¡æ¹å¼æå¡å¨ç®¡çï¼2ï¼è¾å
¥å½ä»¤âconnect internalâï¼ç¶åè¾å
¥å½ä»¤âstartup mountâï¼3ï¼è¾å
¥å½ä»¤ârecover database;â
ãã4ï¼æä¸ENTERï¼æ¥åé»è®¤å¼ã
ãã5ï¼ç¶åè¾å
¥å½ä»¤âalter database open;âå®ææ°æ®åºæ¢å¤ã
ããäºãä¸å®å
¨æ¢å¤
ããè¦åï¼
ããåºç¨ä¸å®ææ¢å¤åï¼å¿
é¡»å°æ°æ®åºåä¸æ¬¡å®å
¨å·å¤ä»½ï¼å 为åºç¨ä¸å®å
¨æ¢å¤åï¼èæºéæ¼æ¥å¿å°éç½®ï¼ä»¥åçæææ¥å¿ä¸å¯ç¨ã
ããå¦ææ¢å¤ä¸æåï¼æ°æ®åºå°±ä¸è½ä½¿ç¨äºãå次强è°ï¼åå®å
¨å·å¤ä»½åååºç¨ä¸å®å
¨æ¢å¤ã
ãã1ï¼.åºäºååçæ¢å¤(change-based recovery)è¦æ§è¡åºäºååçæ¢å¤ï¼éè¦ç¥é丢失æ¥å¿ä¹åçç³»ç»åå
¥å½æ¡£éæ¼æ¥å¿çæ大çååå·(SCN)ï¼ç¶åå¯ä»¥å¯å¨æ¢å¤è¯å¥æ¢å¤æ°æ®åºç´å°æ¹åscn_numberï¼å
¶ä¸æ¯scn_numberæ¯åå°å·²å½æ¡£éæ¼æ¥å¿æ件顺åºå·386çSCN(å³ï¼å°äºä¸¢å¤±æ¥å¿é¡ºåºå·387çSCN)ãå¯ä»¥ä»V$log_historyè§å¾ä¸å¾å°SCNä¿¡æ¯ã
ããselect first_change# from v$log_history where sequence#=387;å
¶ä¸387为æåä¸ä¸ªææçæ¥å¿æ件å·å 1,该ä¾æ¯æ¥æ¾386.
ããç¥éäºSCNåï¼ä½¿ç¨ä¸è¿°æ¥éª¤å®ææ¢å¤
ãã1ï¼ä½¿ç¨å½ä»¤âsvrmgrlâè°ç¨è¡æ¹å¼æå¡å¨ç®¡çï¼2ï¼è¾å
¥å½ä»¤âconnect internalâï¼ç¶åè¾å
¥å½ä»¤âstartup mountâï¼3ï¼è¾å
¥å½ä»¤ârecover database until change 9999;â
ãã4ï¼å¨åçOracle第ä¸ä¸ªå½æ¡£éæ¼æ¥å¿å»ºè®®ä¿¡æ¯æ¶ï¼è¾å
¥âautoâ,Oracleå¨æ¾å°ç¬¬387å·éæ¼æ¥å¿ä¹ååæ¢æ¢å¤ã
ãã5ï¼ç¨å½ä»¤âalter database open resetlogs;âæå¼æ°æ®åºã(åºç¨è¯¥å½ä»¤å请确认æ°æ®åºå·²å¤ä»½ï¼å¦æå¼å¤±è´¥ï¼æ¥å¿å°ä¸å¯ç¨)2).åºäºåæ¢çæ¢å¤(cancel-based recovery)
ãã1ï¼ä½¿ç¨å½ä»¤âsvrmgrlâè°ç¨è¡æ¹å¼æå¡å¨ç®¡çï¼2ï¼è¾å
¥å½ä»¤âconnect internalâï¼ç¶åè¾å
¥å½ä»¤âstartup mountâï¼3ï¼è¾å
¥å½ä»¤ârecover database until cancel;â,Oracleæ示éè¦ç第ä¸ä¸ªå½æ¡£éæ¼æ¥å¿æ件åï¼æä¸ENTERé®æ¥å缺çæ件åï¼å¹¶ä¸âè·¯ENTERç´å°è¯¢é®é¡ºåºå·387çæ¥å¿ãè¾å
¥âcancelâï¼åæ¢æ¢å¤æä½ã
ãã4ï¼ç¨å½ä»¤âalter database open resetlogs;âæå¼æ°æ®åºã(åºç¨è¯¥å½ä»¤å请确认æ°æ®åºå·²å¤ä»½ï¼å¦æå¼å¤±è´¥ï¼æ¥å¿å°ä¸å¯ç¨)3).åºäºæ¶é´çæ¢å¤(time-based recovery)
ãã为使ç¨åºäºæ¶é´çæ¢å¤ï¼å¿
é¡»ç¥éè®°å½å¨V$log_historyå½æ¡£éæ¼æ¥å¿åºå·387ï¼ä¸¢å¤±éæ¼æ¥å¿ï¼çæ¶é´ï¼éè¿æ§è¡æ¥è¯¢è¯å¥âselect time from v$log_history where sequence#=387;âå¾å°ãæ¬ä¾å¾å°çæ¶é´æ¯ï¼2002-06-23 14ï¼42ï¼04ç°å¨å¼å§å®æ½æ¢å¤ã
ãã1ï¼ä½¿ç¨å½ä»¤âsvrmgrlâè°ç¨è¡æ¹å¼æå¡å¨ç®¡çï¼2ï¼è¾å
¥å½ä»¤âconnect internalâï¼ç¶åè¾å
¥å½ä»¤âstartup mountâï¼3ï¼è¾å
¥å½ä»¤ârecover database until time '2002/06/23 14:42:04';â,Oracleæ示éè¦ç第ä¸ä¸ªå½æ¡£éæ¼æ¥å¿æ件åï¼è¾å
¥âautoâï¼Oracleæ¢å¤å½æ¡£éæ¼æ¥å¿ç´å°åºå·ä¸º387çæ¥å¿ï¼åæ¢æ¢å¤æä½ã
ãã4ï¼ç¨å½ä»¤âalter database open resetlogs;âæå¼æ°æ®åºã(åºç¨è¯¥å½ä»¤å请确认已æ°æ®åºå·²å¤ä»½ï¼å¦æå¼å¤±è´¥ï¼æ¥å¿å°ä¸å¯ç¨)æç¤ºï¼ ä½¿ç¨åºäºæ¶é´çæ¢å¤ï¼æ¶é´çæ ¼å¼æ¯YYYY/MM/DD HH24:MI:SS,并ä¸ç¨åå¼å·æ¬èµ·ã
ããéï¼å¦ä½å¯ç¨Oracleçå½æ¡£æ¹å¼
ãã1.åç
§ä»¥ä¸å
容ç¼è¾init.oraæ件ï¼
ããlog_archive_start = true
ããlog_archive_dest_1 = " LOCATION=D:\Oracle\oradata\ORCL\archive "og_archive_format = %%ORACLE_SID%%T%TS%S.ARC2.å
³éæ°æ®åº
ããsvrmgrl> connect internal
ããsvrmgrl> shutdown normal
ãã3.ç¶åå¯å¨å®ä¾å¹¶å®è£
该æ°æ®åºï¼ä½ä¸æå¼æ°æ®åºã
ããsvrmgrl> startup mount
ãã4.æ¥çï¼åå¸ä¸åæ´æ¹æ°æ®åºçå½ä»¤ã
ããSvrmgrl> alter database archivelog;
ãã5.ç°å¨ï¼æ°æ®åºå·²ç»æ´æ¹ä¸ºå½æ¡£æ¹å¼ï¼æ¨å¯ä»¥æå¼æ°æ®åºã
ããsvrmgrl> alter database open;
ããæ示ï¼ä¹å¯ä»¥ä½¿ç¨DBA studioå·¥å
·å¯ç¨æ°æ®åºçå½æ¡£æ¹å¼ï¼æä½å¾ç®å=============================================================ORACLEå½æ¡£æ¨¡å¼ç设置
ããå¨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/archOldest 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/archOldest on-line log sequence 275
ããNext log sequence 277
ããCurrent log sequence 278
ãã7. å°è¿ä¸ªæ¶é´ç¹çredo logs å½æ¡£
ããSQL> archive log all;
ãã8. 确认æ°äº§ççæ¥å¿æ件已å¨ç¸åºçå½æ¡£ç®å½ä¸é¢ã
ããå. èªå¨å½æ¡£æ¨¡å¼è®¾ç½®(Automatic archival,å¯ä¸ºEnabled åDisabled)ã
ããå¨è¯¥æ¨¡å¼ä¸ï¼æ°æ®åºå¯å¨ä¸ä¸ªarch è¿ç¨ï¼ä¸é¨è´è´£å°redo logs åå°ç³»ç»å½æ¡£è®¾å¤çç¸åºç®å½ä¸ãå¨æ°æ®åºçåæ°æ件ä¸è®¾ç½®åæ°ï¼ä¸è¬æ¯å¨$ORACLE_HOME/dbs/init*.ora æ件ä¸ï¼ï¼
ããLOG_ARCHIVE_START=
ããLOG_ARCHIVE_DEST=
ããLOG_ARCHIVE_FORMAT=
ããLOG_ARCHIVE_START:
ãã
温馨提示:答案为网友推荐,仅供参考