How do I add/drop controlfiles while database is running?

[DeepDiverMom]

We need to do some file system re-arranging on our Unix system running Oracle 8.1.7.3. Our goal is to move our on-line redo log files and our conrol files from filesystems, FS-a and FS-b, to filesystems, FS-c and FS-d...While the database is up and running.

I successfully moved the on-line redo log files, but I cannot see any syntax in the ref. manuals to add control files (to FS-c and FS-d), then drop unwanted ones (from FS-a and FS-b) while the database is up and running. When I have moved control files in the past, I have done so with a Unix &quot;mv&quot;, then modified the control_files entry in the init<SID>.ora file. Is this the only way to make this change or can I, in fact, do what I want while the database is running?

Thanks.

 

[sybaseguru]

Yes I believe shutting down the database, using mv command to move an existing control file to a new location, modifying the init.ora file to reflect the new control.ctl location and restart of the database is the only option for now.

Sorry about the bad news

 

[DeepDiverMom]

Thanks, Guru. One thing I've learned on this forum it that if you say it, it's gospel; but I'd rather have bad news than wander in ignorance. Thanks again !

Becca

 

[DBAwhosaysNIE]

interesting ?

you definitely can't do it from Oracle per se w/o an instance restart. I'm trying to think if there's a dirty unix trick you might be able to do to the file handle(s) while it's running but nothing immediately comes to mind (may want to post this on a hardcore *nix board). FWIW it should literally take <2 min (depending on your instance/hardware) if you update init$SID.ora in advance (only read at startup). also, as long as you're looking at an instance bounce you may want to consider applying .4 (assuming it's available for your *nix). you can install 8.1.7.0.1 in another home, patch it up then update your $ORACLE_HOME before restarting. you'll have to rerun catalog/catproc (etc.) but as long as you have it up on the rack...