OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Erreur ORA-00313

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Erreur ORA-00313 [message #62665]

Sun, 08 August 2004 10:34

benhamida
Messages: 3
Registered: August 2004

Junior Member

ORA-00313 Echec d'ouverture des membres du groupe de journaux 3, Thread 1 (not open journal groupe 3)

ORA-00312: Journal en ligne 3 Theard 1 :'E:OracleOradataSHFORMDREDO01.LOG'

ORA-27048 : skgfifi: les informations d'en-tete du fichier ne sont pas valides (head information is not valid)

OSD-04004: En-tete de fichier incorrect (file head incorrect)

�

Help me!!!!!!!!!!!!

Report message to a moderator

Re: Erreur ORA-00313 [message #62667 is a reply to message #62665]

Sun, 08 August 2004 21:41

Maaher
Messages: 7065
Registered: December 2001

Senior Member

ORA-04004 MINVALUE must be less than MAXVALUE
*Cause: MINVALUE was specified to be greater than or equal to MAXVALUE.
*Action: Specify a MINVALUE that is less than MAXVALUE.

ORA-27048 skgfifi: file header information is invalid
*Cause: Possibly trying to use a non-database file as a database file.
*Action: Verify that file is a database file.

ORA-00313 open failed for members of log group string of thread string
*Cause: The online log cannot be opened. The file may not be in the expected location.
*Action: Specify the correct redo log file or make the log available,
          if necessary. Also, see the accompanying messages.

Looking at your messages, it seems that you have a corrupt file. Try to recover it or log an iTAR.

MHE

Report message to a moderator

Re: Erreur ORA-00313 [message #62684 is a reply to message #62667]

Mon, 09 August 2004 08:26

benhamida
Messages: 3
Registered: August 2004

Junior Member

les erreurs constates :-

Espace total actuellement affect� aux enregistrement CKPT PROCESS du fichier de contr�le (en octets) :0
Le fichier de contr�le doit �tre recr�e en ajustant le param�tre MAXINSTANCES de la commande CONTROLEFILE pour modifier le nombre maximal d�enregistrements CKPT PROGESS qui peuvent �tre stock�s

Espace total actuellement affect� aux enregistrement REDO THREAD du fichier de contr�le (en octets) :104
Le fichier de contr�le doit �tre recr�e en ajustant le param�tre MAXINSTANCES de la commande CONTROLEFILE pour modifier le nombre maximal d�enregistrements REDO THREAD qui peuvent �tre stock�s

Espace total actuellement affect� aux enregistrement REDO L
OG du fichier de contr�le (en octets) :216
Nombre maximal de groupes de fichiers de journalisation pouvant �tre cr��s pour la base de donn�es :32
Nombre maximal de membres pour chaqur groupe de fichiers de journalisation : 2
Le fichier de contr�le doit �tre recr�e en ajustant le param�tre MAXLOGFILES de la commande CONTROLEFILE pour modifier le nombre maximal du groupes de fichiers de journalisation.Le fichier de contr�le doi
t �tre recr�� en ajustant le param�tres MAXLOGMEMBRERS de la commande CREAT CONTROLEFILE pour modifier le nombre maximal de membres par groupe de fichiers de journalisations.

Espace total actuellement affect� aux enregistrement DATAFILE du fichier de contr�le (en octets) :1980
Le fichier de contr�le doit �tre recr�e en ajustant le param�tre MAXDATAFILES de la commande CREATE CONTROLEFILE pour modifier le nombre maximal d�enregistrement DATAFILE qui peuvent �tre stock�es

Espace total actuellement affect� aux enregistrement TABELSPACE du fichier de contr�le (en octets) :780

Le fichier de contr�le doit �tre recr�e en ajustant le param�tre MAXDATAFILES de la commande CREATE CONTROLEFILE pour modifier le nombre maximal d�enregistrement TABLESPACE qui peuvent �tre stock�es.

Espace total actuellement affect� aux enregistrement LOG
HISTORY du fichier de contr�le (en octets) :130680

Le fichier de contr�le doit �tre recr�e en ajustant le param�tre MAXHISTORY de la commande CREATE CONTROLEFILE pour modifier le nombre maximal d�enregistrement LOG HISTORY qui peuvent �tre stock�es.

LES ETAPES POUR RESOUDRE CE PROBLEME (Merci)

Report message to a moderator

English translation (babelfish) - ORA-00313 [message #62696 is a reply to message #62684]

Mon, 09 August 2004 22:01

Maaher
Messages: 7065
Registered: December 2001

Senior Member

the errors noted:
- Space total currently affected with recording CKPT PROCESS of the file of control (in bytes) the:0
controlfile must be recreated by adjusting parameter MAXINSTANCES of order
CONTROLEFILE to modify the maximum number of recordings CKPT PROGESS which can
be stored

Space total currently affected with recording REDO THREAD of the controlfile (in bytes) the: 104
contorlfile must be recreated by adjusting parameter MAXINSTANCES of order CONTROLEFILE to modify
the maximum number of recordings REDO THREAD which can be stored

Space total currently affected with recording REDO L OG of the controlfile (in bytes):216
Number maximum of groups of logging files which can be created for the data base:32
max number of members for each group of logging files: 2

the controlfile must be recreated by adjusting parameter MAXLOGFILES
of order CONTROLEFILE to modify the maximum number of the groups of files of
journalisation.
The controlfile DOI T being recreated by adjusting parameters MAXLOGMEMBRERS of order
CREAT CONTROLEFILE to modify the maximum number members by group of logfiles. Space

total currently affected with recording DATAFILE of the file of control (in bytes) the:1980
controlfile must be recreated by adjusting parameter MAXDATAFILES of order CREATE CONTROLEFILE to
modify the maximum number of recording DATAFILE which can be stored

Space total currently affected with recording TABELSPACE of the contorlfile (in bytes):780
The controlfile must be recreated by adjusting parameter MAXDATAFILES of order CREATE CONTROLEFILE
to modify the maximum number of recording TABLESPACE which can be stored.

Space total currently affected with the recording LOG HISTORY of the controlfile (in bytes):130680
The controlfile must be recreated by adjusting parameter MAXHISTORY of order CREATE CONTROLEFILE to modify
the maximum number of recording LOG HISTORY which can be stored.

STAGES FOR RESOLVING THIS PROBLEM (Thank you)

Report message to a moderator

Re: English translation (babelfish) - ORA-00313 [message #62707 is a reply to message #62696]

Tue, 10 August 2004 14:18

benhamida
Messages: 3
Registered: August 2004

Junior Member

Help me,
I wait you, please.

Report message to a moderator

Re: English translation (babelfish) - ORA-00313 [message #62720 is a reply to message #62707]

Tue, 10 August 2004 22:33

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Sorry, can't help you with this one. I'm no DBA. I'd open an iTAR (technical assistance request) at metalink.oracle.com. You do have support, don't you?

MHE

Report message to a moderator

Previous Topic:	Archive mode errors.
Next Topic:	Internal login

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 23 15:32:55 CST 2025