***ORA-27046: file size is not a multiple of logic...

Former Member · ‎01-06-2009

Hi,

I could not be take a backup through brtools, its giving me a below message...

Kindly give me solution to solve this issue...

BR0051I BRBACKUP 7.00 (32)

BR0055I Start of database backup: bdzqjadj.pnd 2009-01-06 19.50.15

BR0484I BRBACKUP log file: /oracle/TRP/sapbackup/bdzqjadj.pnd

BR0280I BRBACKUP time stamp: 2009-01-06 19.50.15

BR0301E SQL error -27046 at location BrInitOraCreate-5, SQL statement:

**'/ BRBACKUP AT PROF_CONN / CREATE PFILE = '/oracle/TRP/102_64/dbs/sapTRP.ora' FROM SPFILE = '/oracle/TRP/102_64/dbs/spfileTRP.ora''**

**ORA-27046: file size is not a multiple of logical block size**

Additional information: 1

BR0303E Determination of Oracle version failed

BR0056I End of database backup: bdzqjadj.pnd 2009-01-06 19.50.15

BR0280I BRBACKUP time stamp: 2009-01-06 19.50.15

BR0054I BRBACKUP terminated with errors

Thanks & Regards,

Kumar

stefan_koehler · ‎01-06-2009

Hello Kumar,

i think you or a colleague of yours has changed the SPFILE manually (with an editor like vi).

This problem is described in sapnote #917293.

Solution:


shell> sqlplus / as sysdba
SQL> create spfile from pfile;

Regards

Stefan

***ORA-27046: file size is not a multiple of logical block size