DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: import failed

  1. #1
    Join Date
    Dec 2000
    Posts
    21
    All,

    My full database import failed due to the following messages:
    IMP-00058: Oracle error 3113 encounted
    ORA-03113: end of file on communication channel
    IMP-00058: Oracle error 1041 encounted
    ORA-01041: internal error, hostdef extension doesn't exist
    After the import failure, I found my database was done. I started up my database, then ran the full import again, but it failed and the database was shutdown again. Please help me solve the problem. It is a test database 8.0.6 on AIX.


    I want to drop two tablespaces and recreate them with bigger database files. I will follow the following steps:
    1. Do a full database export(exp system/passwd file=xxx full=y compress=y log=xxx)
    2. Take the tablespaces offline, then drop them.
    3. Delete all datafiles related to the tbs.
    4. Recreate them.
    5. Do a full import.
    If step 5 failed for any reasons and can be fixed, what is the best solution to get my PROD database back to normal operation? It is running no archive mode on AIX.






  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Almost sounds like an Oracle bug.
    Jeff Hunter

  3. #3
    Join Date
    Nov 2000
    Posts
    212
    look into Oracle logs: error with symbolic number "1331" is kind of "blue-screen" analog in Windows NT.
    Best thing is to push Oracle here.

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    What is the export file size?

  5. #5
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    Check on Metalink for this error. There are many known reasons for this error.
    -
    If I understand you correctly, if you want larger files for the tablespaces, why not just resize them!!??

  6. #6
    Join Date
    Jan 2001
    Posts
    191
    If what you want is to create bigger datafiles, there is no need to drop it. Just resize the datafile:
    ALTER DATABASE DATAFILE 'filename'
    RESIZE 4000M;



  7. #7
    Join Date
    Dec 2000
    Posts
    21
    Halo & xyz2000:
    I want to increase the size of datafiles, and reduce # of datafiles. I am not able to access to Metalink because we don't have oracle support.

    Tamilselvan:
    The export file size is about 400G.

    Marist89:
    What is a solution for this oracle bug?

    LND:
    I looked at the Oracle8 error book, but couldn't find any actions. I ran it from x-station.


  8. #8
    Join Date
    Nov 2000
    Posts
    212
    3113 is Oracle bug which terminates current session. Hopefully not the whole database.

    Solutions usually are some workarround or patching Oracle.

    Depending on Oracle version, you can manipulate datafile size but not delete it.
    To delete datafile you can try to move tables to another tablespace (with 'alter table move' clause).
    I would generate a script for all tables, execute it to move tables to another tablespace and ... leave them in new tablespace with correct datafiles.


  9. #9
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    I think your OS is 32 bit.

    If the export file is a single 400GB, then the import will fail.
    You need to create multiple export files. The new export parameter FILESIZE can be used to determine the .dmp size.

  10. #10
    Join Date
    Jul 2000
    Posts
    68
    If the export file is seperated into several smaller files, how to import the data? How to choose the file that is used by imp?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width