Re: redoORCLOl.log

Utilisateur1 wrote:

> create database "ORCL"
> maxinstances 8
> maxiogfiles 32
> character set "WE8DEC"
> national character set "WE8DEC"
> datafile .
> ./mnt/D/u02/oradata/ORCL/system01.dbf size 80M
>
> /mnt/D/u02oradata/ORCL/redoORCLOl.log' size 500k,
> /mnt/D/u03/oradata/ORCL/redoORCL02.1og' size 500k,
> /mnt/D/u04/oradata/ORCL/redoORCL03.1og' size 500k;
>
> . A quoi correspond l'instruction
> « datafile7mnt/D/u02/oradata/ORCL/system01.dbf size 80M » ?
>
> . Quel est l'intérêt d'avoir 3 fichiers REDO ?

My French is no longer passable but the SYSTEM tablespace should be 150-350M depending on what you are doing and the version.

I would also suggest you examine the following questions:

1. Why maxinstances 8? Is the intention OP or RAC?
2. maxiogfiles should be MAXLOGFILES
3. You would be better served with two or more log file groups.

Something such as:

CREATE DATABASE orcl
LOGFILE GROUP 1 ('/mnt/D/u03oradata/orcl/redoorclla.log' ,

'/mnt/d/u03oradata/orcl/redoorcl2a.log') size 5M reuse,

                  GROUP 2 ('/mnt/d/u04oradata/orcl/redoorcllb.log' ',

'/mnt/d/u04oradata/orcl/redoorcl2b.log' ') size 5M reuse DATAFILE 'mnt/d/u02/oradata/orcl/system01.dbf'

   SIZE 250M
........;

And since your install is on UNIX I'd suggest staying away from mixed case.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)