Home » RDBMS Server » Server Utilities » Problems with import  () 1 Vote
Problems with import [message #244032] Mon, 11 June 2007 06:59 Go to next message
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
Re: Problems with import [message #244033 is a reply to message #244032] Mon, 11 June 2007 07:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OS?
List Oracle/database files you have on your external disk.

Regards
Michel
Re: Problems with import [message #244035 is a reply to message #244032] Mon, 11 June 2007 07:04 Go to previous messageGo to next message
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.
icon2.gif  Re: Problems with import [message #244046 is a reply to message #244032] Mon, 11 June 2007 08:05 Go to previous messageGo to next message
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
Re: Problems with import [message #244057 is a reply to message #244046] Mon, 11 June 2007 08:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
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
Re: Problems with import [message #244058 is a reply to message #244032] Mon, 11 June 2007 08:41 Go to previous messageGo to next message
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
Re: Problems with import [message #244063 is a reply to message #244032] Mon, 11 June 2007 08:53 Go to previous messageGo to next message
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
Re: Problems with import [message #244066 is a reply to message #244063] Mon, 11 June 2007 09:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are source and target OS the same ones?

Regards
Michel
Re: Problems with import [message #244071 is a reply to message #244032] Mon, 11 June 2007 09:21 Go to previous messageGo to next message
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
Re: Problems with import [message #244074 is a reply to message #244071] Mon, 11 June 2007 09:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It means same file system structure, same OS block size, same...

Regards
Michel
Re: Problems with import [message #244224 is a reply to message #244032] Tue, 12 June 2007 01:34 Go to previous messageGo to next message
twadorno
Messages: 8
Registered: June 2007
Junior Member
Lets assume, they are the same. What's to do then?
Re: Problems with import [message #244236 is a reply to message #244224] Tue, 12 June 2007 02:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
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

Re: Problems with import [message #244525 is a reply to message #244032] Wed, 13 June 2007 03:24 Go to previous messageGo to next message
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 pure horror.

So I'm glad about every good information!

Regadrs
Re: Problems with import [message #244529 is a reply to message #244525] Wed, 13 June 2007 04:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
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
Re: Problems with import [message #244895 is a reply to message #244032] Thu, 14 June 2007 09:05 Go to previous messageGo to next message
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

The Wiesengrund
  • Attachment: files.zip
    (Size: 1.81KB, Downloaded 175 times)
Re: Problems with import [message #244930 is a reply to message #244895] Thu, 14 June 2007 11:28 Go to previous message
Michel Cadot
Messages: 64140
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
Previous Topic: SQL Loader - load a file with a fixed value passed as parameter
Next Topic: export/import question
Goto Forum:
  


Current Time: Fri Dec 09 08:03:59 CST 2016

Total time taken to generate the page: 0.13372 seconds