rman技术速查手册 - 数据库编程

RESTORE DATABASE;
RECOVER DATABASE; # recovers through log 119
sql'ALTER DATABASE OPEN RESESTLOGS';
RELEASE CHANNEL 1;
}
C、基于SCN的不完全恢复：
RUN {
ALLOCATE CHANNEL c1 TYPE DISK;
SET UNTIL SCN=100145;
RESTORE DATABASE;
RECOVER DATABASE;
sql'ALTER DATABASE OPEN RESESTLOGS';
RELEASE CHANNEL 1;
}
D、基于cancel的不完全恢复：
RUN {
ALLOCATE CHANNEL c1 TYPE DISK;
RESTORE DATABASE;
RECOVER DATABASE UNTIL CANCEL;
SQL'ALTER DATABASE OPEN RESESTLOGS';
RELEASE CHANNEL 1;
}
三、维护RMAN RMAN的维护主要分为几个方面
1、查看RMAN的信息
检查现有备份
RMAN>list backup

列出过期备份
RMAN>report obsolete
删除过期的备份
RMAN>allocate channel for maintenance type disk;
RMAN>change backupset id delete;
RMAN>release channel;
删除所有过期的备份
RMAN>delete obsolete;

2、同步或重置RMAN

如果目标数据库物理对象发生了变化，如添加了一个数据文件，需要用如下命令同步：
RMAN>resync catalog;
如果目标数据库reset了数据库，需要用如下命令同步
RMAN>reset database;

当手工删除了数据库的归档文件后，要执行以下脚本同步
RMAN>allocate channel for maintenance type disk;
RMAN> change archivelog all crosscheck;
RMAN>release channel;

当手工删除了数据库的RMAN备份后，要执行以下脚本来同步
RMAN>allocate channel for maintenance type disk;
RMAN>crosscheck backup;
RMAN>delete expired backup;
RMAN>release channel;

rman技术速查手册(二)