Maison > base de données > tutoriel mysql > Oracle 使用nfs挂载的目录不能进行归档

Oracle 使用nfs挂载的目录不能进行归档

WBOY
Libérer: 2016-06-07 17:28:13
original
852 Les gens l'ont consulté

在做实验时将Oracle的归档目录放在nfs服务器上,启动数据库就会死掉,也不能进行归档。

在做实验时将Oracle的归档目录放在nfs服务器上,,启动数据库就会死掉,也不能进行归档。
 
在报警日志中发现
 
WARNING:NFS file system /mnt mounted with incorrect options
WARNING:Expected NFS mount options: rsize>=16384,wsize>=16384,hard,noac/actimeo=0
Wed Apr 17 06:28:15 2013
Errors in file /u01/oracle/admin/sid31/bdump/sid312_arc1_21845.trc:
ORA-19504: failed to create file "/arc/arc1/2_13_812841120.arc"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
ARC1: Error 19504 Creating archive log file to '/arc/arc1/2_13_812841120.arc'
ARC1: Failed to archive thread 2 sequence 13 (19504)
ARCH: Archival stopped, error occurred. Will continue retrying
Wed Apr 17 06:28:18 2013
ORACLE Instance sid312 - Archival Error
Wed Apr 17 06:28:18 2013
ORA-16038: log 3 sequence# 13 cannot be archived
 
重新修改挂载方式
 
mount 192.168.1.31:/arc /mnt  -o rsize=65534,wsize=65534,hard,noac,actimeo=0 /mnt
 
在修改后重新启动数据库发现还是起不了
 
报错内容:
 
Errors in file /u01/oracle/admin/sid31/udump/sid312_ora_27149.trc:
ORA-19504: failed to create file "/arc/arc1/2_13_812841120.arc"
ORA-27086: unable to lock file - already in use
Linux Error: 37: No locks available
Additional information: 10
Wed Apr 17 06:32:15 2013
ARCH: Error 19504 Creating archive log file to '/arc/arc1/2_13_812841120.arc'
ARCH: Failed to archive thread 2 sequence 13 (19504)
 
这个再加一个nolock选项就可以了
 
mount 192.168.1.31:/arc /mnt  -o rsize=65534,wsize=65534,hard,noac,actimeo=0,nolock /mnt

linux

source:php.cn
Déclaration de ce site Web
Le contenu de cet article est volontairement contribué par les internautes et les droits d'auteur appartiennent à l'auteur original. Ce site n'assume aucune responsabilité légale correspondante. Si vous trouvez un contenu suspecté de plagiat ou de contrefaçon, veuillez contacter admin@php.cn
Tutoriels populaires
Plus>
Derniers téléchargements
Plus>
effets Web
Code source du site Web
Matériel du site Web
Modèle frontal