mount a current controlfile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: mount a current controlfile

Hybrid View

  1. #1
    Join Date
    Dec 2001
    Posts
    320
    hi all,
    i get ORA-00236, and i need to mount a current controlfile, but what does it mean to mount a control file?
    (execuse my english).

    Thanks.

  2. #2
    Join Date
    Aug 2002
    Location
    Bangalore
    Posts
    52
    There is nothing called mount control file,actually it is mounting database.When u mount the database oracle will look for control file.If it cannot find in the specified path given in the parameter file it will give this error.So check wheather the control file is present or not in the specified path.


    Joe

  3. #3
    Join Date
    Dec 2001
    Posts
    320
    from oracle documentation
    -----------------------------------------
    ORA-00236 snapshot operation disallowed: mounted controlfile is a backup

    Cause: Attempting to invoke cfileSetSnapshotName, cfileMakeAndUseSnapshot, or cfileUseSnapshot when the currently mounted control file is a backup control file.

    Action: Mount a current control file and retry the operation.
    ------------------------------------------

    as for your suggestion, the control file is already there.

    what do you think could be the problem?

    Regards.

  4. #4
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Like Jomon suggested, Check the CONTROL_FILES parameter in your instance INI file. Check if all the control files specified are present.
    -- Dilip

  5. #5
    Join Date
    Dec 2001
    Posts
    320
    hi,
    The control files are there, the problem is not in their presence, i wish i knew what the problem is.

    Regards.


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