on 09-14-2008 8:59 AM
Hello,
I get the following erroru201D SQL error 1552 occurred when accessing program SAPu201D
When I try to logon to SAP System:
And from alert_crp.log I can see:
Sun Aug 24 08:33:33 2008
KCF: write/open error block=0xfa5 online=1
file=2 G:\ORACLE\CRP\SAPDATA1\UNDO_1\UNDO.DATA1
error=27070 txt: 'OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.'
Automatic datafile offline due to write error on
file 2: G:\ORACLE\CRP\SAPDATA1\UNDO_1\UNDO.DATA1
Sun Aug 24 08:33:33 2008
Errors in file g:\oracle\crp\saptrace\background\crp_smon_1672.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: 'G:\ORACLE\CRP\SAPDATA1\UNDO_1\UNDO.DATA1'
And From crp_smon_2068.trc I can see:
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: 'G:\ORACLE\CRP\SAPDATA1\UNDO_1\UNDO.DATA1'
Furthermore from database level I can see datafile1 itu2019s on recovery status and I already tried to bring it on online but I canu2019t as mention below:
SQL> SELECT FILE#, STATUS, NAME FROM V$DATAFILE;
FILE# STATUS
-
-
NAME
-
1 SYSTEM
G:\ORACLE\CRP\SAPDATA1\SYSTEM_1\SYSTEM.DATA1
2 RECOVER
G:\ORACLE\CRP\SAPDATA1\UNDO_1\UNDO.DATA1
SQL> recover datafile 1;
ORA-00283: recovery session canceled due to errors
ORA-01124: cannot recover data file 1 - file is in use or recovery
ORA-01110: data file 1: 'G:\ORACLE\CRP\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'
SQL> alter database datafile 1 online;
Database altered.
Please advice me.
Regards,
Ahmed
Dear Stefan,
First let me thank you for your interest and help,
And I would like to tell you that the problem was resolved by change the command, which you said
Regarding Vmware yes we already used and for Backup we used VERITAS but itu2019s still in processing to installing, once again Iu2019m very thankful for you.
Regards,
Ahmed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Ahmed,
in the concept you did the right actions, but you have to recover the datafile 2 not the datafile 1.
> 2 RECOVER G:\ORACLE\CRP\SAPDATA1\UNDO_1\UNDO.DATA1
> SQL> recover datafile 2;
> SQL> alter database datafile 2 online;
But this is only the action to "repair" the situation .. the problem is the error before
> error=27070 txt: 'OSD-04016: Error queuing an asynchronous I/O request.
Are you using VMware and Legato Filesystem Sync Driver or any Backup Software like Backup Exec?
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.