Here is one of my posts from last year’s IOUG Tip Booklet titled 10 Questions (and answers) about RMAN Stored Scripts. Enjoy!
Today, most Oracle shops are using RMAN for backups. Why? Because it powerful, resilient and not very difficult to learn. It is an excellent tool to have in your DBA toolbox. Let’s add an additional tool to that toolbox that will help to make your job as a DBA a bit easier, RMAN stored scripts.
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.
© 2024 Darryl Hickson DBA
Theme by Anders Noren — Up ↑
RSS - Posts