oracle rman ora19602,学习笔记:OracleRMAN备份入门 将RMAN备份数据放到nfs远程文件系统中...

天萃荷净

rman通过nfs备份，记录一篇关于使用RMAN备份软件，将RMAN的备份结果集存放到远程的NFS文件系统中

1.RMAN挂载至nfs文件系统

[root@oracleplus tmp]# mount -t nfs 192.168.1.90:/tmp/nfs /nfs

[root@oracleplus 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@oracleplus 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

2.重新挂载nfs文件系统

[root@oracleplus ~]# umount /nfs

[root@oracleplus 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@oracleplus ~]$ 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@oracleplus rman]# pwd

/tmp/nfs/rman

[root@oracleplus 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]

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之学习笔记:OracleRMAN备份入门 将RMAN备份数据放到nfs远程文件系统中