Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-19575: expected 409598 blocks in file /oravol05/... found 0

user12158503Dec 17 2010 — edited Dec 17 2010
ORA-19575: expected 409598 blocks in file /oravol05/... found 0
Recently we upgraded our oracle databases from 9.2.0.6 to 11.2.0.1. We also upgraded the Netbackups version to 6.5.6 since the RMAN hot backups were failing without this Once the Netbackups were upgraded, the hot backups wouldn't complete as it complained about an archive log that we had prior to the 11.2.0.1 upgrade. For the upgrade to 11.2.0.1 , we also had upgraded our OS from Solaris 9 to Solaris 10 update 9

The hot backup would fail with the error -
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on T3 channel at 12/15/2010 04:10:58
ORA-19575: expected 409598 blocks in file /oravol05/oradata/****/arch/T0001S0000018687.arc, found 0
RMAN-03009: failure of backup command on T1 channel at 12/15/2010 03:57:02
ORA-19575: expected 409598 blocks in file /oravol05/oradata/****/arch/T0001S0000018687.arc, found 0

Another change that we made during the upgrade was in the archive log format.
Pre-Upgrade (9i) -
log_archive_format='T%TS%S.arc'

Post Upgrade (11gr2) -
log_archive_format=altairp_%t_%s_%r.arc

Does anyone know if this could be because of the change in the archive log format and Oracle can't backup an archive log specified ion the old format? Any articles/docs/links pretaining to this would be appreciated

Thanks much!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 14 2011
Added on Dec 17 2010
3 comments
919 views