High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Moving ASM database files to new diskgroup on a physical standby

 Hi All;

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center