Transportable tablespace issues
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Transportable tablespace issues

Hybrid View

  1. #1
    Join Date
    Jan 2003
    Posts
    141

    Transportable tablespace issues

    I am doing TTS from TRU64 (Bid endian format)to HPUX (little endian format).... having issues during impdp

    steps at source:
    ---------------

    begin
    sys.dbms_tts.transport_set_check('TESTTBLSPC',TRUE);
    end;
    /
    ....repeated for two tablespaces

    alter tablespace TESTTBLSPC read only; - did for both tablespaces

    expdp userid=userid/pwd DIRECTORY=DATA_PUMP_DIR DUMPFILE=TTS.dmp LOGFILE=TTS.log TRANSPORT_TABLESPACES=TESTTBLSPC,TESTTBLSPCS TRANSPORT_FULL_CHECK=y


    steps at target:
    --------------
    ftped the dumpfile and the two datafiles to the respective location /dbfiles/oradata/DBNAME and the target database is up and running

    The export contains two tablespaces with each one datafile... i am trying to import one tablespace

    impdp userid=ramesh/ramesh DIRECTORY=DATA_PUMP_DIR DUMPFILE=TTS.dmp LOGFILE=TTSimp.log TRANSPORT_DATAFILES=’/dbfiles/oradata/DBNAME/testtblspc.dbf’ KEEP_MASTER=y

    error:
    ORA-39123: Data Pump transportable tablespace job aborted
    ORA-01565: error in identifying file '/dbfiles/oradata/DBNAME/testtblspc.dbf'
    ORA-27037: unable to obtain file status
    HPUX-ia64 Error: 2: No such file or directory
    Additional information: 3

    Job "USERID"."SYS_IMPORT_TRANSPORTABLE_02" stopped due to fatal error at 16:43:24

    1.DOES THE MOUNT POINT NAME ON THE TARGET HAS TO BE THE SAME AS SOURCE ?
    2. INSTEAD OF DOING ONE DATAFILE AT A TIME FOR EACH TABLESPACE.. CAN I DO MULITPLE TABLESPACES USING TRANSPORTABLE_TABLESPACES = TABLESPACENAME.dbf, TABLESPACENAME2.dbf?


    Many Thanks,
    Last edited by castlerock; 12-02-2009 at 10:09 PM.

  2. #2
    Join Date
    May 2009
    Posts
    32
    I think for transfer of tablespace's from one endian format to another endian format you must use RMAN Convert command either on the source or target systems. Query v$transportable_platform to get the target platform name.

    Bring the tablespace to read only mode

    on the source platform
    Example:
    rman>convert tablespace 'SAMPLE'
    to platform='AIX Based(64 bit)'
    db_file_name_convert='/u01/oradata/index01.dbf','/usr/tmp';

    copy the file to target and import the metadata and bring the tablespace online.

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