Controlfile Corrotto
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Controlfile Corrotto

  1. #1
    Join Date
    Apr 2004
    Location
    Livorno
    Posts
    1

    Unhappy Controlfile Corrotto

    Salve a tutti.
    Il mio database in Oracle 8i Standard Edition su un sistema operativo Win2000 non partiva più perchè il sistema non leggeva più un settore del disco dove di trova uno dei tre controlfile, per ovviate al problema ho fatto uno shutdown abort ho cambiato il file di startup di oracle escludendo il controlfile incriminato e ho fatto ripartire il mio database con successo.
    Adesso vorrei creare un altro controlfile (rimanere con due soli controlfile mi sembra un pò azzardato)... quale procedura è più indicata?
    Grazie Mille.

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    erika,
    Se poteste scrivere in inglese il vostro problema potrebbe essere capito più meglio. Ho provato a tradurre il vostro messaggio ma non potrei capire l'intero problema. Proveremo il nostro la cosa migliore per aiutarli comunque
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    If you now make normal shutdown (not abort) you can then simply copy one of the good control files to replace the bad one - and change the init.ora again. But it might be a good idea to replace the faulty disk too!

    (scusi, non parlo italiano - viva Verdi!)

  4. #4
    Join Date
    Mar 2002
    Location
    Manchester, England
    Posts
    202
    I can't read it and I can be arsed to translate it but this still makes me chuckle. must be cause its a friday.

  5. #5
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Originally posted by DaPi
    If you now make normal shutdown (not abort) you can then simply copy one of the good control files to replace the bad one - and change the init.ora again. But it might be a good idea to replace the faulty disk too!

    (scusi, non parlo italiano - viva Verdi!)
    Da*n DaPi I'm impressed! all I could extract out of that mess was something about a control file.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  6. #6
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Come on - Italian is easy. For example, just look at the begining:

    Salve a tutti.
    Il mio database in Oracle 8i Standard Edition . . .

    which translates directly as:

    Fire guns at ballerinas' dresses.
    Millions of sick Oracle 8i Standard Edition databases . . . .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width