Re: [Q]Online redo log files

earvin_at_omega.uta.edu (Earvin C. Lim) writes:

>Does anyone know where is the size of the online redo log files defined?
>and how can we change the size?
>We are running Oracle 7.3.2

Well, the initial sizes are specified at database creation. Additional logs can be created using alter database add logfile (or using a GUI tool, if that's your fancy).

The following script will tell you what logfiles you currently have, and their pertinent info:

col member heading 'Redo Log Name' format a45 col bytes heading 'Bytes' format 99,999,999 col members heading '# Members' format 999

SELECT
  member, bytes, members, a.status
FROM
  v$log a, v$logfile b
WHERE
  a.group# = b.group#
ORDER BY
  member
/

Don't resize the logfiles - just drop the ones you don't want, and recreate them with the sizes you do want. Remember you have to have at least 2 online. You can drop the logfile when it is Inactive (as shown by the above query).

alter database drop logfile group 1;
alter database drop logfile group 2;
alter database add logfile group 1 '/u01/oradata/redo_SID_01a.log' size 3M; alter database add logfile group 2 '/u01/oradata/redo_SID_02a.log' size 3M;

-- 
/(o\ Nathan D. Hughes
\o)/ nhughes_at_umich.edu