RMAN-03009: failure of backup command on tpc1 channel at

显示全部楼层 · 2009-3-2 15:42:53

RMAN> run {
2> allocate channel tpc1 type disk
3> maxpiecesize=2g;
4> backup full
5> format '/data/backup/intel/fullbak_%s_%p.bak'
6> database
7> include current controlfile;
8> }
allocated channel: tpc1
channel tpc1: sid=91 devtype=DISK
Starting backup at 23-MAY-05
channel tpc1: starting full datafile backupset
channel tpc1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00021 name=/data/tpc/sn_data4.dbf
input datafile fno=00001 name=/u01/product/oradata/tpc/system01.dbf
input datafile fno=00003 name=/u01/product/oradata/tpc/cwmlite01.dbf
input datafile fno=00009 name=/u01/product/oradata/tpc/xdb01.dbf
input datafile fno=00005 name=/u01/product/oradata/tpc/indx01.dbf
input datafile fno=00008 name=/u01/product/oradata/tpc/users01.dbf
input datafile fno=00004 name=/u01/product/oradata/tpc/drsys01.dbf
input datafile fno=00006 name=/u01/product/oradata/tpc/odm01.dbf
input datafile fno=00007 name=/u01/product/oradata/tpc/tools01.dbf
input datafile fno=00022 name=/data/tpc/sn_data5.dbf
input datafile fno=00023 name=/data/tpc/sn_data6.dbf
input datafile fno=00024 name=/data/tpc/sn_data7.dbf
input datafile fno=00025 name=/data/tpc/sn_data8.dbf
input datafile fno=00010 name=/data/tpc/sn_data1.dbf
input datafile fno=00011 name=/data/tpc/sn_idx1.dbf
input datafile fno=00012 name=/data/tpc/track_data1.dbf
input datafile fno=00013 name=/data/tpc/track_idx1.dbf
input datafile fno=00014 name=/data/tpc/log_data1.dbf
input datafile fno=00015 name=/data/tpc/log_idx1.dbf
input datafile fno=00016 name=/data/tpc/sn_data2.dbf
input datafile fno=00017 name=/data/tpc/log_data2.dbf
input datafile fno=00018 name=/data/tpc/sn_data3.dbf
input datafile fno=00019 name=/data/tpc/sn_idx2.dbf
input datafile fno=00020 name=/data/tpc/undotbs02.dbf
input datafile fno=00028 name=/data/tpc/sn_data9.dbf
input datafile fno=00029 name=/data/tpc/track_data2.dbf
input datafile fno=00027 name=/data/tpc/sn_idx3.dbf
input datafile fno=00002 name=/data/tpc/undotbs01.dbf
input datafile fno=00026 name=/data/tpc/perfstat1.dbf
channel tpc1: starting piece 1 at 23-MAY-05
released channel: tpc1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on tpc1 channel at 05/23/2005 13:55:24
ORA-19504: failed to create file "/data/backup/intel/fullbak_1_1.bak"
ORA-27040: skgfrcre: create error, unable to create file

千问 · 2009-3-2 15:42:53

我的磁盘权限都没问题，ＯＲＡＣＬＥ用户可以在／ＤＡＴＡ／下新建文件及文件夹，
但再备份时就是不行，

千问 · 2009-3-2 15:42:53

有没有/data/backup/intel/ 这个目录？

千问 · 2009-3-2 15:42:53

有的
datagard$df -h
Filesystem
SizeUsed Avail Use% Mounted on
/dev/sda5
2.0G270M1.7G15% /
/dev/sda3
190M 16M165M 9% /boot
none
1007M 0 1007M 0% /dev/shm
/dev/sda7
4.0G242M3.6G 7% /tmp
/dev/sda9
119G7.3G105G 7% /u01
/dev/sda8
4.0G2.1G1.7G56% /usr
/dev/sda2
4.0G 33M3.8G 1% /home
/dev/sdb1
404G2.1G381G 1% /data

