Problem in importing full database daily
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Problem in importing full database daily

  1. #1
    Join Date
    Jul 2008
    Posts
    13

    Problem in importing full database daily

    Hi,

    I have to import the full export.dmp of a database to another database every day. How to import it so that it takes less time. My databases both are on windows and my version of oracle is 10g.

    Please forward me some tips or scripts.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    I get you are running some kind of exp/imp based replication... exp/imp wasn't designed as a replication tool.

    You have at least three main avenues here...
    1- Fine tune your exp/imp strategy. You posted no specifics so nobody can actually help you.
    2- Try expdp/impdp... you are on 10g! why aren't you using 10g features?
    3- Research replication and do it the right way.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Dec 2007
    Posts
    82
    there are many ways to keep one database to up to date if they both are similar in structure, like applying redo entries from source database to target database to make both are sync
    or use expdp and impdp and rather importing entire db, one can try to import no-system schemas which are only important or even one can think of transportable tablespaces.
    Cheers,
    /MR

  4. #4
    Join Date
    Jul 2008
    Posts
    13
    Actually I have to exp from a databse A(production) and imp tht exp.dmp to datbase B(prod locally). It should be done every day and both are in 10g version. How to use Impdp as they are on different servers and location.

    Plz give me some tips.

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    That's easy money, easier than doing exp-ftp-imp -providing you have a good pipe in between the two locations.
    When you work with expdp/impdp to move data to a remote host you move the data over a DBLink -research "network mode".
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  6. #6
    Join Date
    Jul 2008
    Posts
    13
    They dont need Impdp they want only Imp to be done, I dont no Why?.

    When I am importing it is giving the following error:

    Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

    Export file created by EXPORT:V10.02.01 via conventional path
    import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
    IMP-00017: following statement failed with ORACLE error 6550:
    "BEGIN "
    "dbms_server_alert.set_threshold(2104,dbms_server_alert.operator_GT,'1200',d"
    "bms_server_alert.operator_NONE,'',1,3,'asiprod',dbms_server_alert.object_ty"
    "pe_SYSTEM,'');"
    "COMMIT; END;"
    IMP-00003: ORACLE error 6550 encountered
    ORA-06550: line 2, column 93:
    PLS-00302: component 'OPERATOR_NONE' must be declared
    ORA-06550: line 2, column 1:
    PL/SQL: Statement ignored
    IMP-00017: following statement failed with ORACLE error 6550:
    "BEGIN "
    "dbms_server_alert.set_threshold(2018,dbms_server_alert.operator_GE,'100',db"
    "ms_server_alert.operator_NONE,'',1,2,'asiprod',dbms_server_alert.object_typ"
    "e_SYSTEM,'');"
    "COMMIT; END;"
    IMP-00003: ORACLE error 6550 encountered
    ORA-06550: line 2, column 92:
    PLS-00302: component 'OPERATOR_NONE' must be declared
    ORA-06550: line 2, column 1:
    PL/SQL: Statement ignored
    IMP-00017: following statement failed with ORACLE error 6550:
    "BEGIN "
    "dbms_server_alert.set_threshold(1000,dbms_server_alert.operator_GT,'10',dbm"
    "s_server_alert.operator_NONE,'',1,1,'asiprod',dbms_server_alert.object_type"
    "_EVENT_CLASS,'Administrative');"
    "COMMIT; END;"
    IMP-00003: ORACLE error 6550 encountered
    ORA-06550: line 2, column 91:
    PLS-00302: component 'OPERATOR_NONE' must be declared
    ORA-06550: line 2, column 1:
    PL/SQL: Statement ignored


    What I have to do for this type of error ?

  7. #7
    Join Date
    Nov 2001
    Posts
    335
    Are you doing full import? Can you do user level import ? I think this will take of the errors.
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  8. #8
    Join Date
    Jul 2008
    Posts
    13
    I am doing the full import ;

    imp system/pwd@dbname file=exp.dmp full=y log=imp.log commit=n ignore=y;

    and i even tried for

    imp system/pwd@dbname file=exp.dmp fromuser=system touser=system log=imp.log commit=n ignore=y;

    and also
    imp system/pwd@dbname file=exp.dmp fromuser= username touser=username log=imp.log commit=n ignore=y;

    for all of the above I am getting the same error.

    Wht is the problem can u please guide me?

  9. #9
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    may I ask why in the world are you attempting to import "system" schema?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  10. #10
    Join Date
    Jul 2008
    Posts
    13
    I want to make full import thats the reason, is it not correct? Can u scrap syntax for full import so that I can use.

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