Metadata repository and version control
As a DBA, I'm always looking for proactive ways to allow me to be prepared in case of a disaster strike or if an emergency release rollback is required (I always love to use the "what if" methodology); and due to these reasons, having a metadata repository and version control of it is always useful.
But, how can I easily create it? Easy; first do a full backup of your database using Data Pump as shown in the following command:
$ expdp fcomunoz/alvarez@pdborcl content=metadata_only full=y directory=datapump dumpfile=metadata_06192013.dmp
Note
If you want to create a repository only for objects such as procedures, packages, triggers, and so on, all you need to do is add the parameter INCLUDE=<procedure,package,trigger,…> ...
Get Oracle Database 12c Backup and Recovery Survival Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
