Oracle 基于RMAN的数据文件恢复

Rman数据备份脚本RUN { CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:/app/Administrator/backup/%F'; ALLOCATE CHANNEL CH1 DEVICE TYPE DISK FORMAT 'D:/app/Administrator/backup/%U'; BACKUP DATABASE SKIP INACCESSIBLE FILESPERSET 10   PLUS ARCHIVELOG FILESPERSET 20   DELETE ALL INPUT; RELEASE CHANNEL CH1; } ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK; CROSSCHECK BACKUPSET; DELETE NOPROMPT OBSOLETE;  案例如下： 1.首先执行备份脚本 2.删除相关的数据文件 shutdown immediate； 删除数据文件D:\app\Administrator\oradata\ticket\TBS_DATA.DBF startup ;  3.rman恢复 rman target / restore datafile 'D:\app\Administrator\oradata\ticket\TBS_DATA.DBF'; 恢复数据文件  recover database  datafile 'D:\app\Administrator\oradata\ticket\TBS_DATA.DBF';   4.sqlplus 中打开数据库  alter database open; 

?