rman 恢复机制与恢复测试

最近设置了
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;
发现oracle会删除昨天的文件，有点不解。
后来考虑到有可能是恢复时不需要某些文件，所以才被标记为过期，因此做了个简单的实验

1. 将三天的备份集打包zip，传输并解压至恢复用机器上，目录为/u02/backup。授权
2. 进行不完全恢复，备份命令最后附录
3. 发现不需要被删除的文件，数据库正常恢复成功

说明rman会检测文件的重复，会将文件删除，只要不是恢复需要的文件

附：操作记录
startup nomount pfile='/u02/backup/ism.ora';
restore controlfile from '/u02/backup/ISM_20150807_320_1_CONTROL';
alter database mount;
column c1 format a5
column c2 format a40
select trim(file#) c1,name c2 from v$datafile;
select trim(file#) c1,name c2 from v$tempfile;
catalog start with '/u02/backup';
run
{
set newname for datafile 1 to"/u02/oracle/app/oradata/ism/SYSTEM.DBF";
set newname for datafile 2 to"/u02/oracle/app/oradata/ism/SYSAUX.DBF";
set newname for datafile 3 to"/u02/oracle/app/oradata/ism/UNDOTBS1.DBF";
set newname for datafile 4 to"/u02/oracle/app/oradata/ism/USERS.DBF";
set newname for datafile 5 to"/u02/oracle/app/oradata/ism/NNC_DATA01.DBF";
set newname for datafile 6 to"/u02/oracle/app/oradata/ism/NNC_DATA02.DBF";
set newname for datafile 7 to"/u02/oracle/app/oradata/ism/NNC_DATA03.DBF";
set newname for datafile 8 to"/u02/oracle/app/oradata/ism/NNC_INDEX01.DBF";
set newname for datafile 9 to"/u02/oracle/app/oradata/ism/NNC_INDEX02.DBF";
set newname for datafile 10 to"/u02/oracle/app/oradata/ism/NNC_INDEX03.DBF";
set newname for tempfile 1 to"/u02/oracle/app/oradata/ism/TEMP.DBF";
restore database;
switch datafile all;
}
shutdown immediate
startup pfile='/u02/backup/ism.ora' upgrade ;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21302630/viewspace-1764525/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21302630/viewspace-1764525/