请教:假设rman 了好几个备份集, restore还原时候怎么指定还原某个备份集?

假设周一,周二,周三,每天都使用rman ,

backup database format '/data/ora_bak/oradb_%Y_%M_%D_%U.bak'; 

那我使用recover database 还原数据库的时候,默认的是还原哪一次的数据?怎么指定还原某一次的数据呢? 

可以尝试下面命令。

--列出备份
RMAN> LIST BACKUPSET SUMMARY;

List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Comp Tag
--- -- -- - ----------- --------------- ------- ------- ---- ---
1   B  F  A DISK        28-MAY-07       1       1       NO   TAG20070528T132432
2   B  F  A DISK        29-MAY-07       1       1       NO   TAG20070529T132433
3   B  F  A DISK        30-MAY-07       1       1       NO   TAG20070530T132434

--恢复的时候,指定SCN或者时间,来选择对应的备份集
RUN
{ 
  SET UNTIL SCN 1000;    
  RESTORE DATABASE;
  RECOVER DATABASE;
}

RUN
{
  SET UNTIL TIME 'Oct 8 2007 07:55:00'; 
  RESTORE CONTROLFILE;
  # without recovery catalog, use RESTORE CONTROLFILE FROM AUTOBACKUP
  ALTER DATABASE MOUNT; 
  RESTORE DATABASE;
  RECOVER DATABASE;
}
ALTER DATABASE OPEN RESETLOGS;