关于RAC的备份问题，请教大家

显示全部楼层 · 2005-10-30 17:05:33

我在结点1上执行这个：
RMAN> run {
allocate channel c1 type disk connect 'sys/whoami@db001' format "/opt/backup/%d_AL_%T_%u_s%s_p%p" ;
allocate channel c2 type disk connect 'sys/whoami@db002' format "/opt/backup/%d_AL_%T_%u_s%s_p%p" ;
backup filesperset 1
(archivelog all not backed up 1 times ) ;
release channel c1;
release channel c2;
}
2> 3> 4> 5> 6> 7> 8>
allocated channel: c1
channel c1: sid=21 devtype=DISK
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-12001: could not open channel c2
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database using connect string "sys/whoami@db002"
ORA-01017: invalid username/password; logon denied
RMAN>

千问 · 2005-10-30 17:05:33

发现是密码的问题，现在修改密码继续：
RMAN> run {
allocate channel c1 type disk connect 'sys/whoami@db001' ;
allocate channel c2 type disk connect 'sys/whoami@db002' ;
backup filesperset 1 format '/opt/backup/arch%d_%t_%s_%p'
(archivelog all not backed up 1 times ) ;
release channel c1;
release channel c2;
}
2> 3> 4> 5> 6> 7> 8>
allocated channel: c1
channel c1: sid=21 devtype=DISK
allocated channel: c2
channel c2: sid=17 devtype=DISK
Starting backup at 20-JAN-06
current log archived
channel c1: starting archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=7 recid=3 stamp=580230917
channel c1: starting piece 1 at 20-JAN-06
channel c2: starting archive log backupset
channel c2: specifying archive log(s) in backup set
input archive log thread=2 sequence=2 recid=2 stamp=580229682
channel c2: starting piece 1 at 20-JAN-06
released channel: c2
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c2 channel at 01/20/2006 16:58:49
ORA-19504: failed to create file "/opt/backup/archDB00_580235970_15_1"
ORA-27040: skgfrcre: create error, unable to create file
Linux Error: 2: No such file or directory
RMAN>
RMAN>

[oracle@node01 bdump]$ cd /opt/backup
[oracle@node01 backup]$ pwd
/opt/backup
[oracle@node01 backup]$ touch a.txt
[oracle@node01 backup]$ ls
a.txt
[oracle@node01 backup]$ pwd
/opt/backup
[oracle@node01 backup]$
目录确实存在啊？

千问 · 2005-10-30 17:05:33

自己顶一下

千问 · 2005-10-30 17:05:33

kan bu dong

千问 · 2005-10-30 17:05:33

你两个节点/opt/backup
都有这个路径么?
看错误应该是节点2 没有.或者权限.不够.

千问 · 2005-10-30 17:05:33

had you shared the all the arch file to the backup node?

千问 · 2005-10-30 17:05:33

RMAN> run {
allocate channel c1 type disk connect 'sys/whoami@db001' format "/opt/backup/%d_AL_%T_%u_s%s_p%p" ;
allocate channel c2 type disk connect 'sys/whoami@db002' format "/opt/backup/%d_AL_%T_%u_s%s_p%p" ;
backup filesperset 1
(archivelog all not backed up 1 times ) ;
release channel c1;
release channel c2;
}
rac 備份連接一個節點就可以了。

千问 · 2005-10-30 17:05:33

现在分别备份到各自的目录下，等年后磁带机到了正式开始投入使用。

千问 · 2005-10-30 17:05:33

ft, the rman backup file in the server.
you only need backup datafile once, and backup all instances controlfile and archived logfile.

千问 · 2005-10-30 17:05:33

多谢大家，还有个问题：
http://www.itpub.net/482602.html