recover noredo 不起作用？

显示全部楼层 · 2011-2-18 11:43:34

这是一个2节点RAC系统，其standby也是2个节点，版本为10204
备库被主库拉下的太远,决定使用recover noredo恢复
--standby
SQL> select to_char(current_scn) from v$database;
TO_CHAR(CURRENT_SCN)
----------------------------------------
9058385939647
--primary
SQL> select to_char(current_scn) from v$database;
TO_CHAR(CURRENT_SCN)
----------------------------------------
9096971552573
--primary增量备份
RMAN> run
2> {allocate channel d1 type disk;
3> allocate channel d2 type disk;
allocate channel d3 type disk;
allocate channel d4 type disk;
backup as compressed backupset incremental from SCN 9058385939647 database format '/s105/oradata/STandby_bkp/standby_%d_%T_%U.bak'
include current contrecoverrolfile for standby filesperset=5tag 'FOR STANDBY';
release channel d1;
release channel d2;
release channel d3;
release channel d4;
}
将文件传给standby并catalog，登陆rman执行，输出结果只有这么多，且current_scn并为改变
--standby
RMAN> recover database noredo;
Starting recover at 04-FEB-13
using channel ORA_DISK_1
Finished recover at 04-FEB-13
SQL> select to_char(current_scn) from v$database;
TO_CHAR(CURRENT_SCN)
----------------------------------------
9058385939647
反复检查多次均没有发现问题所在，各位大拿帮帮忙看一下

千问 · 2011-2-18 11:43:34

看下standby的alert信息先。

千问 · 2011-2-18 11:43:34

难道increamental方式仅限于用duplicate命令建standby？