Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Online redundancy migration for ASM diskgroups
Redundancy upgrade for ASM diskgroups can only be done through downtimes. Best tip seems to be to restore the database on a higher redundancy diskgroup. But as disk loss and disk resync does already work with normal or high redundancy diskgroups during the repair of disk failures, it does not seem to be that hard to just add a new failure group to a diskgroup, run the rebalance and so upgrade the redundancy in an online fashion.
The same applies for dropping failure groups to downgrade redundancy.
Comments
-
In 12c EE that can be done without downtime as datafiles can be moved online.
-
In 12c EE that can be done without downtime as datafiles can be moved online.
Good to know. Wasn't in touch with this 12c feature yet.
Yet another drawback of the backup/restore method next to the downtime are the space requirements: imagine you want to migrate from normal to high redundancy, so you are required to have 5 times the disk space available of the data you want to store. With huge DBs this might become and issue.