• ORA-03113错误


    SQL> startup
    ORACLE instance started.
    
    Total System Global Area  476004352 bytes
    Fixed Size		    2254384 bytes
    Variable Size		  343935440 bytes
    Database Buffers	  125829120 bytes
    Redo Buffers		    3985408 bytes
    Database mounted.
    ORA-03113: end-of-file on communication channel
    Process ID: 1890
    Session ID: 1 Serial number: 5
    

      数据库在开启的时候报错。

      查看后台日志,归档日志无法正常归档

    ARC1: Becoming the 'no SRL' ARCH
    ARC2: Becoming the heartbeat ARCH
    Sat Nov 03 12:27:11 2018
    ARC3 started with pid=21, OS id=1898
    Unable to create archive log file '/ARCH1_31_964653959.dbf'
    Unable to create archive log file '/ARCH1_32_964653959.dbf'
    ARCH: Error 19504 Creating archive log file to '/ARCH1_31_964653959.dbf'
    ARC1: Error 19504 Creating archive log file to '/ARCH1_32_964653959.dbf'
    Errors in file /oracle/diag/rdbms/oracle/oracle/trace/oracle_ora_1890.trc:
    ORA-16038: log 1 sequence# 31 cannot be archived
    ORA-19504: failed to create file ""
    ORA-00312: online log 1 thread 1: '/oradata/oracle/redo01.log'
    ARCH: Archival stopped, error occurred. Will continue retrying
    ORACLE Instance oracle - Archival Error
    ORA-16038: log 2 sequence# 32 cannot be archived
    ORA-19504: failed to create file ""
    ORA-00312: online log 2 thread 1: '/oradata/oracle/redo02.log'
    USER (ospid: 1890): terminating the instance due to error 16038
    Sat Nov 03 12:27:11 2018
    System state dump requested by (instance=1, osid=1890), summary=[abnormal instance termination].
    

      将数据库启动到mount状态查看归档路径以及归档路径权限

    SQL> startup mount
    ORACLE instance started.
    
    Total System Global Area  476004352 bytes
    Fixed Size		    2254384 bytes
    Variable Size		  343935440 bytes
    Database Buffers	  125829120 bytes
    Redo Buffers		    3985408 bytes
    Database mounted.
    SQL> archive log list
    Database log mode	       Archive Mode
    Automatic archival	       Enabled
    Archive destination	       /ARCH
    Oldest online log sequence     31
    Next log sequence to archive   31
    Current log sequence	       33
    

      

    drwxrwxr-x    2 oracle oinstall  4096 Jun  2 15:00 arch
    

      目录权限正确,但是无法进行归档,这是怎么回事呢?后来经过判断,进入该目录创建文件,文件是root:root权限,可以知道当时授权的时候使用的是下面语句

    chown oracle:oinstall /arch
    

      对目录重新进行授权

    chown -R oracle:oinstall /arch
    

      重新打开数据库,正常打开

    SQL> alter database open;
    
    Database altered.
    
    SQL> 
    

      

  • 相关阅读:
    禁用aspx页面的客户端缓存
    水晶报表的自动换行(转)
    ORACLE锁的管理
    同时使用有线和无线
    Oracle系统表的查询
    Oracle中临时表的深入研究
    我的My Life Rate
    [学习笔记]c#Primer中文版命名空间
    出差兰州·火车上
    [学习笔记]c#Primer中文版类设计、static成员、const和readonly数据成员
  • 原文地址:https://www.cnblogs.com/hanglinux/p/9900439.html
Copyright © 2020-2023  润新知