- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- ORA-27046 Backup fail
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-23-2009 08:05 AM
тАО06-23-2009 08:05 AM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-23-2009 09:46 AM
тАО06-23-2009 09:46 AM
Re: ORA-27046 Backup fail
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-23-2009 11:45 PM
тАО06-23-2009 11:45 PM
Re: ORA-27046 Backup fail
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..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-24-2009 07:58 AM
тАО06-24-2009 07:58 AM
Re: ORA-27046 Backup fail
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-01-2009 02:11 AM
тАО07-01-2009 02:11 AM
Re: ORA-27046 Backup fail
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-01-2009 01:10 PM
тАО07-01-2009 01:10 PM
Solutionassuming 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-01-2009 01:14 PM
тАО07-01-2009 01:14 PM
Re: ORA-27046 Backup fail
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-03-2009 11:08 PM
тАО07-03-2009 11:08 PM
Re: ORA-27046 Backup fail
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....!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-04-2009 07:10 AM
тАО07-04-2009 07:10 AM
Re: ORA-27046 Backup fail
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2009 09:32 PM
тАО07-05-2009 09:32 PM
Re: ORA-27046 Backup fail
thanks...