| Howto move controlfile on 9i with SPfile ?? [message #60261] |
Tue, 27 January 2004 23:09  |
Henk
Messages: 3
Registered: August 2003
|
Junior Member |
|
|
Hello,
i want to move one of my three controlfiles to an other filesystem. in "old" Instances i have to change this in my init.ora file.
Where i must change it by running spfile? On Instance-Manager this parameter is locked.
thx for help!
Henk
|
|
|
|
| Closed : Re: Howto move controlfile on 9i with SPfile ?? [message #60263 is a reply to message #60261] |
Wed, 28 January 2004 00:34  |
Henk
Messages: 3
Registered: August 2003
|
Junior Member |
|
|
How to delete a controlfile when using an SPFile.
-------------------------------------------------
1. Use the 'alter system set' command to set the control_files parameter to
the appropariate value. You must be connected with SYSDBA privileges.
For example, a 'show parameters control_files' at the SQL prompt shows:
SQL> show parameters control_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /u01/oracle/oradata/V920/contr
ol01.ctl, /u02/oracle/oradata/
V920/control02.ctl, /u03/oracl
e/V920/control03.ctl
Now you want to delete controfile control03.ctl, so you have to reset the
control_files parameter as follows:
SQL> alter system set control_files = /u01/oracle/oradata/V920/control01.ctl,
/u02/oracle/oradata/V920/control02.ctl scope=spfile;
Note: When doing the alter, cannot set scope to 'both' or 'memory' because
the control_files parameter is static.
2. Shutdown the database.
3. Startup the database.
Now the 'show parameters control_files' command shows:
SQL> show parameters control_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /u01/oracle/oradata/V920/contr
ol01.ctl, /u02/oracle/oradata/
V920/control02.ctl
4. If desired, delete the controlfile from the O/S.
Note:152269.1
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
