题记:本次是由于数据库备份文件太大了,于是想将备份文件存放在云存储中,这里是将云存储以NFS方式挂载到系统中。
www.linuxidc.com:/> mount 192.168.121.24:/mnt/ws1_fs/db_backup /backup
mount: 1831-008 giving up on:
192.168.121.24:/mnt/ws1_fs/db_backup
vmount: Operation not permitted.
www.linuxidc.com:/> showmount -e 192.168.121.24
export list for 192.168.121.23:
/mnt/ws1_fs 192.168.120.*
/mnt/ws1_fs/db_backup 192.168.128.*
www.linuxidc.com:/>nfso -o nfs_use_reserved_ports=1 --> 修改这个后正常
Setting nfs_use_reserved_ports to 1
www.linuxidc.com:/> mount 192.168.121.24:/mnt/ws1_fs/db_backup /backup
www.linuxidc.com:/> df -k
Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
/dev/hd4 2097152 2039740 3% 3427 1% /
/dev/hd2 5242880 1918340 64% 90779 18% /usr
/dev/hd9var 3145728 555992 83% 851 1% /var
/dev/hd3 2097152 1968392 7% 449 1% /tmp
/dev/fwdump 1048576 1048088 1% 4 1% /var/adm/ras/platform
/dev/hd1 20971520 12662908 40% 28343 1% /home
/dev/hd10opt 2097152 2054028 3% 707 1% /opt
/dev/Oraclelv 20971520 8489068 60% 19707 2% /oracle
/dev/lvbillingcdr 196608000 160211388 19% 426076 2% /billingcdr
/dev/lvbillingarch 225443840 199815628 12% 115 1% /billingcdr/archivelog
/dev/lvbillingbak 435159040 64928800 86% 12 1% /billingcdr/billingbackup
192.168.121.24:/mnt/ws1_fs/db_backup 103813753376 47553553312 55% 144954938 99% /backup
www.linuxidc.com:/> cd /backup
www.linuxidc.com:/backup> ls -l
total 104
drwxrwxr-x 2 oracle dba 4096 Dec 05 15:52 bk
www.linuxidc.com:/backup> su - oracle
$ cd /backup/bk
$ mkdir abcd
mkdir: 0653-358 Cannot create abcd.
abcd: There is an input or output error.
www.linuxidc.com:/tt01> cat /etc/passwd | grep oracle
oracle:!:123:1002::/oracle:/usr/bin/ksh
www.linuxidc.com:/tt01> id oracle
uid=123(oracle) gid=1002(dba) groups=1(staff),1003(hagSUSEr),1001(oinstall)
然后在nfs server上创建一oracle用户后,问题解决。
在AIX上挂载了云存储(以NFS方式挂载),目的是用于数据库的RMAN备份,但是在做rman备份测试时,出现如下错误:测试脚本:
run {
allocate channel t1 type disk;
backup
skip inaccessible
format '/backup/bill_db/arclogback_%s_%p_%t_%d'
(archivelog all
);
release CHANNEL t1 ;
}
报错:
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 12/06/2011 09:40:39
ORA-19504: failed to create file "/backup/bill_db/arclogback_316_1_20111206_769167624.bk"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
IBM AIX RISC System/6000 Error: 13: Permission denied
Additional information: 4
查了下metalink,得到如下的解决方法:
出现这个错误有三种方法解决:
(1)set event 10298 需要重启数据库生效
alter system set event='10298 trace name context forever,level 32' scope=spfile;
(2)mount时指定一些参数:
mount -o rw,bg,hard,rsize=32768,wsize=32768,vers=3,cio,intr,timeo=600,proto=tcp 192.168.121.24:/mnt/ws1_fs/db_backup /backup
(3)打补丁:5146667,这种方法要将数据库关闭,操作比较比较麻烦。
上面的三种方法中,使用了第2种,但是仍然是报同样的错误,问题没有解决!
由于是生产库,第1、3种方法没有试过。
最后还是从本地的存储扩大了LUN,使得数据库备份目录有足够的空间使用。