常规数据库恢复,NBU备份,7月1号(周六)全备,每天增量备份。使用的是控制文件,所有目录和正式环境建的一样。
启动数据到mount状态,恢复DB
RMAN> run
2> {
3> allocate channel ch00 type 'SBT_TAPE';
4> send 'NB_ORA_SERV=s1abck03, NB_ORA_CLIENT=nbupmsd02';
5> restore database;
6> recover database;
7> release channel ch00;
8> }
漫长的等待
Finished restore at 04-JUL-17
Starting recover at 04-JUL-17
starting media recovery
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/04/2017 19:01:09
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 30543 scn 169333080018 found to restore
查看原库alert log,logseq 30543是7.4号做的增量备份,在7.1号全备时间点左右的logseq 30398
RMAN> run{
2> ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
3> send 'NB_ORA_SERV=s1abck03, NB_ORA_CLIENT=nbupmsd02';
4> restore archivelog from logseq 30398;
5> release channel ch00;
6> }
allocated channel: ch00
channel ch00: sid=16 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.1 (2011020316)
sent command to channel: ch00
Starting restore at 05-JUL-17
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/05/2017 09:51:16
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of log thread 1 seq 30543 scn 169333080018 found to restore
小白初手,请教下该问题。谢谢。