ORA-19921: maximum number of 64 rows exceeded

郑全

Oracle用户下,进入rman报错,提示ORA-19921: maximum number of 64 rows exceeded

 

1、文件系统损坏，经过fsck后，原来存于文件系统的某些归档日志文件也接着损坏，当时没有发现。后来veritas备份的时候，出现如下报错：

channel ch00: backup set complete, elapsed time: 00:01:55
channel ch00: deleting archive log(s)
archive log filename=/global/arch/1_14840_640627149.dbf recid=27865 stamp=757748953
archive log filename=/global/arch/1_14841_640627149.dbf recid=27867 stamp=757748959
released channel: ch00
released channel: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch01 channel at 07/29/2011 06:07:13
ORA-19501: read error on file "/global/arch/2_14512_640627149.dbf", blockno 574465 (blocksize=512)
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 89: Invalid file system control data detected.
Additional information: -1
Additional information: 524288

2、根据oracle提供的工具dbv可以检查这种文件。为了不搞得那么复杂。在对数据库没有影响或者确认这些归档日志不是很重要的情况下，跳过这几个文件继续进行备份。

3、在/global下新建目录backup存放可能存在问题的几个文件：

su -

cd /global

mkdir backup

cd arch

mv 2_1451*.dbf ../backup/

cd ../backup;ls

4、在ORACLE用户下执行crosscheck：

rman target 用户/密码

RMAN>show all;

RMAN>list backup;

执行这部我有些后悔，数据太多，list了好久都没有停，于是用Ctrl+C停止，不行就直接断开telnet连接了，

再次进入rman的时候，发现有如下报错：

$ rman target /

Recovery Manager: Release 10.2.0.3.0 - Production on Fri Aug 5 18:48:52 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: TEST (DBID=409307213)
RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
ORACLE error from target database:
ORA-19921: maximum number of 64 rows exceeded
RMAN> exit

为了不影响接下来的工作，尝试先完成工作，因为本次只是删除或移动归档日志文件到别的地方，执行crosscheck通知rman，使得rman可以跳过这几个文件的备份。

rman target 用户/密码

