ORA-00245 & RMAN-08132 RMAN之snapshot control file
来源:互联网 发布:255hh的新域名网站 编辑:程序博客网 时间:2024/06/15 17:51
Tue Jul 23 22:01:01 2013
Errors in file /oracle/app/db/diag/rdbms/db/db1/trace/db1_ora_9114.trc:
ORA-00245: 控制文件备份失败; 目标可能位于本地文件系统1m|-
查看备份的log,
Starting Control File and SPFILE Autobackup at 23-JUL-13
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 07/23/2013 22:01:57
ORA-00245: 控制文件备份失败
但是在备份log中,控制文件已经备份成功,应该是备份完成后的控制文件快照备份失败。MOS中有以下文档ORA-245: In RAC environment from 11.2 onwards Backup Or Snapshot controlfile needs to be in shared location (文档 ID 1472171.1),其中有一段是
5. In RAC environment, Rman backup fails if snapshot controlfile is not in shared location.
RMAN-00571: ========================================================
RMAN-00569: ============ ERROR MESSAGE STACK FOLLOWS =============
RMAN-00571: =========================================================
RMAN-03009: failure of resync command on default channel at 03/13/2012 10:19:41
ORA-00245: control file backup operation failed
在RMAN中使用show all发现,snapshot果然只是在单个节点中,
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/app/11.2.0/db_1/dbs/snapcf_db1.f'; # default
修改到shared disk中。
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '<shared_disk>/snapcf_<DBNAME>.f';
Errors in file /oracle/app/db/diag/rdbms/db/db1/trace/db1_ora_9114.trc:
ORA-00245: 控制文件备份失败; 目标可能位于本地文件系统1m|-
查看备份的log,
Starting Control File and SPFILE Autobackup at 23-JUL-13
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 07/23/2013 22:01:57
ORA-00245: 控制文件备份失败
但是在备份log中,控制文件已经备份成功,应该是备份完成后的控制文件快照备份失败。MOS中有以下文档ORA-245: In RAC environment from 11.2 onwards Backup Or Snapshot controlfile needs to be in shared location (文档 ID 1472171.1),其中有一段是
5. In RAC environment, Rman backup fails if snapshot controlfile is not in shared location.
RMAN-00571: ========================================================
RMAN-00569: ============ ERROR MESSAGE STACK FOLLOWS =============
RMAN-00571: =========================================================
RMAN-03009: failure of resync command on default channel at 03/13/2012 10:19:41
ORA-00245: control file backup operation failed
在RMAN中使用show all发现,snapshot果然只是在单个节点中,
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/app/11.2.0/db_1/dbs/snapcf_db1.f'; # default
修改到shared disk中。
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '<shared_disk>/snapcf_<DBNAME>.f';
0 0
- ORA-00245 & RMAN-08132 RMAN之snapshot control file
- rman 备份出现ORA-00245/RMAN-08132
- Oracle 11g RAC RMAN ORA-00245 control file backup operation failed 错误 与 控制文件备份 说明
- Oracle 11g RAC RMAN ORA-00245 control file backup operation failed 错误 与 控制文件备份 说明
- RMAN-00571 ORA-00245
- ORA-00245 & RMAN-03009
- RMAN恢复报错: ORA-01103: database name 'POWERDES' in control file is not 'PDUNQ'
- ORA-19606: Cannot copy or restore to snapshot control file
- ORA-19606: Cannot copy or restore to snapshot control file
- ORACLE RMAN备份失败之ORA-19599
- Oracle RMAN 丢失归档日志:ORA-19625: error identifying file
- RMAN备份时出现ORA-27038: created file already exists
- ora-20242/rman-20242
- RMAN-03009 & ORA-17628
- RMAN-03009,ORA-00230
- RMAN-03009 ORA-15028
- ORACLE RAC集群 RMAN自动备份controlfile失败之ORA-00245&ORA-27037
- ORACLE rman备份报错之RMAN-03009&ORA-19587&ORA-27072
- Android AIDL机制
- base64解码
- 最长的单词
- CSS之边框及盒子效果
- 循环某个Viewpager或别的控件时,获取某个数据的倍数
- ORA-00245 & RMAN-08132 RMAN之snapshot control file
- Python ImportError: No module named requests
- POJ 1064 Cable master (二分搜索)
- 经典的”服务器最多65536个连接”误解
- 齐次坐标
- R语言学习(六)
- java基础:多态(动态绑定)
- C++课本总结(第一遍)
- oracle RMAN快照控制文件