OraFAQ Forum: Server Utilities » Problems with import

Home » RDBMS Server » Server Utilities » Problems with import (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problems with import [message #244032]

Mon, 11 June 2007 06:59

twadorno
Messages: 8
Registered: June 2007

Junior Member

Dear Forum,

I have serious problems. I'm a .net-developer and not an admin of oracle.
My boss gave me an external harddisk with some oracle-files and the order, to "copy this oracle files to a new computer". It is no chance to make a good backup because oracle is not running.

I tried with several methods and several OS to connect the DB-files with my oracle 10.0.1 (seems to be the version of my files, too) - but always I failed.
Connection is not possible.
It is soooo easy with mySQL and MSSQL - but with Oracle it seems to be an horror.

Can anybody help me? I heard, that maybe the problem is not solveable at all. This would be a catastrophy for me and my boss.

So: I'm hoping for help!

Greetings and X

The Wiesengrund

Report message to a moderator

Re: Problems with import [message #244033 is a reply to message #244032]

Mon, 11 June 2007 07:02

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

OS?
List Oracle/database files you have on your external disk.

Regards
Michel

Report message to a moderator

Re: Problems with import [message #244035 is a reply to message #244032]

Mon, 11 June 2007 07:04

sujeetsaxena16
Messages: 9
Registered: May 2007
Location: mumbai

Junior Member

just go into the start-cmd
and write imp file=filename log=lognaem full=y rows=y ignore=y

when u run this script its ask to u about userid just type /as sysdba
just try with this method and send the report.

Report message to a moderator

Re: Problems with import [message #244046 is a reply to message #244032]

Mon, 11 June 2007 08:05

rajabaskar
Messages: 13
Registered: June 2007
Location: chennai

Junior Member

hi

imp username/password file=path.dmp log=path.log full=y buffer=10485667 commit=y grants=n

Report message to a moderator

Re: Problems with import [message #244057 is a reply to message #244046]

Mon, 11 June 2007 08:39

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Sujeet, Rajabaskar,

Who said that the files he got is an Oracle export/import dump file?

Regards
Michel

Report message to a moderator

Re: Problems with import [message #244058 is a reply to message #244032]

Mon, 11 June 2007 08:41

twadorno
Messages: 8
Registered: June 2007

Junior Member

Hi

thanks for the infos.

but a

imp username/password file=path.dmp log=path.log full=y buffer=10485667 commit=y grants=n

is simple, if you have a *.dmp file.

But I have no DMP-File. This is my problem.

A person in my office made a COPY OF THE DATBASE on an external harddisk.

He called this "backup".

Then the computer was stopped - and then it is broken. This man said "We have a backup, here it is" - and he does not understand, that he must export the files - and not copy the database.

And I must now rescue the Datas and transfer them to an other Database.

Know you understand my problem?

Greetings

Der Wiesengrund

Report message to a moderator

Re: Problems with import [message #244063 is a reply to message #244032]

Mon, 11 June 2007 08:53

twadorno
Messages: 8
Registered: June 2007

Junior Member

Thanks, Mr. Cardot,

to make it more precise:

I have file-copy database backup (*.ctl, *.dbf, and .ora file) and
need to connect these files to working server.

I have oracle 10.2.0.1.0, .ora file has line "compatible=10.1.0.4.0"

I copy data files under oradata/NAME and
.ora file into dbs directory.

and next:

ORACLE_SID=PROPERSID;
export ORACLE_SID;
sqlplus /nolog
connect user/pass as sysdba
startup mount

and result:
ORA-27047 unable to read the header block of file
(on Windows I had ORA-27047 + OSD-04001 wrong block size)

So: whats wrong Sad

Sad

Report message to a moderator

Re: Problems with import [message #244066 is a reply to message #244063]

Mon, 11 June 2007 09:06

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Are source and target OS the same ones?

Regards
Michel

Report message to a moderator

Re: Problems with import [message #244071 is a reply to message #244032]

Mon, 11 June 2007 09:21

twadorno
Messages: 8
Registered: June 2007

Junior Member

Can be

Wink

I have in the moment no idea, if the old version was linux or unix or windows.

But i can make, that they are the same. (maybe by trial and error...)

So it is important to know, if "same version" means: exactly the same. (if old version in Suse, if then Debian is possible)

But for first step lets assume: both are the same.

Thanks

Report message to a moderator

Re: Problems with import [message #244074 is a reply to message #244071]

Mon, 11 June 2007 09:31

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It means same file system structure, same OS block size, same...

Regards
Michel

Report message to a moderator

Re: Problems with import [message #244224 is a reply to message #244032]

Tue, 12 June 2007 01:34

twadorno
Messages: 8
Registered: June 2007

Junior Member

Lets assume, they are the same. What's to do then?

Report message to a moderator

Re: Problems with import [message #244236 is a reply to message #244224]

Tue, 12 June 2007 02:07

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If they were, it's unlikely you got "ORA-27047 unable to read the header block of file".
The steps depends on the environment, if you don't know or want to tell us what it is, You're On Your Own (YOYO).

Regards
Michel

Report message to a moderator

Re: Problems with import [message #244525 is a reply to message #244032]

Wed, 13 June 2007 03:24

twadorno
Messages: 8
Registered: June 2007

Junior Member

Hi,

the problem is for me quite serious. So it is not a question, that I want not to give the information.
I'm searching, if it is possible - and how.
Then I must check, if i can do it - or if i need some support.
And then I must start to figure out, what OS we have, what oracle version and so on.

But this can take weeks -because I have to do it by trial and error Sad

Sad

pure horror.

So I'm glad about every good information!

Regadrs

Report message to a moderator

Re: Problems with import [message #244529 is a reply to message #244525]

Wed, 13 June 2007 04:01

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Use an hexa decimal editor and post the first 256 bytes in hexa and alphanumeric formats ("od -x" "od -c" in Unix).
Put a list of files you have as I asked in my first post (attach it as txt file).

Regards
Michel

Report message to a moderator

Re: Problems with import [message #244895 is a reply to message #244032]

Thu, 14 June 2007 09:05

twadorno
Messages: 8
Registered: June 2007

Junior Member

Hi

I'm impressed, that someone seems able to help me!

Great

Here are the files:

Result of command

od -t x1 -A x -N 256 <filename>

only first and last arc_...log from set of files

I'm looking forward to your next steps Wink

Wink

The Wiesengrund

Attachment: files.zip
(Size: 1.81KB, Downloaded 1176 times)

Report message to a moderator

Re: Problems with import [message #244930 is a reply to message #244895]

Thu, 14 June 2007 11:28

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I can say you that these files come from a Big Endian platform (that is neither Windows nor Linux) with 8K block size.
It can't be restored on another platform type than the original one.

Regards
Michel

Report message to a moderator

Previous Topic:	SQL Loader - load a file with a fixed value passed as parameter
Next Topic:	export/import question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 00:35:59 CDT 2024