topic Re: Clone database problem in Operating System - HP-UX

Clone database problem

Pinki Meggi — Thu, 02 Feb 2006 05:11:29 GMT

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

Re: Clone database problem

Luk Vandenbussche — Thu, 02 Feb 2006 05:22:38 GMT

Hi,

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

Re: Clone database problem

Eric Antunes — Thu, 02 Feb 2006 05:27:20 GMT

Hi Pinki,

Please post the following command output:

$ll /u1/oradata/siges

Best Regards,

Eric Antunes

Re: Clone database problem

Steven E. Protter — Thu, 02 Feb 2006 05:48:37 GMT

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

Re: Clone database problem

Eric Antunes — Thu, 02 Feb 2006 05:55:32 GMT

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

Re: Clone database problem

Simon Wickham_6 — Thu, 02 Feb 2006 05:58:50 GMT

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

Re: Clone database problem

Eric Antunes — Thu, 02 Feb 2006 06:23:46 GMT

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

Re: Clone database problem

Yogeeraj_1 — Thu, 02 Feb 2006 08:14:33 GMT

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

Re: Clone database problem

Pinki Meggi — Thu, 02 Feb 2006 08:52:07 GMT

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

Re: Clone database problem

Eric Antunes — Thu, 02 Feb 2006 09:29:22 GMT

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

Re: Clone database problem

Eric Antunes — Thu, 02 Feb 2006 09:30:37 GMT

Also, try this:

$cd /
$chmod -R u1

Re: Clone database problem

Eric Antunes — Thu, 02 Feb 2006 09:31:44 GMT

Sorry, here the right "chmod" command:

$cd /
$chmod -R u+rwx u1