- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Clone database problem
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
тАО02-01-2006 09:11 PM
тАО02-01-2006 09:11 PM
I tried 'clone' a database from windows to another HP-UX server. I have done the following steps:
1. copy production database files and init.ora
2. create the script that will re-create the controlfile:
alter database backup controlfile to trace;
3. alter the script pointing to the new locations
But when i try to create the new controlfile this happens:
ORACLE instance started.
Total System Global Are xxxx bytes
Fixed Size xxxx bytes
....
....
CREATE CONTROLFILE SET DATABASE "SIGES" RESETLOGS ARCHIVELOG
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file /u1/oradata/siges/SYSTEM01.DBF
ORA-27047: nable to read the header block of file
HP-UX Error:22: Invalid argument
Additional information:2
Can anyone help me to solve this ?
Best Regards
PS: i have already tried to swap the bytes because of the little endian/big endian problem
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 09:22 PM
тАО02-01-2006 09:22 PM
Re: Clone database problem
I think you don't have enough shared memory.
Increase your kernel parameters for the shared memory
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 09:27 PM
тАО02-01-2006 09:27 PM
Re: Clone database problem
Please post the following command output:
$ll /u1/oradata/siges
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 09:48 PM
тАО02-01-2006 09:48 PM
Re: Clone database problem
I think the sga configuration in init.ora is not compatible with the server you are migrating it too.
There may be permissions problem if some of these files were transferred by root.
There appears to be an issue with shared memory.
Please post kmtune output for further assistance.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 09:55 PM
тАО02-01-2006 09:55 PM
Re: Clone database problem
You said you copied the files from the win server to the ux server? What command did you used? rcp, ftp, etc...? With ftp you must ensure that the database, redolog and control files were transfered via BINARY mode and the init.ora via ASCII mode.
Plus, make sure "/u1/oradata/siges/" has 755 mode and that SYSTEM01.DBF exsists and has this exact name (upper or lower case matters in Unix) in this directory .
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 09:58 PM
тАО02-01-2006 09:58 PM
Re: Clone database problem
Creating a controlfile, oracle checks the existence of files referenced, i.e. whether the files are actually existing or not. & this may be the cause for you getting this error. Check if the file exists in the specified path.
Also 'ORA-27047:unable to read the header block of file' indicates that the read system call failed, additional information will indicate which function encountered the error.
The error no. HP_UX error:22 is invalid argument.
Binary datafiles are specific to the operating system, file system and hardware. My cure would be to recreated the tablespace.
Regards,
Simon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 10:23 PM
тАО02-01-2006 10:23 PM
Re: Clone database problem
"Binary datafiles are specific to the operating system, file system and hardware". I'm not sure about that because I have sucessfuly recovered a HP-UX production database to a HP-UX development database from *.dbf and *.ctl files backed up to a windoze server (HP-UX PROD -> [dbf and ctl bin ftp; init.ora ascii ftp] Windows file server -> [dbf and ctl bin ftp; init.ora ascii ftp] HP-UX TEST).
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2006 12:14 AM
тАО02-02-2006 12:14 AM
Re: Clone database problem
You cannot restore a backup from platform X onto platform Y, no.
In 10g Release 1 there are cross platform transportable tablespaces (but not backup platform x and restore to platform y).
But what you are trying to do is not supported!!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2006 12:52 AM
тАО02-02-2006 12:52 AM
Re: Clone database problem
thanks for all replies
First,the output of ll /u1/oradata/siges is:
total 9913632
-rwxrwxr-x 1 oracle oinstall .... CONTROL01.CTL
-rwxrwxr-x 1 oracle oinstall .... MEDIUM01.DBF
-rwxrwxr-x 1 oracle oinstall .... SYSTEM01.DBF
-rwxrwxr-x 1 oracle oinstall .... SYSTEM02.ORA
-rwxrwxr-x 1 oracle oinstall .... USERS01.DBF
.....
What is the sga configuration?
I have copied the files from win server through ftp bin mode and init.ora ascii mode
Are you sure that i cannot copy from windows to HP-UX? i really need to do it, there are any solution for it?
Best Regards
Pinki
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2006 01:29 AM
тАО02-02-2006 01:29 AM
SolutionThe only other way to do it is to create a fresh database in HP-UX with all the required tablespaces (those you have in the win database), export the win database with the owner/user (8i/9i ?) option and finally import it into the HP-UX database.
Best Regards,
Eric Antunes