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


备份过程截图:
备份脚本:
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
recover database skip tablespace ogg;


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

浙公网安备 33010602011771号