August 2017 – Page 7 – My Tech Blog

Fool proof way to restore a database using RMAN

June 4, 2018August 10, 2017 by mark

Oracle – Fool proof way to restore a database using RMAN Goal This method will ensure a clean restore from tape. Although this is designed to run from ASM to non-ASM, this method can be adapted from NON ASM as well. Solution Step 1. First gather the required information from the source database. This can … Read more

Oracle to Aurora using Data Migration Services (DMS)

August 13, 2017August 10, 2017 by mark

We are looking to migrate some customer data, however we don’t need all the data, but only a subset. The idea was to create a copy of the existing tables using a copy with the relevant rows, then create a series of triggers to keep them up-to-date with the main tables. It goes something like … Read more