SBT_TAPE_2channelat08/13/201813:54:31ORA-19554:errorallocatingdevice,device type:SBT_TAPE,device name:ORA-27211:FailedtoloadMediaManagementLibraryAdditional information:2RMAN>deleteobsolete;RMANretentionpolicywillbeappliedtothecommandRMANretentionpolicyissettorecoverywindowof7daysDeleting the following obsolete ...
删除相关的备份集或镜像副本的物理文件,同时将删除标记delete更新到控制文件.如果使用恢复目录,则是清除恢复目录内的该备份集。 RMAN> delete backupset; RMAN> delete backupset n; RMAN> delete obsolete ; RMAN> delete obsolete redundancy 2; RMAN> delete noprompt copy; RMAN> delete noprompt backupset tag TA...
-- 同样报错,提示SBT_TAPE通道不可用; 因为原有通道已经不存在,所以只能再分配一个虚假的磁带通道: allocate channel for maintenance device type sbt parms 'SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=/tmp)'; -- 然后再执行: crosscheck backup; delete backup; -- 命令成功,最终结果如下: RMAN> list ...
RMAN> delete obsolete; Although the media manager isn’t available any longer, RMAN simulates a callout to the media management layer (MML) and successfully initiates the maintenance command to delete the old tape backups you want toget rid of. 于是执行如下,过期与废弃的SBT类型的备份都被删除...
channel ORA_MAINT_SBT_TAPE_2: Veritas NetBackup for Oracle – Release 7.1 (2011020316) RMAN> delete backupset device type SBT_TAPE; List of Backup Pieces BP Key BS Key Pc# Cp# Status Device Type Piece Name ——- ——- ———–———–———- 37 37...
假定在RMAN提示符下执行backup datafile 1,则RMAN会使用预先配置的通道参数为之分配通道 这些命令backup、restore、delete在非run块中运行时会根据configure命令设定的值自动分配通道 但上述命令在run块中则需要手动分配通道 ——改变缺省的设备类型 RMAN> CONFIGURE DEFAULT DEVICE TYEP TO sbt; ...
备份BACKUP命令中定义的文件 运行ALTER SYSTEM ARCHIVE LOG CURRENT 命令 备份所有的剩下的归档日志 备份完后删除归档日志RMAN> backup …… ARCHIVELOG all delete all input;修改备份集的保存策略例如:将备份设置为永久有效RMAN> backup database keep forever logs|nologs;设置为有效期 180 天RMAN> backup database...
Backup (tablespace system,users channel ora_sbt_1) (tablespace example channel ora_sbt_2); } 自动通道配置 在RUN外部使用backup,restore,delete命令,或在RUN中使用这些命令但未定义通道时RMAN自动使用自动通道配置。 例: backup tablespace users;
对于SBT设备的读/写,默认情况下每个通道分配4个缓冲,具体大小依赖操作系统而定(一般Linux是256KB)。 占用PGA还是SGA取决于初始化参数backup_type_io_slaves等于true还是false。同样,走SGA路线时请确保large_pool_size不为0。 由于RMAN和SBT设备之间是同步的I/O调用,效率可能不佳。所以将backup_type_io_slaves设置为...
根据上述信息,可以得到问题的原因,一般再删除过期的备份脚本时,如果通道默认都是disk磁盘,如果存在sbt磁带备份,则无法通过这个通道删除它,因此需要转换一下。 SOLUTION To implement the solution, please execute the following steps: Please run the following commands to delete obsolete backup sets on both disk ...