i have 5 log groups in oracle 9.2.0. (running on win2k) my 3 log groups are all created under D: drive as i used oui to install my db. i had 16 hard disks,and the senior dba had asked me to move the 2 log groups to other hard disk. the configuration for my log groups (each w 3 mbrs) are as follows
I need to move log groups 2 & 3 to E: and F: respectively.
Q1: What are the necessary steps to move log groups & their data files + mbrs? (besides do full backup)
Q2: Do i have to change init.ora to indicate the new locations for my loggrp2 & loggrp3?
Q3: Any other considerations?
Any help is much appreciated