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

时间：2022-01-09 17:24:55

现象

登录失败

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

告警日志：

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

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

解决方式:

一、增大归档日志空间

1、启动数据库至nomount

 [oracle@CentOS ~]$ sqlplus / as sysdba

 SQL Production  :: 

 Copyright (c) , , Oracle.  All rights reserved.

 Connected to an idle instance.

 SQL> startup nomount
 ORACLE instance started.

 Total System Global Area   bytes
 Fixed Size             bytes
 Variable Size           bytes
  bytes
 Redo Buffers             bytes
 SQL> show parameter db_recovery_file_dest_size

 NAME                     TYPE     VALUE
 ------------------------------------ ----------- ------------------------------
 db_recovery_file_dest_size         big integer 3882M
 SQL> show parameter db_recovery_file_dest

 NAME                     TYPE     VALUE
 ------------------------------------ ----------- ------------------------------
 db_recovery_file_dest             string     /u01/app/oracle/flash_recovery
                          _area
 db_recovery_file_dest_size         big integer 3882M

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

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

增加归档空间

SQL System altered.

启动数据库

 SQL> shutdown immediate;
 ORA: database not mounted

 ORACLE instance shut down.
 SQL> startup
 ORACLE instance started.

 Total System Global Area   bytes
 Fixed Size             bytes
 Variable Size           bytes
  bytes
 Redo Buffers             bytes
 Database mounted.
 Database opened.

如有必要，清理归档日志

查看归档日志

 [oracle@CentOS ~]$ rman target /

 Recovery Manager: Release   :: 

 Copyright (c) , , Oracle and/or its affiliates.  All rights reserved.

 connected )

 RMAN> crosscheck archivelog all;

 using target database control file instead of recovery catalog
 allocated channel: ORA_DISK_1
 channel ORA_DISK_1: SID device type=DISK
 ......

清理七天前的归档日志

 RMAN> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';

 released channel: ORA_DISK_1
 allocated channel: ORA_DISK_1
 channel ORA_DISK_1: SID device type=DISK
 List of Archived Log Copies for database with db_unique_name VMDB
 =====================================================================

 Key     Thrd Seq     S Low Time
 ------- ---- ------- - ---------
                  A
         Name: /o1_mf_1_41_dr44tg7r_.arc

                  A
         Name: /o1_mf_1_42_dr650bv8_.arc

                  A
         Name: /o1_mf_1_43_dr73pv06_.arc

 ......

参考资料

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

相关文章