Solution : https://service.sap.com/sap/support/notes/948294 (SAP Service marketplace login required)
Summary :
This SAP Note addresses an issue with online backup failures of Oracle databases on AIX systems using JFS2 and Oracle 10g. Oracle's utilization of JFS2's Concurrent I/O (CIO) bypasses the AIX filesystem cache, improving IO performance but causing inaccessibility to datafiles for external tools (e.g., cp, dd) when the database is open. For systems pre-Oracle 11.2.0.2 on AIX 6.1, mounting with the -o cio option is mandated. For those on Oracle 11.2.0.2 and higher, the introduction of the O_CIOR option permits improved access, negating the need for the -o cio mount option. Use of Oracle RMAN or backup utilities supporting CIO is recommended over traditional tools.
Key words :
customer component bc-db-ora oracle priority recommendations / additional info category workaround, brbackup filesystemio_options cio bki4008e dbv cp dd jfs2 aix5, recommendations 527250 dbv-00100 composite sap note, oracle 10g 527250 dbv-00100 composite sap note, __%pdfstyle%__ / } symptom online backup, tape_copy_cmd = dd disk_copy_cmd = dd dd_flags =, mount jfs2 filesystems holding $oracle_home, mounting filesystems holding oracle datafiles, / __%pdfstyle%__font-size, initialization parameter filesystemio_options=setall
Related Notes :
| 999524 | Oracle 10.2 platform support for Async IO |
| 830576 | Parameter recommendations for Oracle 10g |
| 527250 | DBV-00100 Composite SAP note |
| 1972803 | SAP on AIX: Recommendations |