• DBA Life - DBA Rants

    Fixing Development Mistakes from the Command Line with Delphix TimeFlow

    How many times have you had a developer come to you and say, “I just did a bad thing in the database.  Can you recover from what I just did?” With Delphix virtualization, we make this pretty easy to address from the user interface with a simple slider to recover from a PIT before the catastrophic mistake, but today, we’ll discuss how to do this from the command line 1.Log into the Delphix engine as an admin user. ssh delphix_admin@<yourengine> delphix > timeflow delphix timeflow > ls 2. Depending on the platform that you’re using, (in our example, we’ll use…

  • DBA Life - DBA Rants

    Best Practices with Enterprise Manager 13c

    Since the introduction of Enterprise Manager 12c, folks have been asking for a list of best practices.  I know a lot of you have been waiting for this post! 1.Use previously deployed, older hardware for your Enterprise Manager deployment on 13c. Enterprise Manager is a simple, single service system.  There is no need for adequate resources and ability to scale.  In fact, I’ll soon be posting on my blog about building an EM13c on a Raspberry Pi 3. 2. Please feel free to add new schemas, objects and ETL’s to the Oracle Management Repository, (OMR.) This database doesn’t have enough…