集团
标准
excel标准偏差excel标准偏差函数exl标准差函数国标检验抽样标准表免费下载红头文件格式标准下载
化办公室：[VV986T-J682P28-JP266L8-68PNN]oracleg更改归档模式目录日志大小oracle11g更改归档模式、目录、日志大小一、更改Oracle为归档模式1.关闭oracleSQL>shutdownimmediate;Databaseclosed.Databasedismounted.ORACLEinstanceshutdown.2.启动为mount状态SQL>startupmountORACLEinstancestarted.TotalSystemGlobalAreabytesFixedSize2283984bytesVariableSizebytesDatabaseBuffersbytesRedoBuffers2945024bytesDatabasemounted.3.更改为归档模式SQL>alterdatabasearchivelogDatabasealtered.备注：‘archivelog’为归档模式；‘noarchivelog’为非归档模式。4.更改数据库为‘打开’状态SQL>alterdatabaseopen5.查看归档模式信息SQL>archvieloglist它会提示归档的模式、是否启用、参数DatabaselogmodeArchiveModeAutomaticarchivalEnabledArchivedestinationUSE_DB_RECOVERY_FILE_DESTOldestonlinelogsequence88Nextlogsequencetoarchive90Currentlogsequence90二、更改归档目录1.查看参数db_recovery_file_dest（1）“db_recovery_file_dest”是用于定义存储归档日志的目录。通过showparameter命令，显示参数的值为（默认为）fast_recovery_area。示例如下：SQL>showparameterdb_recoveryNAMETYPEVALUE-----------------------------------------------------------------------------db_recovery_file_deststringD:\oracle\fast_recovery_areadb_recovery_file_dest_sizebiginteger4182M（2）查看v$recovery_file_dest视图，可得知fast_recovery_area的空间限制、已使用的空间、文件数等。SQL>select*fromv$recovery_file_dest;NAMESPACE_LIMITSPACE_USEDSPACE_RECLAIMABLENUMBER_OF_FILES-----------------------------------------------------D:\oracle\fast_recovery_area27412481022.更改归档日志目录语法：altersystemset参数=值scope=spfile;示例：SQL>altersystemsetdb_recovery_file_dest='D:\oracle\archivelog'scope=spfile;Systemaltered.三、更改归档日志大小1.查看参数'db_recovery_file_dest_size'值SQL>showparameterdb_recoverNAMETYPEVALUE-----------------------------------------------------------------------------db_recovery_file_deststringD:\oracle\archivelogdb_recovery_file_dest_sizebiginteger4182M2.更改参数'db_recovery_file_dest_size'值大小SQL>altersystemsetdb_recovery_file_dest_size=41820Mscope=spfile;Systemaltered.3.关闭数据库，重启数据库SQL>shutdownimmediate;Databaseclosed.Databasedismounted.ORACLEinstanceshutdown.SQL>startupopen;ORACLEinstancestarted.TotalSystemGlobalAreabytesFixedSize2283984bytesVariableSizebytesDatabaseBuffersbytesRedoBuffers2945024bytesDatabasemounted.Databaseopened.4.再次查看参数'db_recovery_file_dest_size'值SQL>showparameterdb_recoNAMETYPEVALUE-----------------------------------------------------------------------------db_recovery_file_deststringD:\oracle\archivelogdb_recovery_file_dest_sizebiginteger41820M
浙公网安备 33021202002483