Solution : https://service.sap.com/sap/support/notes/328785 (SAP Service marketplace login required)
Summary :
The SAP Note addresses issues with Oracle database file accessibility, resulting in ORA errors and ABAP runtime errors due to files set to OFFLINE automatically due to various reasons, including temporary hardware problems and OS errors. Specific errors such as ORA-00376, ORA-00372, and ORA-01545 are discussed, indicating file read, modification, and rollback segment issues respectively, accompanied by brbackup warnings when files are not ONLINE. The resolution involves checking OFFLINE tablespaces and data files, setting them ONLINE using SQLPLUS commands, and if necessary, recovering the data files to resolve the errors effectively.
Key words :
write/open error block=0x5bd0 online=0 file=15 /oracle/n11/sapdata35/protd_1/protd, abap runtime error dbif_rsql_sql_error sql error 376 occured, recover datafile '/oracle/hx1/sapdata8/stabi_2/stabi, /oracle/n11/sapdata35/protd_1/protd, hardware problems operating system error message, alter database datafile '<path_and_name>' offline [drop], 'ibm aix risc system/6000 error, alter database datafile '<path_and_name>' online, statement sql error 372 occured, alter tablespace <tablespace_name> online
Related Notes :
| 605062 | FAQ: Restore and recovery |
| 546006 | Problems with Oracle due to operating system errors |
| 210385 | AIX 4.3.3: error: 11: Resource temporarily unavailable |
| 197185 | AIX upgrade from 4.3.2 to 4.3.3 Database crashes with KCF |
| 8485 | Default limit for file size in AIX is 1 GB |
| 4190 | Recovery for defective rollback segments |