oracle歸檔模式簡介

1、acle歸檔模式簡介[1]目錄目錄acle歸檔模式簡介[1]...................................................................................................................1一、查看acle數(shù)據(jù)庫是否為歸檔模式........................................................

2、................1二、什么是acle歸檔模式...........................................................................................2三、配置數(shù)據(jù)庫的歸檔模式......................................................................................

3、......2四、參考文獻(xiàn)....................................................................................................................5一、查看一、查看acle數(shù)據(jù)庫是否為歸檔模式數(shù)據(jù)庫是否為歸檔模式1.namelog_modefromv$databaseNAMELOG_MODEQUERYNOARCHIVELOG2

4、.使用ARCHIVELOGLIST命令DatabaselogmodeNoArchiveModeAutomaticarchivalDisabledArchivedestinationdataacleproduct10.2.0db_1dbsarchOldestonlinelogsequence739Currentlogsequence7412.改變歸檔模式到非歸檔模式:1)SQLSHUTDOWNNMALIMMEDIATE2)SQLSTART

5、UPMOUNT3)SQLALTERDATABASENOARCHIVELOG4)SQLALTERDATABASEOPEN3.啟用自動(dòng)歸檔:LOG_ARCHIVE_START=TRUE歸檔模式下日志文件組不允許被覆蓋(重寫)當(dāng)日志文件寫滿之后如果沒有進(jìn)行手動(dòng)歸檔那么系統(tǒng)將掛起直到歸檔完成為止.這時(shí)只能讀而不能寫.運(yùn)行過程中關(guān)閉和重啟歸檔日志進(jìn)程SQLARCHIVELOGSTOPSQLARCHIVELOGSTART4.手動(dòng)歸檔:LOG_ARC

6、HIVE_START=FALSE歸檔當(dāng)前日志文件SQLALTERSYSTEMARCHIVELOGCURRENT歸檔序號為052的日志文件SQLALTERSYSTEMARCHIVELOGSEQUENCE052歸檔所有日志文件SQLALTERSYSTEMARCHIVELOGALL改變歸檔日志目標(biāo)SQLALTERSYSTEMARCHIVELOGCURRENTTO5.歸檔模式和非歸檔模式的轉(zhuǎn)換第4步的逆過程.6.配置多個(gè)歸檔進(jìn)程Q:什么時(shí)候需要