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
When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.
This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.