rman测试备份跳过固定表空间后做全库恢复 (recover database skip tablespace )

rman备份排除表空间：

备份过程截图：

备份脚本：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

run{ allocate channel t1 device type disk; allocate channel t2 device type disk; backup as compressed backupset incremental level 0 filesperset 10 format '/u01/backup/data_%T_%U' database; sql 'alter system archive log current'; backup as compressed backupset filesperset 10 format '/u01/backup/arc_%s_%p_%t' (archivelog all delete input); backup as compressed backupset format '/u01/backup/ct_%s_%p_%t' current controlfile; delete noprompt obsolete; release channel t1; release channel t2; }

恢复控制文件

mount数据库

进行restore操作：

进行recover database 跳过表空间ogg

?

1	recover database skip tablespace ogg;

 

 

数据库恢复成功，OGG表空间为0