ctl
control_files /u01/app/oracle/oradata/control02.ctl
control_files /u01/app/oracle/oradata/control03.ctl
SQL> show parameter control_files
NAME TYPE VALUE
---------------- ----------- ------------------------------
control_files string /u01/app/oracle/oradata/contro
l01.ctl, /u01/app/orac le/orad
ata/control02.ctl, /u01/app/or
acle/oradata/control03.ctl
SQL> alter system set control_files =
2 '/u02/oradata/control01.ctl',
3 '/u03/oradata/control02.ctl',
4 '/u04/oradata/control03.ctl'
5 scope = spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> ! mv /u01/app/oracle/oradata/control01.ctl /u02/oradata
SQL> ! mv /u01/app/oracle/oradata/control02.ctl /u03/oradata
SQL> ! mv /u01/app/oracle/oradata/control03.ctl /u04/oradata
SQL> startup
ORACLE instance started.
Chapter 4: Physical Database Layouts and Storage Management 97
Total System Global Area 422670336 bytes
Fixed Size 1299112 bytes
Variable Size 230690136 bytes
Database Buffers 184549376 bytes
Redo Buffers 6131712 bytes
Database mounted.
Database opened.
SQL> select name, value from v$spparameter
2 where name = 'control_files';
NAME VALUE
--------------- --------------------------------------------------
control_files /u02/oradata/control01.ctl
control_files /u03/oradata/control02.ctl
control_files /u04/oradata/control03.ctl
SQL> show parameter control_files
NAME TYPE VALUE
---------------- ----------- ------------------------------
control_files string /u02/oradata/control01.
Pages:
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194