Category: 2016 (Page 2 of 2)

Oracle Active Duplication from ASM to disk

Last week, I had to refresh a training database with data from production. In order to do this, I used Active Database Duplication from ASM to disk. This feature, introduced in 11g, allows you to duplicate a database from a live database instead of from the RMAN backup.

The datafiles for this database are on a filesystem. We are in the process of migrating the databases to new servers and moving them to ASM. I wanted to reduce the RMAN impact on production by using one of the test databases that are running on ASM as the source for the duplication. This meant moving the datafiles of the test database from ASM to disk.

Continue reading

Welcome to my site!

Thank you for visiting my blog. I am Darryl Hickson, I have been a Database Administrator for almost 20  years, primarily focusing on Oracle with some SQL Server mixed in for variety.  You can learn more about me on my About Me page. The link is at the top of the page.

I am excited to share some of my technical knowledge with you on this site. Be sure to check in often or subscribe to my RSS feed. I hope to see you back soon.

-Darryl

Newer posts »

© 2024 Darryl Hickson DBA

Theme by Anders NorenUp ↑