This discussion is archived
2 Replies Latest reply: Dec 2, 2012 10:29 PM by Niket Kumar RSS

Database Can't be Open on Primary Side (ODG)

SigCle Newbie
Currently Being Moderated
Dear Expert,

When do this step :
Alter database create standby controlfile ..

Is all primary controlfile reset ?

original size 2M .. and after do : Alter database create standby controlfile to control.ctl, all original controlfile resized to 50K.
Now primary databae can't be opened.

Any helps are very appreciated.

Best Regards
  • 1. Re: Database Can't be Open on Primary Side (ODG)
    Niket Kumar Pro
    Currently Being Moderated
    "Alter database create standby controlfile" this command will not change controlfile size.

    i think you have replaced primary database control file with this standby file.

    post your OS information and db version.

    post 300 lines from alert log file of primary database.
  • 2. Re: Database Can't be Open on Primary Side (ODG)
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    SigCle wrote:
    Dear Expert,

    When do this step :
    Alter database create standby controlfile ..

    Is all primary controlfile reset ?

    original size 2M .. and after do : Alter database create standby controlfile to control.ctl, all original controlfile resized to 50K.
    Now primary databae can't be opened.

    Any helps are very appreciated.

    Best Regards
    This command i used for Creating a standby database control file which mean the control file need to be created for standby database :

    The created file must meet two conditions:

    Its filename must be different from any other control file
    Must be created after the backup of the datafiles.


    Read
    http://docs.oracle.com/cd/B10501_01/server.920/a96653/create_ps.htm

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points