oracle 11g 更改归档模式、目录、日志大小.docx

?oracle 11g 更改归档模式、目录、日志大小?2015-05-18 14:53:07分类：?Oracle一、更改Oracle为归档模式?1.关闭oracleSQL?/default.asp?so=RECCNTsiteid=us%2Fdevp=1nq=NEWqu=shutdownIntlSearch=boolean=PHRASEig=01i=09i=99shutdown?/default.asp?so=RECCNTsiteid=us%2Fdevp=1nq=NEWqu=immediateIntlSearch=boolean=PHRASEig=01i=09i=99immediate; Database closed. Database dismounted. ORACLE instance shut down. 2.启动为mount状态SQL startup mountORACLE instance started.Total System Global Area 2572144640 bytesFixed Size????????????????? 2283984 bytesVariable Size???????????? 738199088 bytesDatabase Buffers???????? 1828716544 bytesRedo Buffers??????????????? 2945024 bytesDatabase mounted.?3.更改为归档模式SQL alter database archivelog Database altered.备注：‘archivelog’为 归档模式；‘noarchivelog’为非归档模式。??4.更改数据库为‘打开’状态SQL alter database open?5.查看归档模式信息SQL archvie log list它会提示归档的模式、是否启用、参数Database log mode????????????? Archive ModeAutomatic archival???????????? EnabledArchive destination??????????? USE_DB_RECOVERY_FILE_DESTOldest online log sequence???? 88Next log sequence to archive?? 90Current log sequence?????????? 90?二、更改归档目录 1.查看参数db_recovery_file_dest （1）“db_recovery_file_dest”是用于定义存储归档日志的目录。通过show parameter命令，显示参数的值为（默认为）fast_recovery_area。示例如下：SQL show parameter db_recoveryNAME???????????????????????????????? TYPE??????? VALUE------------------------------------ ----------- ------------------------------db_recovery_file_dest string????? D:\oracle\fast_recovery_areadb_recovery_file_dest_size big integer 4182M? （2）查看v$recovery_file_dest视图，可得知fast_recovery_area的空间限制、已使用的空间、文件数等。SQL?/default.asp?so=RECCNTsiteid=us%2Fdevp=1nq=NEWqu=selectIntlSearch=boolean=PHRASEig=01i=09i=99select?*?/default.asp?so=RECCNTsiteid=us%2Fdevp=1nq=NEWqu=fromIntlSearch=boolean=PHRASEig=01i=09i=99from?v$recovery_file_dest;NAME???? SPACE_LIMIT????? SPACE_USED???? SPACE_RECLAIMABLE???? NUMBER_OF_FILES----------- ---------- ----------------- ---------------D:\oracle\fast_recovery_area 4385144832 4346230272?????????? 2741248???????????? 102?2.更改归档日志目录 语法：alter system