Re: Increasing Redo Log Files

TAUPIN Olivier wrote:
>
> Can somebody explain me who I can increase the size of my redo log files.
>
> Oracle 7.1.6 on HPuX9.

Size of Redo log files cannot be simply enlarged with a sql statement. You must drop the old and re-create the new ones.

Steps will be:

1. startup the database in restricted mode;
2. enforce log switch;
3. archive all online redo logs;
4. create the new redo log files with larger size (if there are only two groups of redo logs in the database.)
5. drop the old redo logs;

for each redo logs, you can repeat steps 4 and 5.

-- 
Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Assistant MIS Manager                Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049