Problem

[oracle@dbserver ~]$ tail -f /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/alert_ORCL1.log
 ORA-00312: online log 2 thread 1: '+REDO/ORCL/redo02a.log'
 ORA-00312: online log 2 thread 1: '+FRA/ORCL/redo02b.log'
 USER (ospid: 74269): terminating the instance due to error 16038
 Tue Aug 14 11:29:46 2018
 System state dump requested by (instance=1, osid=74269), summary=[abnormal instance termination].
 System State dumped to trace file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_diag_74168_20180814112946.trc
 Tue Aug 14 11:29:47 2018 Dumping diagnostic data in directory=[cdmp_20180814112946], requested by (instance=1, osid=74269), summary=[abnormal
 Tue Aug 14 11:29:48 2018 Instance terminated by USER, pid = 74269

Analyze

ORA-16014 and ORA-00312 Attempting to Startup Database (Doc ID 104918.1)

Solution

1. Verify that the log_archive_dest is pointing to a valid directory.
2. Make sure that there is sufficient space on disk to hold the archived logs.
If necessary, move the existing archived logs off of this file system to either tape or another drive to make room.
3. Once sufficient room has been made, start up the database. It should come up without errors.
4. If log_archive_dest_n (where n = 1 to 5) is specified for a standby database, make sure that the primary can send the archived log to the standby.



Komentáře