Q
Problem solve Get help with specific problems with your technologies, process and projects.

Getting Oracle errors -- database and Web site are down

I have Oracle 8.1.7.0.1 and I am getting the following errors:

ORA-00320 can not read file header from log 1 thread 1
ORA-321 ORACLE_HOME Redo1.log
ORA-27091: skgfqio: unable to queue I/O

Additional information: I have RedHat Linux as the OS and I'm wondering how to correct this so the db will start and our Web site will once again work.
Your database is missing one of its online redo logs. To correct this problem, follow these steps, in SQL*Plus or SVRMGRL:

1. CONNECT / AS SYSDBA
2. STARTUP MOUNT
3. RECOVER DATABASE UNTIL CANCEL;
4. CANCEL (at first prompt)
5. ALTER DATABASE OPEN RESETLOGS;

When you open the database with RESETLOGS, it will recreate the missing online redo log files. At this point, immediately shut down the database and take a good backup! If you do not, you will not be able to recover past the resetlogs operation.

This was last published in May 2004

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close