Oracle database: On demand backup
This method is useful for cases where an immediate backup/export is required; for example, when Customer Support requests a copy of your database for troubleshooting.
To back up the database tables, IT Analytics provides an Oracle data pump utility, exdp. This utility exports the user portal, which contains the database tables. To create a full export file of all database objects, refer to the following section.
See Oracle database: Export backups.
For optimum performance, use this utility rather than your favorite backup solution's backup utility (for example, rman) because most backup solutions require archive logging. This setting is not enabled or exposed because archive logging can have a significant, negative impact on performance.
You will import this export in the event that you need to:
Restore the entire Reporting Database.
Retrieve a data table that's been corrupted or accidentally deleted. Simply drop the portal user then import the export.