O'Reilly logo

Oracle Database 12c Backup and Recovery Survival Guide by Aman Sharma, Francisco Munoz Alvarez

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Data Pump flashback

When exporting data we can also use Data Pump with flashback to make a point-in-time export by using the parameter FLASHBACK_TIME assigning a timestamp to it, or FLASHBACK_SCN to assign a specific SCN, if using this option, the database will look for the SCN that most closely matches the specified time, and this SCN will be used to enable the Flashback utility and the export operation will be performed with the data that is consistent up to this SCN. In this scenario, we will export the data of the table EMPLOYEE from the schema TEST up to 30 minutes ago shown as follows:

$ expdp directory=datapump dumpfile=employee_flashback_06192013.dmp
flashback_time="to_timestamp('19-06-2013 14:30:00', 'dd-m
m-yyyy hh24:mi:ss')"

Some restrictions ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required