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
标签：database,全库,备份,skip,_%,recover,backup,channel From： https://www.cnblogs.com/elanjie/p/17458805.html