This content has been marked as final. Show 2 replies
Have you ever tried a Disaster Recovery Plan ?
As you know export is not a Backup and for all I know there's no way to make an "incremental" export so that you can import just the few more transactions you had on Production.
Instead, you may think to move to a real Backup solution as RMAN.
Put the Production Database in ARCHIVELOG mode so as to save all current transactions. Duplex your Archivelog (it's possible in Standard Edition) so that you don't loose them if a disk or server failure occurs and use RMAN for your Backup.
By that way you could Restore the Database and Recover the last transactions by applying the Archived Redolog files.
Please, find enclosed links about RMAN:
Hope this help.
these are all may give some downtime for the production DB.
So try to setup RAC or dataguard for high availability of the production.
Hope your database is running in archivelog mode, so configure RMAN backups at various levels,
Full, incremental, archivelog only ...
These backups will help for the fast recovery without data loss.