假设周一,周二,周三,每天都使用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;