解决归档日志.docx

解决归档日志:1:在数据库处于打开状态查看数据归档状态:C:\Users\Administratorsqlplus /nologSQL*Plus: Release 11.2.0.3.0 Production on Fri Mar 23 12:10:31 2012Copyright (c) 1982, 2011, Oracle. All rights reserved.SQL connect /as sysdba;Connected.SQL archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 1Next log sequence to archive 2Current log sequence 2从这个可以看出Archive destination USE_DB_RECOVERY_FILE_DEST归档日志的存放闪回区.查看闪回区大小SQL show parameter db_reNAME TYPE VALUE------------------------------------ ----------- ------------------------------db_recovery_file_dest string D:\app\Administrator\fast_reco very_areadb_recovery_file_dest_sizebig integer 4122Mdb_recycle_cache_size big integer 0从这里可以看出闪回去的位置和大小去查看归档所在目录的真实大小 .这里就是闪回区所在的目录,如果真实目录的大小是不是已经打到闪回区的大小,如果是可以增大闪回区的大小,使用下面命令SQL alter system set db_recovery_file_dest_size=6G;System altered.2:数据已经关闭状态数据已经关闭,在开启是报错.可以把数据库开启到mount 状态下修改参数SQL startup mountORACLE instance started.Total System Global Area 2572144640 bytesFixed Size 2257952 bytesVariable Size 570428384 bytesDatabase Buffers 1979711488 bytesRedo Buffers bytesDatabase mounted.可以再这种模式下修改参数 ,和查看.修改完毕后,在开启数据库SQL alter database open;Database altered.3:删除归档日志方法1:可以先删除磁盘上的日志文件,在去数据库里删除逻辑日志记录登陆到rmanC:\Users\Administratorrman target /Recovery Manager: Release 11.2.0.3.0 - Production on Fri Mar 23 12:31:50 2012Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected to target database: TEST (DBID=2076824462)RMAN查看日志清单RMAN list archivelog all;using target database control file instead of recovery catalogList of Archived Log Copies for database with db_unique_name TEST=====================================================================Key ThrdSeq S Low Time------- ---- ------- - -