ORA-27041: redo文件 unable to open file处理

现场项目经理反馈有个测试环境的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;


 

  • 22
    点赞
  • 7
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值