OraFAQ Forum: Linux » ora:27046-file size is not multiple of logical block

Home » Infrastructure » Linux » ora:27046-file size is not multiple of logical block (oracle 11.1 linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora:27046-file size is not multiple of logical block [message #520697]

Wed, 24 August 2011 02:34

nehhaverma
Messages: 34
Registered: September 2009
Location: JAIPUR

Member

hi

I am restoring database from backup.
below steps that I used:

$ORACLE_HOME/bin/sqlplus connect as sysdba
shutdown immediate

cd $ORACLE_HOME/bin
./rman target /

RMAN>startup nomount;
RMAN>restore controlfile from '/u01/app/oracle/flash_recovery_area/DPC11/autobackup/18_8_2011/o1_mf_s_759472776_74sn369s_.bkp';
RMAN>alter database mount;

then I crosscheck
crosscheck backup;
crosscheck copy;
crosscheck backup of database;
crosscheck backup of controlfile;
crosscheck archivelog all;

Then I catalog all backup piece all pieces are successfully catalog except 1 i.e.
CATALOG backuppiece '/u01/backups/klmj1c3r_1_1';
ORA-19870: error while restoring backuppiece '/u01/backups/klmj1c3r_1_1'
ORA-19550: failed to identify file"/u01/backups/klmj1c3r_1_1'"
ORA-27046: file size is not multiple of logical block

please help what to do now?

Report message to a moderator

Re: ora:27046-file size is not multiple of logical block [message #520700 is a reply to message #520697]

Wed, 24 August 2011 02:48

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

File is corrupted, nothing can be done for it.

Regards
Michel

Report message to a moderator

Re: ora:27046-file size is not multiple of logical block [message #520701 is a reply to message #520700]

Wed, 24 August 2011 02:55

nehhaverma
Messages: 34
Registered: September 2009
Location: JAIPUR

Member

hi

then I want to restore database without using this backup piece
how can i skip this file I tried after taht restore database cmd and it shows new error

RMAN-06023: no backup or copy of datafile 4 found to restore

still I want to skip but how?

regards//neha

Report message to a moderator

Re: ora:27046-file size is not multiple of logical block [message #520709 is a reply to message #520701]

Wed, 24 August 2011 03:22

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Catalog a previous backup of this file, if you have any.
Otherwise, skip the tablespace that contains this file.

Regards
Michel

Report message to a moderator

Re: ora:27046-file size is not multiple of logical block [message #520828 is a reply to message #520697]

Wed, 24 August 2011 22:53

saurabh007
Messages: 1
Registered: August 2011
Location: delhi,india

Junior Member

Hey Hi,

I also faced this problem few days back.
Did you try again catalog that particular piece ??
Usually if there is no any error in rman logs (when taking backup through RMAN ) so you can retry to catalog and it will be catalog.

Report message to a moderator

Previous Topic:	mailx error "is not a user of this system"
Next Topic:	JDK Version on RHEL 5.X

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 01:32:42 CST 2025