oracle11g開啟歸檔模式及修改歸檔目錄

1、oracle11g 開啟歸檔模式及修改歸檔目錄 2011-06-2822:29在 Oracle11g,開啟 archivelog 模式時，默認(rèn)歸檔目錄為 db_recovery_file_dest 指定。此參數(shù)在 pfile/spfile 中可以指定：db_recovery_file_dest=/u01/app/oracle/flash_recovery_area更改歸檔模式需要在 mount 狀態(tài)下，更改歸檔模式。SQLshutdownimmediate;Databaseclosed.Databasedismounted.ORACLEinstanceshutdown.SQLstartupmo

2、untORACLEinstancestarted.TotalSystemGlobalArea1258291200bytesFixedSize1219160bytesVariableSize318768552bytesDatabaseBuffers922746880bytesRedoBuffers15556608bytesDatabasemounted.SQLalterdatabasearchivelog;Databasealtered.SQLalterdatabaseopen;Databasealtered.SQLarchiveloglist;DatabaselogmodeArchiveMod

3、eAutomaticarchivalEnabledArchivedestinationUSE_DB_RECOVERY_FILE_DESTOldestonlinelogsequence15Nextlogsequencetoarchive17Currentlogsequence17更改 log_archive_dest_1 參數(shù)可更改歸檔日志目錄（pfile/spfile 中參數(shù)db_recovery_file_dest 旨定的目錄將無效）SQLaltersystemsetlog_archive_dest_1=location=/data/oracle/log1/archive_log;最后的目錄

4、名稱需要為 archive_log!Systemaltered.SQLarchiveloglist;Archivedestination/data/oracle/log1/archive_logOldestonlinelogsequence26Nextlogsequencetoarchive28Currentlogsequence28實(shí)際上從 Oracle10g 開始，可以生成多份一樣的日志，保存多個位置，以防不測,方法如下：SQLaltersystemsetlog_archive_dest_2=location=/data/oracle/log2/archive_log;SQLarchive

5、loglist;Archivedestination 設(shè)置的歸檔目錄。Oldestonlinelogsequence30Nextlogsequencetoarchive32Currentlogsequence32SQLaltersystemarchivelogcurrent;Systemaltered.AutomaticarchivalEnabledDatabaselogmodeArchiveModeAutomaticarchivalEnabled/data/oracle/log2/archive_log只能看到最新SQLselectnamefromv$archived_log;NAME/da

6、ta/oracle/log1/archive_log1_6637_737857592.dbf/data/oracle/log2/archive_log1_6637_737857592.dbf2rowsselected.將 log_archive_lo 改置為默認(rèn)值時，歸檔目錄將會變?yōu)椋?dbs/arch。SQLaltersystemsetlog_archive_dest_1=;Systemaltered.SQLaltersystemsetlog_archive_dest_2=;號最后敲入按回車Systemaltered.SQLarchiveloglist;DatabaselogmodeArch

7、iveModeAutomaticarchivalEnabledArchivedestination?/dbs/arch33OldestonlinelogsequenceNextlogsequencetoarchive35Currentlogsequence35SQLshutdownimmediat重啟數(shù)據(jù)庫后，歸檔目錄變回為db_recovery_file_dest 指定的目錄ArchiveModeEnabledUSE_DB_RECOVERY_FILE_DESTOldestonlinelogsequence33Nextlogsequencetoarchive35Currentlogsequen

8、ce35修改日志文件命名格式：SQLaltersystemsetlog_archive_max_processes=5;SQLaltersystemsetlog_archive_format=archive_%t_%s_%r.logscope=spfile;*SQLarchiveloglist;如果顯示為 ENABLED 表示已成功歸檔或SQLselectlog_modefromv$database;如果為 ARCHIVELOG 表示已成功歸檔*SQLarchiveloglist;DatabaselogmodeAutomaticarchivalArchivedestination*SQLshowparameterdb_recoveryNAMETYPEVALUEdb_recovery_file_deststring/data/oracle/flash_recovery_areadb