datagard$ls -la
total 217
drwxr-xr-x 22 root root 4096 May 23 12:50 .
drwxr-xr-x 22 root root 4096 May 23 12:50 ..
-rw-r--r--1 root root
0 May 23 12:50 .autofsck
drwxr-xr-x2 root root 4096 May 19 07:55 bin
drwxr-xr-x4 root root 1024 May 19 07:58 boot
drwxr-xr-x 10 oracle dba
4096 May 23 12:13 data
drwxr-xr-x 21 root root 118784 May 23 12:50 dev
drwxr-xr-x 65 root root 8192 May 23 12:50 etc
drwxr-xr-x4 root root 4096 May 19 08:38 home
drwxr-xr-x2 root root 4096 Jan 252003 initrd
drwxr-xr-x 12 root root 4096 May 20 08:49 lib
drwx------2 root root16384 May 19 15:48 lost+found
drwxr-xr-x2 root root 4096 Sep82003 misc
drwxr-xr-x6 root root 4096 May 19 07:59 mnt
drwxr-xr-x2 root root 4096 Jan 252003 opt
dr-xr-xr-x 76 root root
0 May 23 12:49 proc
drwxr-x---4 root root 4096 May 23 12:12 root
drwxr-xr-x2 root root 8192 May 19 07:55 sbin
drwxr-xr-x3 root root 4096 May 19 07:54 tftpboot
drwxrwxrwt 11 root root 4096 May 23 12:50 tmp
drwxr-xr-x9 oracle dba
4096 May 23 12:59 u01
drwxr-xr-x 16 root root 4096 May 19 07:50 usr
drwxr-xr-x 25 root root 4096 May 19 07:59 var
datagard$

千问 · 2009-3-2 15:42:53

上次我建表空间的时候也报了个相类似的错误，
1 create tablespace rman_data
2 datafile '/data/datagd/rman_data01.dbf'
3 size 2025M
4* extent management local uniform size 10M
SQL> /
create tablespace rman_data
*
ERROR at line 1:
ORA-19502: write error on file "/data/datagd/rman_data01.dbf", blockno 210561
(blocksize=8192)
ORA-27072: skgfdisp: I/O error
Linux Error: 2: No such file or directory
Additional information: 210560
难道是磁盘有问题吗？

千问 · 2009-3-2 15:42:53

不可能啊！
只备份控制文件呢？

千问 · 2009-3-2 15:42:53

RMAN> run {
2> allocate channel tpc1 type disk
3> maxpiecesize=2g;
4> backup full
5> format '/data/backup/intel/fullbak_%s_%p.bak'
6> database
7> include current controlfile;
8> }
应该是：
5> format '/data/backup/intel/fullbak_%s_%p'
不要写.BAK

千问 · 2009-3-2 15:42:53

建议不要在生产库上面直接备,先测试好,再用免得影响数据库.备份的数据也不全.

千问 · 2009-3-2 15:42:53

不些．ＢＡＫ结果是一样的．
只备份控制文件也一样：
RMAN> run {
2> allocate channel tpc1 type disk;
3> backup
4> format '/data/backup/tpc/control_%s_%p'
5> current controlfile;
6> }
allocated channel: tpc1
channel tpc1: sid=33 devtype=DISK
Starting backup at 23-MAY-05
channel tpc1: starting full datafile backupset
channel tpc1: specifying datafile(s) in backupset
including current controlfile in backupset
channel tpc1: starting piece 1 at 23-MAY-05
released channel: tpc1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on tpc1 channel at 05/23/2005 14:28:32
ORA-19504: failed to create file "/data/backup/tpc/control_3_1"
ORA-27040: skgfrcre: create error, unable to create file
Linux Error: 2: No such file or directory
晕倒

千问 · 2009-3-2 15:42:53

最初由 anthonywu 发布
[B]不些．ＢＡＫ结果是一样的．
只备份控制文件也一样：
RMAN> run {
2> allocate channel tpc1 type disk;
3> backup
4> format '/data/backup/tpc/control_%s_%p'
5> current controlfile;
6> }
allocated channel: tpc1
channel tpc1: sid=33 devtype=DISK
Starting backup at 23-MAY-05
channel tpc1: starting full datafile backupset
channel tpc1: specifying datafile(s) in backupset
including current controlfile in backupset
channel tpc1: starting piece 1 at 23-MAY-05
released channel: tpc1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on tpc1 channel at 05/23/2005 14:28:32
ORA-19504: failed to create file "/data/backup/tpc/control_3_1"
ORA-27040: skgfrcre: create error, unable to create file
Linux Error: 2: No such file or directory
晕倒 [/B]
目录不对！