Oracle 10G RAC - 归档参数格式导致归档至ASM时出错的问题
来源:互联网 发布:淘宝可以买凤楼信息吗 编辑:程序博客网 时间:2024/06/01 23:57
10G RAC在ASM中存放归档日志参数正确设置
log_archive_dest_1 string location=+RECOVERY/JTPROD
在利用vmware workstation进行共享磁盘,当设置log_archive_dets_1为‘+RECOVERY/JTPROD/archfolder’类似格式时,归档时会导致磁盘不一致,归档文件也不能够正常使用,包括crosscheck与backup archivelog all等常用的管理操作。
错误如下alter日志:
SUCCESS: diskgroup ARCH was mounted
archivelog header validation failure for file +ARCH/jtprod/1_13_772105560.dbf
archivelog header validation failure for file +ARCH/jtprod/1_15_772105560.dbf
Mon Jan 09 13:38:29 CST 2012
SUCCESS: diskgroup ARCH was dismounted
调试过程如下:
RMAN>backup database plus archivelog;
ORA-19563: archived logheader validation failed for file
RMAN>crosscheck archivelog all;该文件为failed。
RMAN>list expired copy;显示这些归档无效,不能被使用。
RMAN>delete expired coyp;只好将之删除。
解决
当log_archive_dest_1调整为location=+RECOVERY/JTPROD是则不再报错。
SQL>alter system set log_archive_dest_1='location=+RECOVERY/JTPROD' scope=spfile sid='JTPROD1';
SQL>alter system set log_archive_dest_1='location=+RECOVERY/JTPROD' scope=spfile sid='JTPROD2';
log_archive_dest_1scope=both修改后spfile和memory可以立马生效.
同时如果还有类似错误需要进行
RMAN> allocate channel for maintenance type disk;
allocated channel: ORA_MAINT_DISK_1
channel ORA_MAINT_DISK_1: sid=133 instance=JTPROD1 devtype=DISK
RMAN> change archivelog all crosscheck;
validation succeeded for archived log
archive log filename=+RECOVERY/jtprod/1_35_772105560.dbf recid=78 stamp=772236831
validation succeeded for archived log
archive log filename=+RECOVERY/jtprod/1_36_772105560.dbf recid=81 stamp=772236893
validation succeeded for archived log
archive log filename=+RECOVERY/jtprod/1_37_772105560.dbf recid=82 stamp=772237064
validation succeeded for archived log
archive log filename=+RECOVERY/jtprod/1_38_772105560.dbf recid=84 stamp=772237096
validation succeeded for archived log
archive log filename=+RECOVERY/jtprod/1_39_772105560.dbf recid=88 stamp=772237236
validation succeeded for archived log
archive log filename=+RECOVERY/jtprod/1_40_772105560.dbf recid=89 stamp=772237681
validation failed for archived log
archive log filename=+RECOVERY/jtprod/2_52_772105560.dbf recid=87 stamp=772237227
validation succeeded for archived log
archive log filename=+RECOVERY/jtprod/2_53_772105560.dbf recid=90 stamp=772237680
Crosschecked 8 objects
RMAN> release channel;
released channel: ORA_MAINT_DISK_1
补充说明
当手工删除了数据库的归档文件后,要执行以下脚本进行同步:
RMAN> allocate channel for maintenance type disk;
RMAN> change archivelog all crosscheck;
RMAN> release channel;
当手工删除了数据库的RMAN备份文件后,要执行以下脚本进行同步:
RMAN> allocate channel for maintenance type disk;
RMAN> crosscheck backup;
RMAN> delete expired backup;
RMAN> release channel;
如果目标数据库物理对象发生了变化,如添加数据文件,应用如下命令同步:
RMAN>resync catalog;
- Oracle 10G RAC - 归档参数格式导致归档至ASM时出错的问题
- oracle 10g rac+asm 归档路径磁盘组空间满问题处理
- Oracle 10g rac将归档日志从文件系统拷贝至ASM磁盘组
- Oracle 11g RAC更改归档到ASM
- oracle 10g rac归档模式切换
- Oracle 10gR2 RAC+ASM 归档设置示例
- oracle 10g/11g RAC 启停归档模式
- ORACLE 11G RAC下的归档切换
- oracle 10g rac standby 归档日志自动删除脚本
- Oracle RAC 11g 修改归档模式
- oracle rac 11g如何修改归档到ASM FRA磁盘
- Oracle 10G RAC - 某个节点上缺失某些归档日志后删除报错问题
- (04)归档模式设置大全(8i,9i,10g,11g,RAC+ASM)
- 11g rac ASM下最简单归档开启方法
- Oracle 10G DG - 归档日志坏掉导致无法启用MRP问题
- 修改 oracle 10g 的归档模式
- 11g RAC 更改归档模式 ,归档文件存放在ASM 磁盘组
- 11g RAC 更改归档模式 ,归档文件存放在ASM 磁盘组
- Oracle 10G RAC与10G Physical DG 的测试-2
- ORA-12170 TNS 连接超时 .
- void在C/C++中的两种不同含义
- Oracle 10G RAC Clusterware Install ERROR:OCR integrity results are inconsistent amongst the nodes.
- Oracle 无法监听 因目标主机或对象不存在 连接失败--解决方案
- Oracle 10G RAC - 归档参数格式导致归档至ASM时出错的问题
- 面经:面试官会关注你的哪些能力?
- winCE开发心得之一:不让使用MethodInvoker
- Oracle 10G DG - 归档日志坏掉导致无法启用MRP问题
- Rod Johnson从VMware离职,Spring Framework将何去何从?
- VC/MFC中通过CWebPage类调用javascript函数(给js函数传参,并取得返回值)
- [Java] Eclipse 更改默认字体
- python的PEXPECT模块进行交换机配置文件的自动备份
- Oracle 10g ASM - 创建DISKGROUP时无法识别ASM磁盘ORCL:DATA*及无法全部挂载的问题