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>