![]() ![]() ![]() While definitely not the best way to do things, sometimes people forget that they're using ASM and want to create datafiles with static names. In order to make matters more fun, let's say that the database has some datafiles that weren't created using Oracle's "Oracle Managed Files" (OMF) methodology. In most cases, you'll be performing point in time recovery on databases, and more information on that topic can be found in Oracle's documentation at. Because this exercise was a planned operation, we used cold backups of the database to perform the restore. We'll take a backup, destroy the diskgroups entirely, and restore TESTER to diskgroups named +NEWDATA and +NEWRECO. In the example for this post, we'll use a database named TESTER that stores files in ASM diskgroups named +DATA2 and +RECO2. One of the goals of the rebuild was to consolidate all of the databases into a single set of ASM diskgroups to better allow for future growth. In the case of this rack, there were several databases across multiple ASM diskgroups. As DBAs, we back up databases all the time, but the restores are performed much less frequently. I had the pleasure of rebuilding an Exadata rack for a customer a while back, and it provided a pretty good refresher in backup and recovery for me.
0 Comments
Leave a Reply. |