2 Node RAC to single instance standby - asymetrical disk groups
I have several 2 node rac databases on a exadata with asm - all 19c. There is only 1 data diskgroup ( 1 +DATA and 1 +RECO). There are other production databases on this same asm clustered host environment.
The standbys are all single node - and share a clustered asm instance with several other non-prod databases. There are 3 disk groups for data. The diskgroup used exclusively by the standby instances needs more space. I would like to move some files in the standby instance to another diskgroup but we use OMF.
is this supported? How can I handle the filename conversion since omf will use diskgroup name and I only want to migrate some tablespaces - worth of files - not every datafile.