- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- File size difference on PARISC and IPF..
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
тАО07-12-2009 10:55 AM
тАО07-12-2009 10:55 AM
File size difference on PARISC and IPF..
We have oracle 11i running on HPUX 11iV3.
I have restored some oracle datafiles from PA-RISC server to IPF server. after restoration when asked DBA to bring up the database on IPF, it shows error that the datafile is not in multiple of the block size parameter of the database. the block size parameter value is set to 8192. also the same datafile are of different sizes in PA-RISC and IPF server. The database is fine and running on PA-RISC, where as when trying to start the Database on IPF it shows that error saying that the datafile size is not in multiple of 8192, hence the database is not coming up......Has any one faced such issue ???? need help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2009 11:10 PM
тАО07-12-2009 11:10 PM
Re: File size difference on PARISC and IPF..
So the difference between an IA and PA oracle datafile should be zero... I would be suspicious of your backup/restore process at this point.
HTH
Duncan
I am an HPE Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2009 11:49 PM
тАО07-12-2009 11:49 PM
Re: File size difference on PARISC and IPF..
>>The database is not coming up
reasons;-
a) "The block size parameter value is set to 8192"
The "db_block_size" are not same on both the database.You cannot change this parameter ,only way to recreate the database with the identical block size.
b)You are just copying the dbf files from one database to other .
The SCN number of the file will be different and you cannot start the database.
If feel you can export the tablespaces/tables and import it on the new database after creating logical structure.
Regards,
Aneesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-12-2009 11:50 PM
тАО07-12-2009 11:50 PM
Re: File size difference on PARISC and IPF..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-13-2009 03:52 AM
тАО07-13-2009 03:52 AM
Re: File size difference on PARISC and IPF..
Though it varies from database version to version, Oracle provided different binaries for the same version IPF/PA-RISC. Depending on certain parameters, such as block size, http://metalink.oracle.com provided a conversion procedure for data.
It would be interesting to see how compatible the data files are if parameters such as block size were the same on both platforms.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com