Add a new database control file

From: David YEUNG <dyeung_at_ust.hk>
Date: Mon, 09 Apr 2001 10:54:09 +0800
Message-ID: <3AD12451.B6E9D056@ust.hk>

Can someone tell how to add a new database control file on a different disk? I've tried to create a backup control file using the SQL:

alter database backup controlfile to '/disk1/new_ctrl_file.ctl'

then I modify my 'init.ora' file by appending the new control file name '/disk1/new_ctrl_file.ctl' to the 'control_files' parameter, and restart the database. The database fails to open and complains that the control files are inconsistent between the original one and the new one. Anyone kwow how to resolve this.

Thanks

david Received on Sun Apr 08 2001 - 21:54:09 CDT