ORA-19606: Cannot copy or restore to snapshot control file
ORA-19606: Cannot copy or restore to snapshot control file
1. Set new name (or location) for RMAN to use for snapshot controlfile:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/11.2.0/db_1/dbs/snapcf_gsfop.ORA';
2. Remove the snapshot controlfile from the RMAN information as a controlfile copy.
rm -f /app/oracle/product/11.2.0/db_1/dbs/snapcf_gsfop.f
3. Crosscheck and delete the file from RMAN:
crosscheck controlfile'/app/oracle/product/11.2.0/db_1/dbs/snapcf_gsfop.f';
delete expired controlfilecopy '/app/oracle/product/11.2.0/db_1/dbs/snapcf_gsfop.f';
4. Set the snapshot controlfile name (or location) to original:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/11.2.0/db_1/dbs/snapcf_gsfop.f';
5. To set the snapshot controlfile name back to default value:
CONFIGURE SNAPSHOT CONTROLFILE NAME clear;
1. Set new name (or location) for RMAN to use for snapshot controlfile:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/11.2.0/db_1/dbs/snapcf_gsfop.ORA';
2. Remove the snapshot controlfile from the RMAN information as a controlfile copy.
rm -f /app/oracle/product/11.2.0/db_1/dbs/snapcf_gsfop.f
3. Crosscheck and delete the file from RMAN:
crosscheck controlfile'/app/oracle/product/11.2.0/db_1/dbs/snapcf_gsfop.f';
delete expired controlfilecopy '/app/oracle/product/11.2.0/db_1/dbs/snapcf_gsfop.f';
4. Set the snapshot controlfile name (or location) to original:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/11.2.0/db_1/dbs/snapcf_gsfop.f';
5. To set the snapshot controlfile name back to default value:
CONFIGURE SNAPSHOT CONTROLFILE NAME clear;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29065182/viewspace-2106689/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
Linux发邮件磁盘空间监控
下一篇：
分区管理过程
请登录后发表评论
登录
全部评论
