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

发布时间 2023-06-05 20:03:04作者: 亲爱的焦糖玛奇朵

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