HP UX B6941-90001 - Manual (Page 471)

Chapter 10 471
Tuning, Troubleshooting, Security, and Maintenance
System Maintenance
2. Shutdown the database
3. Move selected control file(s) to a directory on the other disk, for
example from disk /u01 to disk /u02:
mv /u01/oradata/openview/control03.ctl \
/u02/oradata/openview/control03.ctl
4. Modify the control file name(s) in:
$ORACLE_HOME/dbs/init${ORACLE_SID}.or a, for example,
from:
control_files = (/u01/oradata/openview/control01.ctl,
/u01/oradata/openview/control02.ctl,
/u01/oradata/openview/control03.ctl)
to the following:
control_files = (/u01/oradata/openview/control01.ctl,
/u01/oradata/openview/control02.ctl,
/u02/oradata/openview/control03.ctl)
5. Restart the database
• Create a second (or even third) set of mirrored, online redo logs on the
second (or third) disk. ITO installs Oracle in such a way that, by
default, it has three redo log groups, each containing one member.
The following example creates a second set of redo log files in the
directory;
/u02/oradata/openview . Modify the directory names
(and repeat the steps) as required:
1. Create the directories on the second disk, for example;
mkdir -p /u02/oradata/openview
chown oracle:dba /u02/oradata/openview
2. Do the following as user oracle in svrmgrl :
connect internal;
alter database add logfile member
‘/u02/oradata/openview/redo01.log’ to group 1;
alter database add logfile member
‘/u02/oradata/openview/redo02.log’ to group 2;
alter database add logfile member
‘/u02/oradata/openview/redo03.log’ to group 3;