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.
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’)”
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