oracle 11g开启归档模式及修改归档目录.doc

oracle 11g开启归档模式及修改归档目录 2011-06-28 22:29在Oracle 11g，开启archive log模式时，默认归档目录为db_recovery_file_dest指定。此参数在pfile/spfile中可以指定：db_recovery_file_dest=/u01/app/oracle/flash_recovery_area更改归档模式需要在mount状态下，更改归档模式。SQL shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL startup mountORACLE instance started.Total System Global Area 1258291200 bytesFixed Size 1219160 bytesVariable Size 318768552 bytesDatabase Buffers 922746880 bytesRedo Buffers 15556608 bytesDatabase mounted.SQL alter database archivelog;Database altered.SQL alter database open;Database altered.SQL archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 15Next log sequence to archive 17Current log sequence 17更改log_archive_dest_1参数可更改归档日志目录（pfile/spfile中参数db_recovery_file_dest指定的目录将无效）SQL alter system set log_archive_dest_1=location=/data/oracle/log1/archive_log;最后的目录名称需要为archive_log!System altered.SQL archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination /data/oracle/log1/archive_logOldest online log sequence 26Next log sequence to archive 28Current log sequence 28实际上从Oracle 10g开始，可以生成多份一样的日志，保存多个位置，以防不测，方法如下：SQLalter system set log_archive_dest_2=location=/data/oracle/log2/archive_log;SQL archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination/data/oracle/log2/archive_log只能看到最新设置的归档目录。Oldest online log sequence 30Next log sequence to archive 32Current log sequence 32SQL alter system archive log current;System altered.SQL select name from v$archived_log;NAME-/data/oracle/log1/archive_log1_6637_737857592.dbf/data/oracle/log2/archive_log1_6637_737857592.dbf2rows selected.将log_archive_log设置为默认值时，归档目录将会变为?/dbs/arch。SQL alter system set log_archive_dest_1=;System altered.SQL alter system set log_archive_dest_2= 2 ; ;号最后敲入按回车System altered.SQL archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination?/dbs/archOldest online log sequence 33Next log sequence to archive 35Current log sequence 35SQL shutdown immediat重启数据库后，归档目录变回为db_recovery_file_dest指定的目录。SQL archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 33Next log sequence to archive 35Current log sequence 35修改日志文件命名格式：SQL alter system set log_archive_max_processes = 5;SQL alter system set log_archive_format = archive_%t_%s_%r.log scope=spfile; *SQLarchive log list;如果显示为ENABLE则表示已成功归档或 SQLselect log_mode from v$database;如果为ARCHIVELOG则表示已成功归档*SQL show parameter db_recoveryNAME TYPE VALUE- - -db_recovery_file_dest string /data/oracle/flash_recover