rac archivelog backup的问题?

fish617

rac架构,两个instance都均产生归档日志,用Veritas NBU将归档日志备份到tape library.
由于两台机器均买了client和agent for oracle,我想制定两个备份策略把两边的归档日志分开备份,这样恢复时能找到所有的日志吗?应该没有问题吧?

不用下面的:
run{
configure channel c1 device type 'SBT_TAPE' connect 'sys/oracle@ora921';
configure channel c2 device type 'SBT_TAPE' connect 'sys/oracle@ora922';
backup archivelog all skip inaccessible delete input;
}

fish617

顶一下,各位帮帮忙啊!

blue_stone

你的归档日志放在什么地方?
nbu的手册和rac administrators' guide 都有这方面的介绍

fish617

我A机在/arch_dest1
B机 /arch_dest2,我制定策略时分开备份这两部分日志了,怕恢复数据库时(日志部分)出问题!
脚本中正好ORACLE_SID=***,我两边分别指向了两个实例名

blue_stone

备份a机的通道只备份名字中带有dest1字段的归档
备份b机的通道只备份名字中带有dest2字段的归档
可再rman命令backup中加参数like 指定,例如
BACKUP
    FORMAT 'arch-s%s-p%p-t%t'
    ARCHIVELOG like '%dest1%'
    DELETE INPUT;

fish617

那是两个放归档日志的目录,日志归档格式是一样的
log_archive_format                   string      ora92%t_%s.log
我现在就是想知道,分开备份两边的日志,恢复时有没有问题?
比如:Thread1的归档日志,我凌晨3点备份到磁带库!
       Thread2的归档日志,我5点备份到磁带库,恢复时,oracle会不会同时去找这两部分日志,以保证数据库完整性!

blue_stone

%t是不一样的,
将归档日志恢复到进行恢复操作的机器上, oracle会自动去找的.

fish617

多谢楼上!

fish617

怎么我用这种方式来备份归档日志不行啊?  RAC方式
RMAN> run{
2> CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' CONNECT  'sys/oracle@ora921';
3> CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' CONNECT 'sys/oracle@ora922';
4> backup archivelog all skip inaccessible;
5> }

starting full resync of recovery catalog
full resync complete
old RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' CONNECT  'sys/oracle@ora921';
new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' CONNECT  'sys/oracle@ora921';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

old RMAN configuration parameters:
CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' CONNECT  'sys/oracle@ora922';
new RMAN configuration parameters:
CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' CONNECT  'sys/oracle@ora922';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

Starting backup at 05-SEP-06
current log archived
configuration for SBT_TAPE channel 2 is ignored
configuration for DISK channel 2 is ignored
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 09/05/2006 14:06:13
RMAN-12001: could not open channel ORA_DISK_1
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database using connect string "sys/oracle@ora921"
ORA-01017: invalid username/password; logon denied

blue_stone

密码错误?