RE: Lost of all Control Files

ll Control Files   -Mensaje original-De: Ramon Estevez [mailto:[EMAIL PROTECTED]]Enviado el: Thursday, 16 August, 2001 9:23 AMPara: '[EMAIL PROTECTED]'Asunto: RE: Lost of all Control Files Friends   Thanks to all of you helped me w

RE: Lost of all Control Files

  -Mensaje original-De: Ramon Estevez [mailto:[EMAIL PROTECTED]]Enviado el: Thursday, 16 August, 2001 9:23 AMPara: '[EMAIL PROTECTED]'Asunto: RE: Lost of all Control Files Friends   Thanks to all of you helped me with the problem. The create controlfile w

RE: Lost of all Control Files

Ramon:   Here's a copy of the script generated by the 'alter database backup controlfile to trace' command on my sandbox machine. Basically, you trim off everything above the 'STARTUP MOUNT' command, start svrmgrl, and execute the script.   Remember, you need to put in your own database name

RE: Lost of all Control Files

E-LSubject: RE: Lost of all Control Files Hi Lyuda,   Alter database backup controlfile to trace doesn't work because the DB doesn't mount. :-(       Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -Mensaje original-

RE: Lost of all Control Files

"Ramon Estevez" el.net.do> cc: Sent by:

RE: Lost of all Control Files

[EMAIL PROTECTED] Subject: RE: Lost of all Control Files

RE: Lost of all Control Files

TECTED]]En nombre de [EMAIL PROTECTED]Enviado el: Wednesday, 15 August, 2001 2:01 PMPara: Multiple recipients of list ORACLE-LAsunto: RE: Lost of all Control Files If  did 'alter database backup control file to trace'  prior to your control files going bad check your u

RE: RE: Lost of all Control Files

Tks Dick, Yes, is a computer with only one disco, Is a DB for development purposes until the real server comes. The issue is that I had too many data in the DB and it will took me 2 days of work to load it again. Thanks, I will have it present for the next time. It won't happen again. :-( Ram

RE: Lost of all Control Files

Wednesday, 15 August, 2001 2:01 PMPara: Multiple recipients of list ORACLE-LAsunto: RE: Lost of all Control Files If  did 'alter database backup control file to trace'  prior to your control files going bad check your user dump directory.  Open that control file (it&#x

RE: Lost of all Control Files

]]En nombre de INF/MEKKAOUIEnviado el: Wednesday, 15 August, 2001 10:41 AMPara: Multiple recipients of list ORACLE-LAsunto: RE: Lost of all Control Files hi, if you have 3 controlfiles (it means that you have two copies of your controlfile), so if there is a problem with one

RE: Lost of all Control Files

, [Lyuda Hoska]   -Original Message-From: Ramon Estevez [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 15, 2001 1:21 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Lost of all Control Files Thanks,   And what is the sintax of the create controlfile command ?   How

RE: Lost of all Control Files

hi, if you have 3 controlfiles (it means that you have two copies of your controlfile), so if there is a problem with one controlfile, you had to change the parameter control_files in the init.ora so that you eliminate the corrupted file.     Best Regards, Nabila Mekkaoui DBA Oracle -

RE: Lost of all Control Files

: Wednesday, 15 August, 2001 10:37 AMPara: Multiple recipients of list ORACLE-LAsunto: RE: Lost of all Control Files If all three are corrupted, you have to run the "create controlfile" statement and to make sure that you list all your data files and redo logs.  You will

RE: Lost of all Control Files

If all three are corrupted, you have to run the "create controlfile" statement and to make sure that you list all your data files and redo logs.  You will loose the archiving and RMAN (if you have it) info though.   At least you will not forget now to backup control files regularly ;-).   D