cancel
Showing results for 
Search instead for 
Did you mean: 

Clone database problem

SOLVED
Go to solution
Pinki Meggi
Frequent Advisor

Clone database problem

Hi,

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



























11 REPLIES
Luk Vandenbussche
Honored Contributor

Re: Clone database problem

Hi,

I think you don't have enough shared memory.
Increase your kernel parameters for the shared memory
Eric Antunes
Honored Contributor

Re: Clone database problem

Hi Pinki,

Please post the following command output:

$ll /u1/oradata/siges

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
Steven E. Protter
Exalted Contributor

Re: Clone database problem

Shalom Pinki,

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Eric Antunes
Honored Contributor

Re: Clone database problem

Hi again,

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
Each and every day is a good day to learn.
Simon Wickham_6
Regular Advisor

Re: Clone database problem

Hi,

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
Eric Antunes
Honored Contributor

Re: Clone database problem

Simon,

"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
Each and every day is a good day to learn.
Yogeeraj_1
Honored Contributor

Re: Clone database problem

hi,

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Pinki Meggi
Frequent Advisor

Re: Clone database problem

hi,

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
Eric Antunes
Honored Contributor
Solution

Re: Clone database problem

Hi Pinky,

The 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
Each and every day is a good day to learn.
Eric Antunes
Honored Contributor

Re: Clone database problem

Also, try this:

$cd /
$chmod -R u1
Each and every day is a good day to learn.
Eric Antunes
Honored Contributor

Re: Clone database problem

Sorry, here the right "chmod" command:

$cd /
$chmod -R u+rwx u1
Each and every day is a good day to learn.