CIFS Filesystem (Common Internet File System (CIFS)) on Linux results in ORA-19510, ORA-27045, ORA-00317 & ORA-00334
Common Internet File System(CIFS) on Linux
Applicable Error Code
ORA-19510, ORA-27045, ORA-00317 & ORA-00334
CIFS Filesystem is not supported by Oracle and should not be used.
As we execute Run-Interactive (default transfer-activelog) dbvisit DDC, in the alertlog for Primary database we are seeing the following message:
ORA-19510: failed to set size of 342578 blocks for file "/bktdb1/OracleBack/archive/thread_1_seq_50329.1023.860963407" (block size=512) ORA-27045: unable to close the file Linux-x86_64 Error: 5: Input/output error Additional information: 4
Archive was successfully shipped to standby & when the
apply was attempted, we received the following message in Standby alert log file (ORA-00317 & ORA-00334):
ORA-1547 signalled during: ALTER DATABASE RECOVER CANCEL ... ALTER DATABASE RECOVER CANCEL ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL ... Sat Oct 11 16:36:23 2014 ALTER DATABASE RECOVER standby database NOPARALLEL Media Recovery Start Serial Media Recovery started Managed Standby Recovery not using Real Time Apply ORA-279 signalled during: ALTER DATABASE RECOVER standby database NOPARALLEL ... ALTER DATABASE RECOVER LOGFILE '/bktdb1/OracleBack/archive/1_48187_852672259.arc' Media Recovery Log /bktdb1/OracleBack/archive/1_48187_852672259.arc Errors in file /u01/app/oracle/diag/rdbms/goldprd/GOLDPRD/trace/GOLDPRD_ora_1447.trc: ORA-00317: file type 0 in header is not log file ORA-00334: archived log: '/bktdb1/OracleBack/archive/1_48187_852672259.arc' Errors with log /bktdb1/OracleBack/archive/1_48187_852672259.arc
ARCHDEST location to an ext3 filesystem resolves the issue of generating ORA-19510 - ORA-27045 for Dbvisit archived files in the
ARCHDEST location, Primary Database. This also resulted in ceasing the false timestamp on the system & applying of the archive log files was successful.
Write To CIFS Filesystem on Linux Fails ( ORA-01119, ORA-27040 ) (Doc ID 1417168.1)
Is use of CIFS Protocol for RMAN backups supported? [ID 444809.1]
CIFS is fine for RMAN files: backup pieces, datafile copies but it is NOT certified by Oracle.
Oracle Support: If there are any problems involved in using RMAN and CIFS, then we cannot get the RDBMS development involved.
Is use of CIFS Protocol for RMAN backups supported? (Doc ID 444809.1)
Donna Zehl October 17, 2014 05:29