我的oracle数据库是通过两个策略来备份的,一个只备数据库文件和控制文件,另一个只备归档日志
我在恢复的时候:控制文件和数据库文件都正常恢复。
但通过: recover database using backup controlfile until cancel
auto
RMAN> run {
allocate channel ch00 type 'SBT_TAPE';
send 'NB_ORA_SERV=nbu5220,NB_ORA_CLIENT=HP41-VIP';
restore archivelog from sequence 567097 thread 2;
RELEASE CHANNEL ch00;
}
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/16/2014 15:08:36
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of log thread 2 seq 575079 lowscn 13710723489121 found to restore
RMAN-06025: no backup of log thread 2 seq 575078 lowscn 13710723409173 found to restore
RMAN-06025: no backup of log thread 2 seq 575077 lowscn 13710723375277 found to restore
RMAN-06025: no backup of log thread 2 seq 575076 lowscn 13710723353961 found to restore
RMAN-06025: no backup of log thread 2 seq 575075 lowscn 13710713858023 found to restore
请教一下这个该怎么恢复呢?
之前在恢复其他数据库的时候,归档和数据库都是一个策略来备份的,用上面的方法都恢复成功了,
但这个数据库归档是单独一个策略来备的,用同样的方法就过不去了。不知道是那里出错了?单独备归档不能通过这种方法来恢复吗?
呵呵,谢谢啊。不过后来我恢复成功了。
我在恢复脚本中加了时间点”set until time "to_date('01-18-2014:12:00:00','MM-DD-YYYY:HH24:MI:SS')";“
在恢复数据库的时候归档就熊找到了。不知道为什么要加时间点才能找到,不加RMAN自己就找不到。