现场项目经理反馈有个测试环境的u01满,赶紧回电脑边查看
[root@db ~]# df -h|grep u01
/dev/mapper/ol-u01 150G 150G 20K 100% /u01
本以为是审计日志*.aud导致的,通过查看发现alert_orcl.log特别的大,98G大小了,查看日志最后信息如下
[root@db trace]# du -sh alert_orcl.log
98G alert_orcl.log
[root@db trace]# tail -2000 alert_orcl.log
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
2024-05-28T12:16:07.370331+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_lg00_21785.trc:
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
2024-05-28T12:16:07.382341+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_lg00_21785.trc:
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
2024-05-28T12:16:07.394363+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_lg00_21785.trc:
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
2024-05-28T12:16:07.402294+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_lg00_21785.trc:
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
2024-05-28T12:16:07.414308+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_lg00_21785.trc:
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
2024-05-28T12:16:07.422225+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_lg00_21785.trc:
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
2024-05-28T12:16:07.434260+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_lg00_21785.trc:
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
2024-05-28T12:16:07.446381+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_lg00_21785.trc:
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
2024-05-28T12:16:07.476931+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_lg00_21785.trc:
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
2024-05-28T12:16:07.486630+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_lg00_21785.trc:
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
2024-05-28T12:16:07.498588+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_lg00_21785.trc:
[root@db trace]# strings /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_lg00_21785.trc
Trace file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_lg00_21785.trc
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Build label: RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417
ORACLE_HOME: /u01/app/oracle/product/19.0.0/db_1
System name: Linux
Node name: db
Release: 4.14.35-1818.3.3.el7uek.x86_64
Version: #2 SMP Mon Sep 24 14:45:01 PDT 2018
Machine: x86_64
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 23
Unix process pid: 21785, image: oracle@db (LG00)
*** 2024-02-24T21:03:16.476997+08:00
*** SESSION ID:(856.63771) 2024-02-24T21:03:16.477028+08:00
*** CLIENT ID:() 2024-02-24T21:03:16.477035+08:00
*** SERVICE NAME:(SYS$BACKGROUND) 2024-02-24T21:03:16.477041+08:00
*** MODULE NAME:() 2024-02-24T21:03:16.477047+08:00
*** ACTION NAME:() 2024-02-24T21:03:16.477053+08:00
*** CLIENT DRIVER:() 2024-02-24T21:03:16.477058+08:00
Warning: log write elapsed time 572ms, size 570KB
*** 2024-03-14T21:10:49.716398+08:00
Warning: log write elapsed time 783ms, size 1KB
*** 2024-05-18T17:14:33.278909+08:00
Warning: log write elapsed time 532ms, size 1KB
*** 2024-05-19T07:19:00.736745+08:00
Warning: log write elapsed time 720ms, size 46KB
*** 2024-05-19T07:27:51.387936+08:00
Warning: log write elapsed time 544ms, size 1KB
*** 2024-05-20T21:12:30.896303+08:00
Warning: log write elapsed time 2558ms, size 2KB
*** 2024-05-21T21:12:29.842172+08:00
Warning: log write elapsed time 1466ms, size 1KB
*** 2024-05-22T21:14:26.960877+08:00
Warning: log write elapsed time 1682ms, size 1KB
kcrfw_alfs_update_mode: poll->post curr_sched_delay=0 switch_sched_delay=1 curr_sync_count_delta=47 switch_sync_count_delta=121
*** 2024-05-23T15:37:25.312713+08:00
Log file sync switching to post/wait
Current approximate redo synch write rate is 15 per sec
kcrfw_alfs_update_mode: poll->post curr_sched_delay=0 switch_sched_delay=1 curr_sync_count_delta=13 switch_sync_count_delta=86
*** 2024-05-23T17:32:49.860199+08:00
Log file sync switching to post/wait
Current approximate redo synch write rate is 4 per sec
*** 2024-05-25T06:52:23.707684+08:00
*** 2024-05-25T06:52:23.904153+08:00
Warning: log write elapsed time 504ms, size 146KB
*** 2024-05-25T06:53:29.932017+08:00
Warning: log write elapsed time 750ms, size 146KB
*** 2024-05-25T06:53:30.857031+08:00
Warning: log write elapsed time 919ms, size 148KB
*** 2024-05-25T06:53:31.482678+08:00
Warning: log write elapsed time 625ms, size 1KB
*** 2024-05-25T06:53:32.052623+08:00
Warning: log write elapsed time 569ms, size 1KB
*** 2024-05-25T06:54:34.495532+08:00
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kcrfw_do_write: error opening '/archlog/orcl/onlinelog/redo01_2.log'
[root@db trace]# ls -lrt /archlog/orcl/onlinelog/
total 4194320
-rw-r----- 1 root root 1073742336 May 24 09:45 redo01_2.log
-rw-r-----. 1 oracle oinstall 1073742336 May 28 13:06 redo03_2.log
-rw-r-----. 1 oracle oinstall 1073742336 May 28 13:06 redo04_2.log
-rw-r-----. 1 oracle oinstall 1073742336 May 28 13:06 redo02_2.log
处理办法:
方法1、直接修改属组并切换日志不生效
[root@db trace]# chown oracle:oinstall redo01_2.log
[root@db trace]# ls -lrt
total 4194320
-rw-r----- 1 oracle oinstall 1073742336 May 24 09:45 redo01_2.log
-rw-r-----. 1 oracle oinstall 1073742336 May 28 13:06 redo03_2.log
-rw-r-----. 1 oracle oinstall 1073742336 May 28 13:06 redo04_2.log
-rw-r-----. 1 oracle oinstall 1073742336 May 28 13:07 redo02_2.log
SQL > alter database drop logfile member '/archlog/orcl/onlinelog/redo01_2.log';
SQL > alter database add logfile member '/archlog/orcl/onlinelog/redo01_2.log' to group 1;
方法2、删除redo01重新新建redo01
SQL > alter system switch logfile;
SQL > alter system switch logfile;
SQL > alter system switch logfile;
SQL > alter system checkpoint;
SQL > alter database drop logfile group 1;
SQL > alter database add logfile group 1 size 1024M;