联系:手机/微信(+86 17813235971) QQ(107644445)
标题:rman通过nfs备份
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
挂载nfs
[root@xifenfei tmp]# mount -t nfs 192.168.1.90:/tmp/nfs /nfs [root@xifenfei tmp]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda1 18G 12G 5.2G 70% / tmpfs 737M 0 737M 0% /dev/shm /dev/sdb1 20G 7.8G 11G 42% /u01/oracle/oradata 192.168.1.90:/tmp/nfs 18G 13G 3.9G 77% /nfs
rman备份
[oracle@xifenfei nfs]$ rman target / Recovery Manager: Release 10.2.0.1.0 - Production on Wed May 30 16:31:40 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: XFF (DBID=3426707456) RMAN> backup datafile 1 format '/nfs/rman/system01_%U'; Starting backup at 3-JUN-12 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=146 devtype=DISK channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/30/2012 16:32:17 ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode continuing other job steps, job failed will not be re-run 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 3-JUN-12 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/30/2012 16:32:20 ORA-19504: failed to create file "/nfs/rman/system01_02nc9rgh_1_1" ORA-27054: NFS file system where the file is created or resides is not mounted with correct options Additional information: 3
重新挂载nfs
[root@xifenfei ~]# umount /nfs [root@xifenfei tmp]# mount -t nfs -o rw,bg,hard,rsize=32768,wsize=32768, >vers=3,nointr,timeo=600,tcp 192.168.1.90:/tmp/nfs /nfs
rman重新备份
[oracle@xifenfei ~]$ rman target / Recovery Manager: Release 10.2.0.1.0 - Production on Wed May 30 16:38:14 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: XFF (DBID=3426707456) RMAN> backup datafile 1 format '/nfs/rman/system01_%U'; Starting backup at 3-JUN-12 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=143 devtype=DISK channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=00001 name=/u01/oracle/oradata/XFF/system01.dbf channel ORA_DISK_1: starting piece 1 at 3-JUN-12 channel ORA_DISK_1: finished piece 1 at 3-JUN-12 piece handle=/nfs/rman/system01_07nc9rrv_1_1 tag=TAG20120530T163823 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:02:15 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 3-JUN-12 channel ORA_DISK_1: finished piece 1 at 3-JUN-12 piece handle=/nfs/rman/system01_08nc9s07_1_1 tag=TAG20120530T163823 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 Finished backup at 3-JUN-12
查看nfs源端文件
[root@xifenfei rman]# pwd /tmp/nfs/rman [root@xifenfei rman]# ls -l total 378300 -rw-r----- 1 54321 54321 379846656 Jun 3 13:45 system01_07nc9rrv_1_1 -rw-r----- 1 54321 54321 7143424 Jun 3 13:45 system01_08nc9s07_1_1
要点说明
Mount Options for Oracle files when used with NFS on NAS devices [ID 359515.1]
Mount Options for Oracle files when used with NFS on NAS devices