Re: How to recover controlfile for OMF database?

Peter <peter_at_nomorenewsspammin.ca> wrote in message news:<vsnjbv06fhrk1a6tik06fdvlujbqaiblis_at_4ax.com>...
> On Wed, 07 May 2003 22:41:00 +0200, Sybrand Bakker
> <gooiditweg_at_nospam.demon.nl> wrote:
>
> >On Wed, 07 May 2003 20:26:15 GMT, Peter <peter_at_nomorenewsspammin.ca>
> >wrote:
> >
> >>My whole database wascreated sing OMF oracle-managed files.
> >>After shutting down and restarting I got the following message:
> >>
> >>
> >>SQL> alter database mount;
> >>alter database mount
> >>*
> >>ERROR at line 1:
> >>ORA-00205: error in identifying controlfile, check alert log for more
> >>info
> >>
> >>
> >>How do you actualy recover controlfiles for an OMF database? I
> >>thought Oracle is doing everything and should be able to finds its own
> >>controlfiles.
> >>
> >>
> >>
> >You should prefer reading manuals, above ASSUMEing something you
> >didn't verify. You should also do as instructed in the error message
> >BEFORE posting.
>
> How do you know I didn't?
>
> >You are becoming quite a bore in the newsgroup as you basically misuse
> >it as a first resort, prior to doing your homework properly
> >
> >
>
> This is my 24/7 job, not my homework. Please give some respect to
> yourself.

Something from the docs.

Specifying Control Files at Database Creation At database creation, the control file is created in the files specified by the CONTROL_FILES initialization parameter. If the CONTROL_FILES parameter is not set and at least one of the initialization parameters required for the creation of Oracle-managed files is set, then an Oracle-managed control file is created in the default control file destinations. In order of precedence, the default destination is defined as follows:

If DB_CREATE_ONLINE_LOG_DEST_n initialization parameters are specified, then an Oracle-managed control file copy is created in each directory specified. The file in the first directory is the primary control file.
If the DB_CREATE_FILE_DEST initialization parameter is specified, and no DB_CREATE_ONLINE_LOG_DEST_n initialization parameters are specified, then an Oracle-managed control file is created in the directory specified.
If the CONTROL_FILES parameter is not set and none of the above initialization parameters are set, then Oracle's default behavior is operating system dependent. At least one copy of a control file is created in an operating system dependent default location. Any copies of control files created in this fashion are not Oracle-managed files, and you must add a CONTROL_FILES initialization parameter to any initialization parameter file.

If Oracle creates an Oracle-managed control file, and if there is a server parameter file, then Oracle creates a CONTROL_FILES initialization parameter entry in the server parameter file. If there is no server parameter file, then you must manually include a CONTROL_FILES initialization parameter entry in the text initialization parameter file.

Regards,
Ganesh R Received on Thu May 08 2003 - 06:16:47 CDT