Re: Help with control Files

In previous article, Charles/Carol Walker (cwalker_at_pacbell.net) wrote:
[QUOTE]I have gotten an "Inconsistant control files" error. I don't remember the number. To
[QUOTE]fix this I copied the one with the latest UNIX date over the other copies. Was this the
[QUOTE]wrong thing to do? After I did this I started getting datafile needs recovery errors. I
[QUOTE]am running in NOARCHIVEMODE. If I recreate the control files, will this cure my ills?
[QUOTE]Please e-mail cwalker_at_csc.com with response.

     The latest version of the control file must be the control file that worked properly before. So, it may or may not be the latest one.

     You can try the command CREATE CONTROLFILE command. Following is one of the examples :

     STARTUP NOMOUNT PFILE=init_sid.ora
     CREATE CONTROLFILE REUSE DATABASE sid ... (Your previous configuration)    
     ALTER DATABASE OPEN;

--

                                                               Best Regards,

                                                                 Lun Wing San
                                                                 ­Û  ¥Ã   ·s


Email address : sunny_at_hkpc.org / wslun_at_cs.cuhk.hk                           
Telephone     : (852)2758 5936 / (852)2788 5841