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!



27 comments:

Helga said...

I think that you may be interested in another application that quickly eliminates data corruption issues in database files, please take a look at after xp restore i connect to sql database tool and let me know what do you think

stephen 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

Webtrackker Noida 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

Webtrackker Noida 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

Webtrackker Noida 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

Webtrackker Noida 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

Webtrackker Noida 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

Webtrackker Noida 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

Webtrackker Noida said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as Sap abap 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 abap Training institute in indirapuram


SAP abap Training institute in Noida


SAP abap Training institute in Ghaziabad


SAP abap Training institute in Vaishali


SAP abap Training institute in Vasundhara


SAP abap Training institute in Delhi South Ex

Webtrackker Noida 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

Webtrackker Noida 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

Webtrackker Noida said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as Sap pp 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 pp Training institute in indirapuram


SAP

pp Training institute in Noida



SAP pp Training institute in Ghaziabad


SAP pp Training institute in Vaishali


SAP pp Training institute in Vasundhara


SAP pp Training institute in Delhi South Ex

Webtrackker Noida 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

Webtrackker Noida 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

Webtrackker Noida 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

Webtrackker Noida 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

Webtrackker Noida 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

Webtrackker Noida said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as Php 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

Php training institute in indirapuram


Php training institute in Noida


Php training institute in Ghaziabad


Php training institute in Vaishali


Php training institute in Vasundhara


Php training institute in Delhi South Ex

Webtrackker Noida said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as dot net 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

dot net training institute in indirapuram


dot net Training institute in Noida


Dot net Training institute in Ghaziabad


dot net training institute in Vaishali


dot net Training institute in Vasundhara


dot net Training institute in Delhi South Ex

Webtrackker Noida 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

Webtrackker Noida 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

Webtrackker Noida said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as Android 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

Android Training Institute In indirapuram


Android Training Institute In Noida

Android Training Institute In Ghaziabad


Android Training Institute In Vaishali


Android Training Institute In Vasundhara


Android Training Institute In Delhi South Ex

Webtrackker Noida said...

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as Linux 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

linux Training Institute in indirapuram


linux Training Institute in Noida


linux Training Institute in Ghaziabad


linux Training Institute in Vaishali


linux Training Institute in Vasundhara

Webtrackker Noida 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

Webtrackker Noida 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