归档日志空间满导致DB启动失败

现象

登录失败

 

告警日志：

由此可知，归档日志空间已满

 

解决方式:

一、增大归档日志空间

1、启动数据库至nomount

 1 [oracle@CentOS ~]$ sqlplus / as sysdba
 2 
 3 SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 24 10:12:51 2018
 4 
 5 Copyright (c) 1982, 2009, Oracle.  All rights reserved.
 6 
 7 Connected to an idle instance.
 8 
 9 SQL> startup nomount
10 ORACLE instance started.
11 
12 Total System Global Area  776646656 bytes
13 Fixed Size            2217384 bytes
14 Variable Size          583010904 bytes
15 Database Buffers      188743680 bytes
16 Redo Buffers            2674688 bytes
17 SQL> show parameter db_recovery_file_dest_size
18 
19 NAME                     TYPE     VALUE
20 ------------------------------------ ----------- ------------------------------
21 db_recovery_file_dest_size         big integer 3882M
22 SQL> show parameter db_recovery_file_dest
23 
24 NAME                     TYPE     VALUE
25 ------------------------------------ ----------- ------------------------------
26 db_recovery_file_dest             string     /u01/app/oracle/flash_recovery
27                          _area
28 db_recovery_file_dest_size         big integer 3882M

 

查看db_recovery_file_dest路径在磁盘空间中是否有足够空间

1 [root@CentOS ~]# df -h
2 文件系统          容量  已用  可用 已用%% 挂载点
3 /dev/sda6              56G   24G   30G  45% /
4 tmpfs                 932M  480M  452M  52% /dev/shm
5 /dev/sda1             194M   32M  152M  18% /boot
6 /dev/sda2              20G   18G  1.4G  93% /home
7 /dev/sda3              20G  592M   19G   4% /opt
8 .host:/                40G   15G   25G  38% /mnt/hgfs

 

增加归档空间

 1 SQL> ALTER SYSTEM SET db_recovery_file_dest_size=10g scope=both; 2 3 System altered. 

 启动数据库

 1 SQL> shutdown immediate;
 2 ORA-01507: database not mounted
 3 
 4 
 5 ORACLE instance shut down.
 6 SQL> startup
 7 ORACLE instance started.
 8 
 9 Total System Global Area  776646656 bytes
10 Fixed Size            2217384 bytes
11 Variable Size          583010904 bytes
12 Database Buffers      188743680 bytes
13 Redo Buffers            2674688 bytes
14 Database mounted.
15 Database opened.

 如有必要，清理归档日志

查看归档日志

 1 [oracle@CentOS ~]$ rman target /
 2 
 3 Recovery Manager: Release 11.2.0.1.0 - Production on Sat Mar 24 11:32:05 2018
 4 
 5 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
 6 
 7 connected to target database: VMDB (DBID=4152029682)
 8 
 9 RMAN> crosscheck archivelog all;
10 
11 using target database control file instead of recovery catalog
12 allocated channel: ORA_DISK_1
13 channel ORA_DISK_1: SID=36 device type=DISK
14 ......

 

清理七天前的归档日志

 1 RMAN> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';
 2 
 3 released channel: ORA_DISK_1
 4 allocated channel: ORA_DISK_1
 5 channel ORA_DISK_1: SID=36 device type=DISK
 6 List of Archived Log Copies for database with db_unique_name VMDB
 7 =====================================================================
 8 
 9 Key     Thrd Seq     S Low Time 
10 ------- ---- ------- - ---------
11 2       1    41      A 02-AUG-17
12         Name: /u01/app/oracle/flash_recovery_area/VMDB/archivelog/2017_08_03/o1_mf_1_41_dr44tg7r_.arc
13 
14 3       1    42      A 03-AUG-17
15         Name: /u01/app/oracle/flash_recovery_area/VMDB/archivelog/2017_08_03/o1_mf_1_42_dr650bv8_.arc
16 
17 4       1    43      A 03-AUG-17
18         Name: /u01/app/oracle/flash_recovery_area/VMDB/archivelog/2017_08_04/o1_mf_1_43_dr73pv06_.arc
19 
20 ......

 

 

 

参考资料

https://zhidao.baidu.com/question/1575284660590623380.html

 

转载于:https://www.cnblogs.com/ZeroTiny/p/8629795.html