Shulou(Shulou.com)05/31 Report--

This article introduces you oracle downtime and startup error ora03113 how to do, the content is very detailed, interested friends can refer to, hope to be helpful to you.

I. failure situation

The application cannot connect to the database. Check the oracle and find that it is down.

Report an error after startup

ORA-03113: end-of-file on communication channel

Second, find out the reason

View alter Log

Tail-500 / oracle/database/oracle/diag/rdbms/udb/udb1/trace/alter_UDB1.log

Unable to create archivelog file'+ FRA/archivelog/1_48359_931010941.dbf'

ARCH: Error 19504 Creating archivelog file to'+ FRA/archivelog/1_48359_931010941.dbf'

Errors in file / oracle/database/oracle/diag/rdbms/udb/UDB1/trace/UDB1_ora_22183.trc:

ORA-16038: log 1 sequence# 48359 cannot be archived

ORA-19504: failed to create file ""

ORA-00312: onlinelog 1 thread 1:'+ DATA/udb/onlinelog/group_1.257.931010945'

ORA-00312: onlinelog 1 thread 1:'+ FRA/udb/onlinelog/group_1.257.931010945'

Execute archive log list

SQL > archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination + FRA/archivelog

Oldest online log sequence 48371

Next log sequence to archive 48372

Current log sequence 48372

Preliminary judgment is caused by insufficient remaining capacity of flashback space.

III. Resolution process

Shutdown immediate

Startup mount

Increase flashback space capacity ALTER SYSTEM SET db_recovery_file_dest_size=20g scope=both

Shutdown immediate

Startup

Still reported an error ORA03113

Switch user su-grid

Execute the asmcmd command

Execute lsdg to check the usage of directory space and find that the + FRA directory has no free_MB.

Manually delete the archive log file rm-fr'1' 45x.dbf' under the + FRA/archivelog directory

Switch to the oracle user and check the archive log under rman

Rman > crosscheck archivelog all

Rman > delete expired archivelog all; (delete archivelog until time 'sysdate-7';)

Execute sqlplus / as sysdba

Sql > startup

The instance starts normally

About oracle downtime and startup error ora03113 what to do to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.