Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> my ORA-1079 gift for christmas and happy new year; thanx
--=====================_15402173==_.ALT
subject: my ORA-1079 gift for christmas and happy new year; thanx Oracle! :-)
hello,
while trying to 'startup' my database, i have the following message:
ORA-01079: ORACLE database was not properly created, operation aborted SVRMGR> I tried to recreate a controlfile as said in the doc :
SVRMGR> create controlfile reuse
2> database FISCD 3> logfile 4> '/ora01/oraredo/FISCD/redoFISCD11.log' size 1M, 5> '/ora01/oraredo/FISCD/redoFISCD21.log' size 1M, 6> '/ora01/oraredo/FISCD/redoFISCD31.log' size 1M 7> noresetlogs 8> datafile 9> '/ora01/oradata/FISCD/sys01.dbf' size 50M 10> maxinstances 8 11> maxlogfiles 32 12> /
alter database open
*
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/ora01/oradata/FISCD/sys01.dbf'
aaaaaaaaaaahhhh!!!!!!!!!
ok, I recover datafile :
PROD_sfx [SOFIX]:/home/oracle> oerr ora 1113
01113, 00000, "file %s needs media recovery"
// *Cause: An attempt was made to online or open a database with a file that
// is in need of media recovery.
// *Action: First apply media recovery to the file.
SVRMGR> select * from v$recover_file ;
FILE# ONLINE ERROR CHANGE# TIME
---------- ------- ------------------ ---------- --------- 1 ONLINE 149111 28/12/001 row selected.
SVRMGR> recover datafile '/ora01/oradata/FISCD/sys01.dbf' Media recovery complete.
Super! it works :-))))))
SVRMGR> alter database open ;
alter database open
*
ORA-00600: internal error code, arguments: [25012], [1], [2], [], [], [],
[], []
:-((((( F*ck !
oerr ora 600
00600, 00000, "internal error code, arguments: [%s], [%s], [%s], [%s],
[%s], [%s], [%s], [%s]"
// *Cause: This is the generic internal error number for Oracle program
// exceptions. This indicates that a process has encountered an // exceptional condition.
any ideas ?
PS: i'm not an Oracle-guru (as you can see...:-)
PS2: Happy new year from Tahiti (French Polynesia)!
* | | * | * \ | / \ . / \ a / \ .@. / @@@ * - - - - - `@@@@@@@@@@@@@' - - - - - * `@@@@@@@' / @@@@ @@@@ \ / @@@ @@@ \ / @@ + @@ \ ' "X" ` "XXX" "XXXXX" "GOD JUL" "BUON ANNO" "FELIZ NATAL" "JOYEUX NOEL" "VESELE VANOCE" "MELE KALIKIMAKA" "NODLAG SONA DHUIT" "BLWYDDYN NEWYDD DDA" """""""BOAS FESTAS""""""" "FELIZ NAVIDAD" "MERRY CHRISTMAS" "KALA CHRISTOUGENA" "VROLIJK KERSTFEEST" "FROHLICHE WEIHNACHTEN" "BUON NATALE-GODT NYTAR" "HUAN YING SHENG TAN CHIEH" "WESOLYCH SWIAT-SRETAN BOZIC" "MOADIM LESIMHA-LINKSMU KALEDU" "HAUSKAA JOULUA-AID SAID MOUBARK" """""""'N PRETTIG KERSTMIS""""""" "ONNZLLISTA UUTTA VUOTTA" "Z ROZHDESTYOM KHRYSTOVYM" "NADOLIG LLAWEN-GOTT NYTTSAR" "FELIC NADAL-GOJAN KRISTNASKON" "S NOVYM GODOM-FELIZ ANO NUEVO" "GLEDILEG JOL-NOELINIZ KUTLU OLSUM" "EEN GELUKKIG NIEUWJAAR-SRETAN BOSIC" "KRIHSTLINDJA GEZUAR-KALA CHRISTOUGENA" "SELAMAT HARI NATAL - LAHNINGU NAJU METU" """""""SARBATORI FERICITE-BUON ANNO""""""" "ZORIONEKO GABON-HRISTOS SE RODI" "BOLDOG KARACSONNY-VESELE VIANOCE " "MERRY CHRISTMAS AND HAPPY NEW YEAR" "ROOMSAID JOULU PUHI -KUNG HO SHENG TEN" "FELICES PASUAS - EIN GLUCKICHES NEUJAHR" "PRIECIGUS ZIEMAN SVETKUS SARBATORI VESLLE" "BONNE ANNEBLWYDDYN NEWYDD DDADRFELIZ NATAL" """"""""""""""""""""""""""""""""""""""""""""""""" XXXXX XXXXX XXXXX XXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX --=====================_15402173==_.ALT
<html>
<font face="Courier New, Courier">subject: my ORA-1079 gift for christmas
and happy new year; thanx Oracle! :-)<br>
<br>
hello,<br>
<br>
while trying to 'startup' my database, i have the following
message:<br>
<br>
<b>ORA-01079: ORACLE database was not properly created, operation
aborted<br>
SVRMGR> <br>
<br> </b>I tried to recreate a controlfile as said in the doc :<br> <br> <b>SVRMGR> create controlfile reuse<br> 2> database FISCD<br> 3> logfile<br>
7> noresetlogs<br> 8> datafile<br> 9>
10> maxinstances 8<br> 11> maxlogfiles 32<br> 12> /<br>
<br> <br> <b>aaaaaaaaaaahhhh!!!!!!!!!<br> </b>ok, I recover datafile :<br> <br> <br>
---------- ------- ------------------ ---------- ---------<br> 1 ONLINE 149111 28/12/00 <br>
<br> <br> <b>SVRMGR> recover datafile '/ora01/oradata/FISCD/sys01.dbf'<br>Media recovery complete.<br>
<br> <br> </b>Super! it <b>works </b>:-))))))<br> <br> <br> <br>
<br> <br> </b>:-((((( F*ck !<br> <br>
"X" `<br> "XXX"<br> "XXXXX"<br> "GOD JUL"<br> "BUON ANNO"<br> "FELIZ NATAL"<br> "JOYEUX NOEL"<br> "VESELE VANOCE"<br> "MELE KALIKIMAKA"<br> "NODLAG SONA DHUIT"<br> "BLWYDDYN NEWYDD DDA"<br> """""""BOASFESTAS"""""""<br>
"FELIZ NAVIDAD"<br> "MERRY CHRISTMAS"<br> "KALA CHRISTOUGENA"<br> "VROLIJK KERSTFEEST"<br> "FROHLICHE WEIHNACHTEN"<br> "BUON NATALE-GODT NYTAR"<br> "HUAN YING SHENG TAN CHIEH"<br> "WESOLYCH SWIAT-SRETAN BOZIC"<br> "MOADIM LESIMHA-LINKSMU KALEDU"<br> "HAUSKAA JOULUA-AID SAID MOUBARK"<br> """""""'N PRETTIG KERSTMIS"""""""<br>
"ONNZLLISTA UUTTA VUOTTA"<br> "Z ROZHDESTYOM KHRYSTOVYM"<br> "NADOLIG LLAWEN-GOTT NYTTSAR"<br> "FELIC NADAL-GOJAN KRISTNASKON"<br> "S NOVYM GODOM-FELIZ ANO NUEVO"<br> "GLEDILEG JOL-NOELINIZ KUTLU OLSUM"<br> "EEN GELUKKIG NIEUWJAAR-SRETAN BOSIC"<br> "KRIHSTLINDJA GEZUAR-KALA CHRISTOUGENA"<br> "SELAMAT HARI NATAL - LAHNINGU NAJU METU"<br> """""""SARBATORI FERICITE-BUON ANNO"""""""<br>
"ZORIONEKO GABON-HRISTOS SE RODI"<br> "BOLDOG KARACSONNY-VESELE VIANOCE "<br> "MERRY CHRISTMAS AND HAPPY NEW YEAR"<br> "ROOMSAID JOULU PUHI -KUNG HO SHENG TEN"<br> "FELICES PASUAS - EIN GLUCKICHES NEUJAHR"<br> "PRIECIGUS ZIEMAN SVETKUS SARBATORI VESLLE"<br> "BONNE ANNEBLWYDDYN NEWYDD DDADRFELIZ NATAL"<br>
"""""""""""""""""""""""""""""""""""""""""""""""""<br> XXXXX<br>
![]() |
![]() |