Tuesday, October 20, 2020
    Home Oracle Troubleshooting How can perform Expdp with consistent=y

    How can perform Expdp with consistent=y

    Hi Friends,

    After introducing DATAPUMP, there is a lot of confusion occurring. One of that confusion is how to perform export using EXPDP (datapump) like exp consistent=y.

    - Advertisement -

    Because in export when we are using consistent=y, there would be every chance to get ORA-01555 snapshot too old error in live database. In 24*7 running database active DML is being performed by any end-users while we are performing export of the database. Means if we won’t take consistent image of database in export backup then we should need to specify exp consistent=y command.

    Now onwards, in Oracle 10g new feature Datapump is introduced. There is no parameter called “consistent” available in EXPDP command of datapump. Because the new concept is also developed called “flashback”. Using this flashback parameter we can perform the same as consistent=y withe expdp utility for taking our logical backup.

    Command for performing as follows.

    expdp system/passwd directory=flsh dumpfile=user001_2.dmp logfile =user001_2.log schemas=usr001 flashback_time=”TO_TIMESTAMP (TO_CHAR (SYSDATE, ‘YYYY-MM-DD HH24:MI:SS’), ‘YYYY-MM-DD HH24:MI:SS’)”

    - Advertisement -

    Using the above parameter flashback_time and setting up the present time (time of taking expdp), it will act just as exp with consistent=y.

    Dbametrix is one of the leading remote Oracle DBA support service provider and we offer remote database administration at a very low cost. A client of Dbametrix can able to put trust in the company because Dbametrix delivers a cost-effective remote dba plan using Service Level Agreement SLA and response time matrix. Due to this reason every client gets maximum satisfaction from our deliverable.

    Wish you all the best,

    Thanks and regards,

    Remote DBA service team

    - Advertisement -
    - Advertisment -

    Most Popular

    oracle 19c new features – Automatic Indexing

    A major Oracle 19c autonomous database new Feature automatic indexing using DBMS_AUTO_INDEX some details and how to article.

    Differences Raw Device, ASM Device and CFS

    The article explains basic differences of ASM device, raw device and Oracle cluster file system cfs with fundamentals

    What is a Database Administrator?

    The blog post explains what is the work of database administrator called DBA in database domain and what is the importance.

    Top Reasons to Implement Remote Database Monitoring

    The blog post explains top three reasons and ideas to get remote monitoring services from outer support company.

    Recent Comments