RMAN備份資料到NFS提示ORA-27054
在備份中發現以下錯誤:
Starting backup at 30-AUG-07
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=43 recid=46 stamp=631975231
input archive log thread=1 sequence=44 recid=45 stamp=631975223
channel ORA_DISK_1: starting piece 1 at 30-AUG-07
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 08/30/2007 14:02:03
ORA-19504: failed to create file "/rman/ibudb/arch_IBUDB_31_631980121.rman"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
在metalink上找到一個Doc,Note:424785.1。這個問題在10.2的版本中比較普遍。可透過以下三種方式進行解決:
1、設定事件10298 level 32
alter system set event='10298 trace name context forever,level 32' scope=spfile;
重新啟動資料庫後生效.
2、打補丁:5146667
3、mount NFS目錄時加引數
rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0
以上引數不是對每個系統都通用。
我使用的是red linux系統,透過修改mount引數後生效
[oracle@db2 dba]$ cat /etc/redhat-release
Red Hat Enterprise Linux AS release 3 (Taroon Update 5)
[root@db2 oracle]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/hdb1 7.7G 6.5G 817M 90% /
none 250M 0 250M 0% /dev/shm
/dev/hdb5 9.7G 6.9G 2.3G 76% /u01
/dev/hdb2 20G 5.0G 14G 27% /u02
192.168.203.199:/home/tang/ibudbbackup
49G 26G 21G 56% /rman
[root@db2 oracle]# umount -f /rman
[root@db2 oracle]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/hdb1 7.7G 6.5G 817M 90% /
none 250M 0 250M 0% /dev/shm
/dev/hdb5 9.7G 6.9G 2.3G 76% /u01
/dev/hdb2 20G 5.0G 14G 27% /u02
[root@db2 oracle]# mount -t nfs -o rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0 192.168.203.199:/home/tang/ibudbbackup /rman
[root@db2 oracle]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/hdb1 7.7G 6.5G 817M 90% /
none 250M 0 250M 0% /dev/shm
/dev/hdb5 9.7G 6.9G 2.3G 76% /u01
/dev/hdb2 20G 5.0G 14G 27% /u02
192.168.203.199:/home/tang/ibudbbackup
49G 26G 21G 56% /rman
啟動rman測試
[oracle@db2 dba]$ sh db_full_database.sh
..............
channel ORA_DISK_1: starting piece 1 at 30-AUG-07
channel ORA_DISK_1: finished piece 1 at 30-AUG-07
piece handle=/rman/ibudb/full_IBUDB_34_631981475.rman tag=TAG20070830T142435 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:19:38
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 30-AUG-07
channel ORA_DISK_1: finished piece 1 at 30-AUG-07
piece handle=/rman/ibudb/full_IBUDB_35_631982654.rman tag=TAG20070830T142435 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:16
Finished backup at 30-AUG-07
Starting backup at 30-AUG-07
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=4 recid=50 stamp=631982672
channel ORA_DISK_1: starting piece 1 at 30-AUG-07
channel ORA_DISK_1: finished piece 1 at 30-AUG-07
piece handle=/rman/ibudb/arch_IBUDB_36_631982674.rman tag=TAG20070830T144433 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u02/oradata/IBUDB/archivelogIBUDB_1_4_631976236.arc recid=50 stamp=631982672
Finished backup at 30-AUG-07
RMAN> exit
Recovery Manager complete.
備份成功.
==================================================
Subject: | ORA-27054 ERRORS WHEN RUNNING RMAN WITH NFS | |||
Doc ID: | Note:387700.1 | Type: | PROBLEM | |
Last Revision Date: | 12-DEC-2007 | Status: | MODERATED |
In this Document
Symptoms
Cause
Solution
References
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review. |
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1
This problem can occur on any platform.
Symptoms
ORA-27054 ERRORS WHEN RUNNING RMAN WITH NFS
Starting Control File and SPFILE Autobackup at 01-AUG-06
RMAN-00571: ===========================================================
RMAN-00569: ERROR MESSAGE STACK FOLLOWS
===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_2
channel at 08/01/2006 16:43:49
ORA-19504: failed to create file
"/u60/rman/nitfq/cntrl/nitfq_c-4256538111-20060801-02"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options Additional information: 2
Cause
From Oracle 10G R2 , Oracle checks the options with which a NFS mount is mounted on the filesystem. and this
is done to ensure that no corruption of the database can happen as incorrectly mounted NFS volumes can result in data corruption.
There are no single set of NFS mount options that work across all Oracle platforms
Please ensure that you have the proper mount options specified by the NAS vendor /Vendor user guide
The exact checks used for an NFS mounted disk vary between platforms but in general the basic checks will include
checking that:
a) The mount table (eg; /etc/mnttab) can be read to check the mount options
b) The NFS mount is mounted with the "hard" option
c) The mount options include rsize>=32768 and wsize>=32768
d) For RAC environments, where NFS disks are supported, the "noac" mount option is used.
Please refer the section -- NFS Mount Options in Oracle® Database Installation Guide10g Release 2 (10.2)
If you have ensured that the mount options are appropriate and still getting the errors then you are encountering symptoms as in Bug 5146667 Fixed In Ver: 11.0. 0.0
And this is found reproducable on Solaris and AIX
.
Solution
To implement the solution, please execute the following steps:
From the erorrs that we see from the RMAN stack this looks like Bug 5146667
This behaviour has been observed on Solaris and AIX Platform.
WORKAROUND:
As suggested in the bug the workaround recommended is to use the Event 10298.
1) set the Event 10298 in the init file
event="10298 trace name context forever, level 32"
if you are using the spfile then the following can be done
SQL> alter system set event='10298 trace name context forever, level 32'scope= spfile ;
Once you set the above parameter restart the instance check as follows
SQL> select name, value from v$parameter where name = 'event';
NAME VALUE
---------- ------------------------------------------------------------
Event 10298 trace name context forever, level 32
1 row selected.
Then try the backups again
2) PATCH
Check if a one off patch for 10.2.0.1 for your platform is available
Please follow next steps to download and test it :
1. Login to Metalink
2. Go to Patches and Updates -> Simple Search
3. Enter patch number 5146667 and platform you are on ( your version of OS )
4. Download the patch
5. Read the README file for installation instructions and test it to see if it fixes your problem
Once the patch is shown as applied - you can do away with the event
References
Bug 5146667 - ORA-27054 ERRORS WHEN RUNNING RMAN WITH NFS
Errors
failure of %s command on %s channel at %s failed to create file %s NFS file system where the file is created or resides is not mounted with correct options"
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-998273/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- EXPDP備份到NFS檔案系統 ORA-27054NFS
- linux 配置nfs(rman 備份)LinuxNFS
- NFS儲存rman備份時的mount選項NFS
- RAC環境歸檔NFS掛載方式RMAN備份錯誤NFS
- Elasticsearch 使用 NFS 進行資料備份ElasticsearchNFS
- ORA-27054: NFS 問題處理NFS
- 使用RMAN備份資料庫資料庫
- Backup And Recovery User's Guide-備份RMAN備份-使用RMAN備份備份集GUIIDE
- 【RMAN】使用增量備份更新資料庫備份映象資料庫
- RMAN說,我能備份(9)--RMAN增量備份與備份保留策略
- Backup And Recovery User's Guide-備份資料庫-RMAN備份概覽-RMAN備份的目的GUIIDE資料庫
- 【RMAN】RMAN備份至ASMASM
- RMAN說,我能備份(14)--實戰RMAN備份
- 【原】Oracle學習系列—資料庫備份—RMAN備份Oracle資料庫
- Backup And Recovery User's Guide-備份資料庫-RMAN備份概覽-為RMAN備份指定TAGGUIIDE資料庫
- rman 備份策略
- RMAN備份原理
- Backup And Recovery User's Guide-備份RMAN備份-用RMAN備份映象拷貝備份GUIIDE
- 解決oracle rman報ORA-27054 NFS file system where the file is created or resides is not mounted with corOracleNFSIDE
- RMAN說,我能備份(4)--RMAN備份資料檔案和控制檔案
- linux:ora-27054:nfs file system errorLinuxNFSError
- 利用RMAN備份重建資料庫資料庫
- RMAN 只備份當前資料?
- RMAN說,我能備份(3)--RMAN全庫備份和表空間備份
- Backup And Recovery User's Guide-備份資料庫-RMAN備份概覽-為RMAN備份指定格式GUIIDE資料庫
- 【RMAN】RMAN的備份保留策略
- rman備份和增量備份指令碼指令碼
- RMAN備份恢復典型案例——RMAN備份&系統變慢
- RMAN說,我能備份(5)--RMAN備份歸檔檔案
- 使用RMAN備份RAC本地目錄中不是用NFS的歸檔日誌NFS
- Backup And Recovery User's Guide-RMAN備份概念-RMAN備份的多個拷貝-備份的備份GUIIDE
- oracle之 資料泵dump檔案存放nfs報ORA-27054OracleNFS
- RMAN的備份原理
- rman 備份指令碼指令碼
- rman備份型別型別
- RMAN 備份詳解
- RMAN備份詳解
- rman備份學習