on 08-25-2008 2:35 AM
Hi every body ..plz help me on this..
We are facing database termination problem in ECC6 production syste.
Database: Oracle 10.2, O/S: Windows 2003. Spam :27, SP level 13.
Error is:
Errors in file f:\oracle\p02\saptrace\background\p02_ckpt_6520.trc:
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: 'D:\ORACLE\P02\ORIGLOGB\CNTRL\CNTRLP02.DBF'
ORA-27072: File I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.
When we are performing backup then data base termination occuring freequently.
Give right solution as early as possible.
Thanks,
Nani.
I/O errors are caused by harddisk/driver problems. If your data resides on a SAN system open all call and let the vendor check the SAN and the driver/firmware versions.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Have a look at below snote which actually speaks about the oracle error codes
Snote : 546006
within the Snote it says :-
" If you cannot access a database file (for instance a data file, control file or RedoLog) for whatever reason, an ORA-270xx appears. The actual cause comes from additional error messages (usually in the operating system) that occur on ORA-270xx. "
And as per your last update
" ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: 'D:\ORACLE\P02\ORIGLOGB\CNTRL\CNTRLP02.DBF' "
i think there is problem accessing the database control file. Hence you are facing the above problem.
I think if you recreate your control file i think, it should resolve the problem.
Hope it will be helpful to resolve your problem.
Rgds
Radhakrishna D S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
For better protection of the control file, Oracle is able to mirror this file, that means to keep several copies of it in different locations and modify them simultaneously. In SAP installations, the control file is stored in three copies ( which must be created on three physically separate disks. )
As per my knowledge the location of the control files and of the offline redologs is configured in the Oracle profile init<DBSID>.ora
I think u can copy one of the three copies other than the current corrupted one to recover your control file.
I hope this work.
Rgds
Radhakrishna D S
Hello. Per Note Note 546006 - Problems with Oracle due to operating system errors :
"This is caused by an external Oracle process that blocks a file that Oracle wants to access."
Like antivirus or other ... Read note.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.