Fault symptom:
1. log errors of the master database
- Sun Nov 27 12:31:34 2011
- ErrorsInFile/home/Oracle/admin/zjtv/bdump/zjtv1_arc0_803242.trc:
- ORA-16055: FAL request rejected
- ARCH: FAL archive failed. Archiver continuing
- Sun Nov 27 12:31:34 2011
- ORACLE Instance zjtv1-Archival Error. Archiver continuing.
- Sun Nov 27 12:36:34 2011
- ErrorsInFile/home/oracle/admin/zjtv/bdump/zjtv1_arc2_709010.trc:
- ORA-00270: error creating archive log
- Sun Nov 27 12:36:34 2011
- FAL [server, ARC2]: FAL archive failed, see trace file.
2. An error occurs in the slave Database Log, indicating that the archive file does not have permission to be created.
- Sun Nov 27 13:26:59 2011
- ErrorsInFile/home/oracle/admin/standby/udump/standby_rfs_2017640.trc:
- ORA-00270: error creating archive log/archivelog/arch_22493_614088933.arc
- ORA-19504: failedTo CreateFile"/Archivelog/arch_22493_614088933.arc"
- ORA-27040: fileCreateError, unableTo CreateFile
- Ibm aix risc System/6000 Error: 13: Permission denied
Fault analysis:
The archive directory/archivelog has been reorganized from the Database last week to hdisk0 \ hdisk1. The database has been restarted before the fault occurs, and the above error occurs after the restart.
If you suspect that automatic MOUNT is not set, troubleshoot the problem as follows:
1. Check whether the directory exists.
- P560A:/archivelog # df-g
- Filesystem GB blocksFree% Used Iused % Iused MountedOn
- /Dev/hd4 2.00 0.56 73% 2135 2%/
- /Dev/hd2 4.00 1.66 59% 50260 12%/usr
- /Dev/hd9var 1.00 0.27 74% 3219 5%/var
- /Dev/hd3 10.00 5.62 44% 141687 10%/tmp
- /Dev/hd1 1.00 0.54 47% 865 1%/home
- /Proc---/proc
- /Dev/hd10opt 2.00 1.53 24% 7221 2%/opt
- /Dev/weblogiclv 10.00 9.47 6% 47 1%/weblogic
- /Dev/weblogic9lv 10.00 1.85 82% 93440 18%/weblogic9
- /Dev/tsmdb 7.50 2.92 62% 7918 2%/tsmdb
- /Dev/oraclelv 10.00 2.08 80% 27758 6%/home/oracle
- /Dev/oradata_lv 300.00 138.46 54% 94 1%/oradata
- /Dev/fslv00 150.00 26.45 83% 25 1%/backup
- /Archivelog not mounted