Moving ASM database files to new diskgroup on a physical standby
I want to move some datafiles to different diskgroups on a Data Guard standby. Just wanted some feedback on whether these steps would work:
- Cancel recovery on the standby to stop log applies.
- Use RMAN to copy the files to a new diskgroup
- Use RMAN set the newname, and switch the datafile
- Drop the old ASM datafile
- Restart recovery on the standby
I'm assuming the datafiles do not need to be offlined, and recovered since the database is in a mount state.
Thanks,
Charlie