当前位置: 代码迷 >> Oracle管理 >> Linux 上oracle备份失败?
  详细解决方案

Linux 上oracle备份失败?

热度:53   发布时间:2016-04-24 05:10:27.0
Linux 下oracle备份失败????
准备在 /u01/app/oracle/RmanBackup 路径下执行备份脚本 BackupFull.sh
 RmanBackup执行权限:
ls-l:
drwxrwxrwx 2 oracle oinstall 4096 Jul 12 13:12 RmanBackup
 
在执行时:[oracle@richard RmanBackup]$ ./BackupFull.sh
 报错:
 [oracle@richard RmanBackup]$ ./BackupFull.sh
 Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 12 13:12:58 2012
 Copyright (c) 1982, 2005, Oracle. All rights reserved.
 connected to target database: OMS (DBID=1473522592)
 RMAN>
 RMAN> 2> 3> 4> 5> 6> 7>
 using target database control file instead of recovery catalog
 allocated channel: c1
 channel c1: sid=861 devtype=DISK
 Starting backup at 12-JUL-12
 channel c1: starting incremental level 0 datafile backupset
 channel c1: specifying datafile(s) in backupset
 input datafile fno=00001 name=/u01/app/oracle/oradata/oms/system01.dbf
 input datafile fno=00003 name=/u01/app/oracle/oradata/oms/sysaux01.dbf
 input datafile fno=00002 name=/u01/app/oracle/oradata/oms/undotbs01.dbf
 input datafile fno=00004 name=/u01/app/oracle/oradata/oms/users01.dbf
 input datafile fno=00005 name=/u01/app/oracle/oradata/oms/bank_data01.dbf
 channel c1: starting piece 1 at 12-JUL-12
 released channel: c1
[color=#000080] RMAN-00571: ===========================================================
 RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 RMAN-00571: ===========================================================
 RMAN-03009: failure of backup command on c1 channel at 07/12/2012 13:13:01
 ORA-19504: failed to create file "/u01/app/oracle/product/10.2.0/db_1/dbs/u01/app/oracle/db0_OMS_20120712_32"
 ORA-27040: file create error, unable to create file
 Linux Error: 2: No such file or directory[/color]
 
请问是执行权限问题还是什么问题?
 =========================================================================================
 在 RMAN> backup database format='u01/app/oracle/RmanBackup/bakTest.bak'; 这样尝试时还是报类似错误:
 RMAN> backup database format='u01/app/oracle/RmanBackup/bakTest.bak';
 Starting backup at 12-JUL-12
 using target database control file instead of recovery catalog
 allocated channel: ORA_DISK_1
 channel ORA_DISK_1: sid=869 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/app/oracle/oradata/oms/system01.dbf
 input datafile fno=00003 name=/u01/app/oracle/oradata/oms/sysaux01.dbf
 input datafile fno=00002 name=/u01/app/oracle/oradata/oms/undotbs01.dbf
 input datafile fno=00004 name=/u01/app/oracle/oradata/oms/users01.dbf
 input datafile fno=00005 name=/u01/app/oracle/oradata/oms/bank_data01.dbf
 channel ORA_DISK_1: starting piece 1 at 12-JUL-12
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/12/2012 13:19:28
ORA-19504: failed to create file "/u01/app/oracle/product/10.2.0/db_1/dbs/u01/app/oracle/RmanBackup/bakTest.bak"
ORA-27040: file create error, unable to create file
Linux Error: 2: No such file or directory
 
===============================================================================================
附BackupFull.sh:[size=12px][/size]
 
#script:BackupFull.sh
 #creater:Richard
 #date:2012/7/30
 #desc:backup all database datafile in archive with rman
  相关解决方案