Home » Infrastructure » Linux » ora:27046-file size is not multiple of logical block (oracle 11.1 linux)
ora:27046-file size is not multiple of logical block [message #520697] Wed, 24 August 2011 02:34 Go to next message
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?



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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
File is corrupted, nothing can be done for it.

Regards
Michel
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
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 Go to previous message
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.

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


Current Time: Fri Mar 29 01:06:29 CDT 2024