2 Replies Latest reply: Dec 3, 2012 12:40 AM by Osama_Mustafa RSS

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

    SigCle
      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
          "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
            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