Friday, August 14, 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 Autonomous JSON database

    The blog article explains about What is the Oracle autonomous JSON database, usage and how to get it from Oracle Cloud.

    nosql Security Vulnerabilities

    Article explain in detail of NoSQL database security challenges and how to find out Vulnerabilities.

    SQL vs noSQL Which is better

    Blog post explains basic differences of sql and nosql and when it is better to use nosql for getting best performance and security.

    Performance of noSQL Database

    The article shows reasons of performance of nosql downgrading or not.

    Recent Comments