| Corruption in Database [message #55770] |
Fri, 14 February 2003 12:21  |
Alexandre Duarte
Messages: 2
Registered: February 2003
|
Junior Member |
|
|
Peaple,
Would like your help for the solution of a problem.
I possess a base Oracle 8,1,5 in Windows 2000 that it is presenting every day the following messages of error in alert.log:
Ora-01110: it dates file 32: ' G:ORADATAPRIMUSSDBANCO_DATA.DBF '
Ora-01114: Error IO writing block you file 32 (block # 1)
Ora-27072: skgfdisp: Error I/O
Osd-04008: WriteFile() failure, unable you the write you file O/S-Error: (the 5) Access is denied.
This error occurs after startup of Oracle (currently database suffers shutdown normal every day for accomplishment from backup),
and obtains to carry through recover without no problem.
Another point is that this error does not occur exactly in the same datafile and
nor in the same physical disk.
Already I carried through check in the disks and nothing it was found.
Questions:
1) It has some BUG reported for this problem in version 8.1.5?
2) the fact to occur shutdown every day can be the cause of this problem?
3) Why these errors do not appear in ANALYZE VALIDATE STRUCTURE? That it is executed daily.
I am thankful anticipatedly for the contribution.
|
|
|
|
|
|
|
|
| Re: Corruption in Database [message #55777 is a reply to message #55770] |
Sat, 15 February 2003 03:39  |
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
|
Senior Member |
|
|
Look at what Metalink says
fact: Oracle Server - Enterprise Edition
fact: MS Windows NT
symptom: Database startup fails
symptom: ORA-01110: data file %s: '%s'
symptom: ORA-01114: IO error writing block to file %s (block # %s)
symptom: OSD-04008: WriteFile() failure, unable to write to file
symptom: O/S-Error: (OS 5) Access is denied
symptom: Backup Exec Agent runs nightly
cause: Third party BACKUP EXEC AGENT service has the datafile locked.
Stopping the BACKUP SERVICE in the Control Panel, Services on the MS Windows NT,
the ability to mount and recover the specified datafile is successful.
fix:
Open the Control Panel, Services on MS Windows NT and stop the BACKUP EXEC
Service. Perform the following steps to recover the datafile:
1. log into Server Manager
2. connect internal
3. shutdown immediate
4. startup pfile=(drive:/directory_location/initSID.ora)
If further recovery on that datafile is needed:
5. Check to see if datafile is in backup mode by selecting from V$BACKUP.
If it is, do: ALTER DATABASE DATAFILE '<full path and file name>' END
BACKUP;
before going to step 6. If it is not, go directly to step 6.
6. RECOVER DATAFILE '(drive:/directory_location/file_name)';
7. alter database open;
sai
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
