A few basic notes on Oracle Database Administration.

Saturday, October 18, 2008

Lazy Log Writer - Vindication & thank you Fitaloon

The final chapter: The database continued plodding along wretchedly until last Friday night at midnight when I got a call, "The production database is down."
I crawled out of bed, bleary eyed, signed in, and tried to start it. I got:

ALTER DATABASE MOUNT
Sat Oct 11 00:35:05 2008
ORA-00202: control file: '/u01/control02.ctl'
ORA-27037: unable to obtain file status

That woke me up. OK, Who/what messed with the control file?
I tried to look at the file and got a message that told me that not only was the control file inaccessable, the entire drive /u01 was inaccessable.

I called across the great divide to the company who controls the hardware and eventually got, "The backup battery for the write cache needs replacing in the SAN".

Monday morning I resent my email to management from a week and a half before. I highlighted my paraphrasing of Fitaloon's comment to my first posting on this subject, "Could our problem be caused by the write cache on the disk having some sort of problem? For example, could it
be something as simple as failed backup batteries for the write cache?" Thank you, Fitaloon. You hit the nail on the head.

Since the replacement of the battery, our log writer has been zipping right along, good performance, at last!



24 comments:

Unknown said...

Thanks - i'll have my sysadmins check the batteries :)

sneha said...

Hi,
I am newbee to the Oracle this matter seems to be useful for me about the partitions.
Regards
Sneha
Oracle Fusion Middleware

Tani said...

Hey Girlgeek, I had a same problem with my database where i got the same problem with my control file but when I re-booted the entire system it again started working fine.Until now I never understood why this happened and that too on weekends.

sap erp 6.0

Unknown said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as Oracle training. Webtrackker is not only training institute but also it also provide best IT solution to his client. Webtrackker provide training by experienced and working in the industry on same technology.Webtrackker Technology C-67 Sector-63 Noida 8802820025

Oracle training institute in indirapuram

Unknown said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as Oracle training. Webtrackker is not only training institute but also it also provide best IT solution to his client. Webtrackker provide training by experienced and working in the industry on same technology.Webtrackker Technology C-67 Sector-63 Noida 8802820025


Oracle training institute in Noida

Unknown said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as Oracle training. Webtrackker is not only training institute but also it also provide best IT solution to his client. Webtrackker provide training by experienced and working in the industry on same technology.Webtrackker Technology C-67 Sector-63 Noida 8802820025


Oracle training institute in Ghaziabad

Unknown said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as Oracle training. Webtrackker is not only training institute but also it also provide best IT solution to his client. Webtrackker provide training by experienced and working in the industry on same technology.Webtrackker Technology C-67 Sector-63 Noida 8802820025


Oracle training institute in Vaishali

Unknown said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as Oracle training. Webtrackker is not only training institute but also it also provide best IT solution to his client. Webtrackker provide training by experienced and working in the industry on same technology.Webtrackker Technology C-67 Sector-63 Noida 8802820025


Oracle training institute in Vasundhara

Unknown said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as Oracle training. Webtrackker is not only training institute but also it also provide best IT solution to his client. Webtrackker provide training by experienced and working in the industry on same technology.Webtrackker Technology C-67 Sector-63 Noida 8802820025


Oracle training institute in Delhi South Ex

Unknown said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as Sap Basis training. Webtrackker is not only training institute but also it also provide best IT solution to his client. Webtrackker provide training by experienced and working in the industry on same technology.Webtrackker Technology C-67 Sector-63 Noida 8802820025


SAP basis Training institute in indirapuram


SAP basis Training institute in Noida


SAP basis Training institute in Ghaziabad


SAP basis Training institute in Vasundhara


SAP basis Training institute in Vaishali


SAP basis Training institute in Delhi South Ex

Unknown said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as Sap fico training. Webtrackker is not only training institute but also it also provide best IT solution to his client. Webtrackker provide training by experienced and working in the industry on same technology.Webtrackker Technology C-67 Sector-63 Noida 8802820025


SAP fico Training institute in indirapuram


SAP fico Training institute in Noida


SAP fico Training institute in Ghaziabad


SAP fico Training institute in Vaishali


SAP fico Training institute in Vasundhara


SAP fico Training institute in Delhi South Ex

Unknown said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as Sap sd training. Webtrackker is not only training institute but also it also provide best IT solution to his client. Webtrackker provide training by experienced and working in the industry on same technology.Webtrackker Technology C-67 Sector-63 Noida 8802820025


SAP sd Training institute in indirapuram


