delete obsolete; 发现出现报错 ORA-19606: Cannot copy or restore to snapshot control file
解决办法:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.4/db_1/dbs/snapcf_slnngk.f_bak'; --先重命名文件
crosscheck controlfilecopy '/u01/app/oracle/product/11.2.0.4/db_1/dbs/snapcf_slnngk.f';
delete expired controlfilecopy '/u01/app/oracle/product/11.2.0.4/db_1/dbs/snapcf_slnngk.f';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.4/db_1/dbs/snapcf_slnngk.f';
CONFIGURE SNAPSHOT CONTROLFILE NAME clear;
ORA-19606: Cannot copy or restore to snapshot control file
原创
©著作权归作者所有:来自51CTO博客作者wx5caecf2ed0645的原创作品,请联系作者获取转载授权,否则将追究法律责任
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
ora-19606异常处理记录
ora-19606异常处理记录
oracle 控制文件 2d -
RMAN备份集不能有效释放空间
ORA-19606: Cannot copy or restore to snapshot control file
ORA 19606 RMAN 杨俊峰 -
Oracle故障处理:Rman delete obsolete报错ORA-19606解决
在使用rman维护数据库备份记录的时候,通过delete obsolete命令删除文件的时候发生了ora-19606,具体报错如下:RMAN> delete obsolete;RMAN retention policy will be applied to the commandRMAN retention policy is set to redundancy 1using channel
oracle delete obsolete ora-19606 rman snapshot controlfile