RMAN>crosscheck archivelog all;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=530 instance=kpidb2 devtype=DISK
validation failed for archived log
archive log filename=/global/arch/1_14862_640627149.dbf recid=27910 stamp=758367734
validation failed for archived log
archive log filename=/global/arch/1_14863_640627149.dbf recid=27912 stamp=758378806
validation failed for archived log
archive log filename=/global/arch/1_14864_640627149.dbf recid=27914 stamp=758389776
validation failed for archived log
archive log filename=/global/arch/1_14865_640627149.dbf recid=27915 stamp=758389857
validation failed for archived log
archive log filename=/global/arch/2_14510_640627149.dbf recid=27508 stamp=756600140
validation failed for archived log
archive log filename=/global/arch/2_14511_640627149.dbf recid=27511 stamp=756600191
validation failed for archived log
archive log filename=/global/arch/2_14512_640627149.dbf recid=27514 stamp=756600248
validation failed for archived log
archive log filename=/global/arch/2_14513_640627149.dbf recid=27518 stamp=756600311
validation failed for archived log
archive log filename=/global/arch/2_14514_640627149.dbf recid=27521 stamp=756600372
validation failed for archived log
archive log filename=/global/arch/2_14515_640627149.dbf recid=27524 stamp=756600423
validation succeeded for archived log
archive log filename=/global/arch/2_14659_640627149.dbf recid=27793 stamp=757180768
validation succeeded for archived log
archive log filename=/global/arch/2_14660_640627149.dbf recid=27794 stamp=757181935
validation succeeded for archived log
archive log filename=/global/arch/2_14661_640627149.dbf recid=27797 stamp=757181941
validation succeeded for archived log
archive log filename=/global/arch/2_14662_640627149.dbf recid=27798 stamp=757220029
validation succeeded for archived log
archive log filename=/global/arch/2_14663_640627149.dbf recid=27801 stamp=757220036
validation succeeded for archived log
archive log filename=/global/arch/2_14664_640627149.dbf recid=27802 stamp=757351610
validation succeeded for archived log
archive log filename=/global/arch/2_14684_640627149.dbf recid=27841 stamp=757544096
validation succeeded for archived log
archive log filename=/global/arch/2_14685_640627149.dbf recid=27843 stamp=757544100
validation succeeded for archived log
archive log filename=/global/arch/2_14686_640627149.dbf recid=27845 stamp=757600972
validation succeeded for archived log
archive log filename=/global/arch/2_14687_640627149.dbf recid=27848 stamp=757600977
validation succeeded for archived log
archive log filename=/global/arch/2_14688_640627149.dbf recid=27849 stamp=757612961
validation succeeded for archived log
archive log filename=/global/arch/2_14689_640627149.dbf recid=27852 stamp=757612965
validation succeeded for archived log
archive log filename=/global/arch/2_14690_640627149.dbf recid=27853 stamp=757672650
validation succeeded for archived log
archive log filename=/global/arch/2_14691_640627149.dbf recid=27856 stamp=757672656
validation succeeded for archived log
archive log filename=/global/arch/2_14692_640627149.dbf recid=27858 stamp=757691231
validation succeeded for archived log
archive log filename=/global/arch/2_14693_640627149.dbf recid=27859 stamp=757691233
validation succeeded for archived log
archive log filename=/global/arch/2_14694_640627149.dbf recid=27861 stamp=757738929
validation succeeded for archived log
archive log filename=/global/arch/2_14695_640627149.dbf recid=27864 stamp=757738935
validation succeeded for archived log
archive log filename=/global/arch/2_14696_640627149.dbf recid=27866 stamp=757748651
validation succeeded for archived log
archive log filename=/global/arch/2_14697_640627149.dbf recid=27868 stamp=757748657
validation succeeded for archived log
archive log filename=/global/arch/2_14698_640627149.dbf recid=27869 stamp=757802327
validation succeeded for archived log
archive log filename=/global/arch/2_14709_640627149.dbf recid=27891 stamp=758217818
validation succeeded for archived log
archive log filename=/global/arch/2_14710_640627149.dbf recid=27894 stamp=758217823
validation succeeded for archived log
archive log filename=/global/arch/2_14711_640627149.dbf recid=27896 stamp=758239573
validation succeeded for archived log
archive log filename=/global/arch/2_14712_640627149.dbf recid=27898 stamp=758239576
validation succeeded for archived log
archive log filename=/global/arch/2_14713_640627149.dbf recid=27900 stamp=758299972
validation succeeded for archived log
archive log filename=/global/arch/2_14714_640627149.dbf recid=27901 stamp=758307667
validation succeeded for archived log
archive log filename=/global/arch/2_14715_640627149.dbf recid=27902 stamp=758310402
validation succeeded for archived log
archive log filename=/global/arch/2_14716_640627149.dbf recid=27905 stamp=758310410
validation succeeded for archived log
archive log filename=/global/arch/2_14717_640627149.dbf recid=27906 stamp=758338357
validation succeeded for archived log
archive log filename=/global/arch/2_14718_640627149.dbf recid=27909 stamp=758338359
validation succeeded for archived log
archive log filename=/global/arch/2_14719_640627149.dbf recid=27911 stamp=758369174
validation succeeded for archived log
archive log filename=/global/arch/2_14720_640627149.dbf recid=27913 stamp=758386571
validation succeeded for archived log
archive log filename=/global/arch/2_14721_640627149.dbf recid=27916 stamp=758394917
Crosschecked 44 objects

RMAN> exit

果然是OK的。

5、接下里处理由于非正常退出rman造成的报错。

ps -ef|grep rman|grep -v grep

发现之前的rman还挂在那里

oracle 241950 1 0 22:02:58 - 0:18 rman target 用户/密码

rman不是oracle运行所需的后台进程，可以使用操作系统命令kill掉

于是kill -9 241950 杀掉。

再次执行ps -ef|grep rman|grep -v grep, 进程已经被杀掉。

运行rman，已经没有报错了。