topic ORA-27046 Backup fail in Operating System - HP-UX

ORA-27046 Backup fail

Pankaj K. Bharne — Tue, 23 Jun 2009 15:05:01 GMT

hi
i am working on HPUX,oracle 9.2,SAP ecc 5.0.
The backup of developement server is fail,the error message is ora 27046 the file size is not a multiple of logical block size...
plz help me ,...
By mistake,this thread is submitted in hpux>> networking category intially, bez i am very much new to these forums

Re: ORA-27046 Backup fail

Fabian Briseño — Tue, 23 Jun 2009 16:46:22 GMT

Hello Pankaj.
Did you change your data block size. ?

Since when did you started haveing problems ?

With what are you backing up that DB ?

Any additional information you could provide could help more.

Re: ORA-27046 Backup fail

Pankaj K. Bharne — Wed, 24 Jun 2009 06:45:35 GMT

Hi Fabian,
No, i can't change any block size. actually i recently join the company as a DBA,and the first task is to solve this developement backup problem.
The problem is more than 1 yr old.
The process that follow here is
schdule the backup by using Transaction code DB13 from SAP, then check the status of that backup by using DB12. i attach the summary log displayed in DB12. tape drives are used to take backup, if any other info requirs then will provide , plz help me to solve this problem..

Re: ORA-27046 Backup fail

Volker Borowski — Wed, 24 Jun 2009 14:58:32 GMT

Hi,

this error is at a very early stage of the backup that brbackup is trying.

Way before anything of the DB is saved!

BRInitOraCreate looks to me, that this Error
occurs, when brbackup is trying to create an
initGMD.ora file from your spfile.

It does this for parsing and parametercheck purposes.

Proceed as follow:

1) check ownership & permissions of "brbackup"
-> should be rwsr-x--- for orasid:sapsys
if not, run saproot.sh as root.

2) Check as "oragmd" that

sqlplus / as sysdba
create pfile form spfile;

is working correctly. If not, adjust accordingly
(most likely permissions on /oracle/GMD/920_64/dbs)

3) If both of the first two options work out
ok, a spfile-corruption might be possible.
(in case someone did use "vi" to edit the spfile)

Volker

Re: ORA-27046 Backup fail

Pankaj K. Bharne — Wed, 01 Jul 2009 09:11:16 GMT

Hi Volker,
Thanks for u r reply, this is most useful answer for me , but as u told that " create pfile from spfile" here is confusion that creation of pfile or spfile??? and also plz specify the first step of u r answer ie check ownership and permission of "brbackup"
i attach my initGMD.ora, plz go through it and if any other information required then will provide ,
Thanks again volker,plz reply me

Re: ORA-27046 Backup fail

Volker Borowski — Wed, 01 Jul 2009 20:10:55 GMT

Hi,

assuming a SAP standard installation:

As for the permissions:

su - gmdadm
cd /sapmnt/GMD/exe
su
./saproot.sh

This should set permissions for br-programs.

Warning: Ensure that "saproot.sh" is a valid SAP delivered copy and not some fake stuff.
If you are in doubt, get yourself a valid
copy from SAPNET (service.sap.com).

As for the pfile/spfile:

Your initGMD.ora looks at least like
something that one can start with.
Check if one or both files exist:

/oracle/GMD/102_4/dbs/init.GMD.ora
/oracle/GMD/102_4/dbs/spfileGMD.ora

Shutdown the system (SAP and DB)

cd /oracle/GMD/102_4/dbs
mv spfileGMD.ora spfileGMD.ora.corrupted

If no spfileGMD.ora exists, the DB will start with a initGMD.ora file. The one
you attached looks OK first hand.

sqlplus / as sysdba
startup nomount
create spfile from pfile;
shutdown

You will now have a valid spfile.

Now you should be able to startup everything
again and a

sqlplus / as sysdba
create pfile from spfile;

should now work without error.

Two comments / suggestions:

Version 9.2 is way out of support with SAP.
-> Consider to upgrade to 10.2.

Check out help.sap.com for some dba-guides
as fas as SAP/Oracle is concerned.
There are special guides describing how
to use the br-programs for DB administration.

Volker

Re: ORA-27046 Backup fail

Volker Borowski — Wed, 01 Jul 2009 20:14:47 GMT

Ok,

just remembered

sqlplus / as sysdba

does not work with oracle 9 !

Use

sqlplus "/ as sysdba"

or

sqlplus /nolog
connect / as sysdba

instead.

Sorry, but as said: Oracle 9 is quite old stuff.

V.

Re: ORA-27046 Backup fail

Pankaj K. Bharne — Sat, 04 Jul 2009 06:08:00 GMT

Thank you very much volker,
My problem is solved.
one thing i want to know details of u r certification and also plz give me u r gmail id if any
Thanks again....!

Re: ORA-27046 Backup fail

Volker Borowski — Sat, 04 Jul 2009 14:10:42 GMT

Hi,

the certification program changes every now and then :-)
The current revision should be reviewable at
http://www.sap.com/services/education/certification/index.epx

I never did this new stuff.
I got my certification at a very early stage in SAP lifecycle and from that point on I
delta-certified every 2-4 years all the way up :-)
That is not really compareable to what one needs to do now from scratch.

Good luck to you, if you go for it.
Volker

Re: ORA-27046 Backup fail

Pankaj K. Bharne — Mon, 06 Jul 2009 04:32:55 GMT

I have found a solution to this question...
thanks...