SAP sd Training institute in Noida


SAP sd Training institute in Ghaziabad


SAP sd Training institute in Vaishali


SAP sd Training institute in Vasundhara


SAP sd Training institute in Delhi South Ex

Unknown said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as Sap crm training. Webtrackker is not only training institute but also it also provide best IT solution to his client. Webtrackker provide training by experienced and working in the industry on same technology.Webtrackker Technology C-67 Sector-63 Noida 8802820025


SAP crm Training institute in indirapuram


SAP crm Training institute in Noida


SAP crm Training institute in Ghaziabad


SAP crm Training institute in Vaishali


SAP crm Training institute in Vasundhara

SAP crm Training institute in Delhi South Ex

Unknown said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as Sap mm training. Webtrackker is not only training institute but also it also provide best IT solution to his client. Webtrackker provide training by experienced and working in the industry on same technology.Webtrackker Technology C-67 Sector-63 Noida 8802820025

SAP mm Training institute in indirapuram


SAP mm Training institute in Noida


SAP mm Training institute in Ghaziabad


SAP mm Training institute in Vaishali


SAP mm Training institute in Vasundhara


SAP mm Training institute in Delhi South Ex

Unknown said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as sas training. Webtrackker is not only training institute but also it also provide best IT solution to his client. Webtrackker provide training by experienced and working in the industry on same technology.Webtrackker Technology C-67 Sector-63 Noida 8802820025

SAS training institute in indirapuram


SAS

training institute in Noida



SAS training institute in Ghaziabad


SAS training institute in Vaishali


SAS training institute in Vasundhara


SAS training institute in Delhi South Ex

Unknown said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as java training. Webtrackker is not only training institute but also it also provide best IT solution to his client. Webtrackker provide training by experienced and working in the industry on same technology.Webtrackker Technology C-67 Sector-63 Noida 8802820025


Java Training institute in indirapuram


Java training institute in Noida


Java training institute in Ghaziabad


java training institute in Vaishali


Java Training institute in Vasundhara


Java Training institute in Delhi South Ex

Unknown said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as hadoop training. Webtrackker is not only training institute but also it also provide best IT solution to his client. Webtrackker provide training by experienced and working in the industry on same technology.Webtrackker Technology C-67 Sector-63 Noida 8802820025

Hadoop Training institute in indirapuram


Hadoop Training institute in Noida


Hadoop Training institute in Ghaziabad


Hadoop Training institute in Vaishali


Hadoop Training institute in Vasundhara


Hadoop Training institute in Delhi South Ex

Unknown said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as AngularJS training. Webtrackker is not only training institute but also it also provide best IT solution to his client. Webtrackker provide training by experienced and working in the industry on same technology.Webtrackker Technology C-67 Sector-63 Noida 8802820025

AngularJS Training Institute In indirapuram


AngularJS Training Institute In Noida


AngularJS Training Institute In Ghaziabad


AngularJS Training Institute In Vaishali


AngularJS Training Institute In Vasundhara


AngularJS Training Institute In Delhi South Ex

Unknown said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as Oracle training. Webtrackker is not only training institute but also it also provide best IT solution to his client. Webtrackker provide training by experienced and working in the industry on same technology.Webtrackker Technology C-67 Sector-63 Noida 8802820025



Oracle training institute in indirapuram


Oracle training institute in Delhi South Ex


Oracle training institute in Vaishali


Oracle training institute in Noida


Oracle training institute in Ghaziabad


Oracle training institute in Vasundhara

Unknown said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as Web designing training. Webtrackker is not only training institute but also it also provide best IT solution to his client. Webtrackker provide training by experienced and working in the industry on same technology. Webtrackker Technology C-67 Sector-63 Noida 8802820025

Web designing training institute in indirapuram


Web designing training institute in Vasundhara


Web designing training institute in Noida


Web designing training institute in Delhi South Ex


Web designing training institute in Ghaziabad


Web designing training institute in Vaishali

Tourism in India said...

This is just the kind of information that I had been looking for a long time. Thank you very much for posting this blog it’s very nice.

Oracle Fusion financial

Unknown said...

Thank you very much for posting this blog it’s very nice.


Weblogic Administration Training

Unknown said...

This Blog Provides Very Useful and Important Information. I just Want to share this blog with my friends and family members. United States Medical Licensing Examination

Ranjith said...

Thank you for sharing such a great information.Its really nice and informative.hope more posts from you. I also want to share some information recently i have gone through and i had find the one of the python training.

python Training in chennai

python Course in chennai