iis服务器助手广告广告
返回顶部
首页 > 资讯 > 数据库 >ORA-19606: Cannot copy or restore to snapshot control file
  • 454
分享到

ORA-19606: Cannot copy or restore to snapshot control file

2024-04-02 19:04:59 454人浏览 安东尼
摘要

今早上班发现在删除过期备份的控制文件镜像时报错,查询mos发现如下文章可以解决,特此记录: Error ORA-19606 on RMAN Delete (文档 ID 1215493.1), 处理思路是将指

今早上班发现在删除过期备份的控制文件镜像时报错,查询mos发现如下文章可以解决,特此记录:
Error ORA-19606 on RMAN Delete (文档 ID 1215493.1),
处理思路是将指定过期的镜像控制文件从控制文件记录的备份信息uncatalog出去,如下

SYMPTOMS:
=== ODM Issue Clarification ===


Receiving error on 'delete obsolete':
delete noprompt obsolete device type disk;


RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 5 days
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 3 01-SEP-10 C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFAXMPRD.ORA
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_MAINT_DISK_1 channel at 09/09/2010 02:04:24
ORA-19606: Cannot copy or restore to snapshot control file




CAUSE:

=== ODM Cause Determination ===

The snapshot controlfile is cataloged as a controlfile copy and is now obsolete. RMAN cannot delete this file as it is used by rman. 


=== ODM Cause Justification ===

Error and infORMation supplied justifies cause

SOLUTION:

=== ODM Solution / Action Plan ===
The snapshot controlfile must be removed as a valid controlfile copy.  To do this, you would:
RMAN>  change controlfilecopy 'C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFAXMPRD.ORA' uncatalog;
Confirm with:
RMAN>  list copy of controlfile;

您可能感兴趣的文档:

--结束END--

本文标题: ORA-19606: Cannot copy or restore to snapshot control file

本文链接: https://www.lsjlt.com/news/47967.html(转载时请注明来源链接)

有问题或投稿请发送至: 邮箱/279061341@qq.com    QQ/279061341

本篇文章演示代码以及资料文档资料下载

下载Word文档到电脑,方便收藏和打印~

下载Word文档
猜你喜欢
软考高级职称资格查询
编程网,编程工程师的家园,是目前国内优秀的开源技术社区之一,形成了由开源软件库、代码分享、资讯、协作翻译、讨论区和博客等几大频道内容,为IT开发者提供了一个发现、使用、并交流开源技术的平台。
  • 官方手机版

  • 微信公众号

  • 商务合作