6 Replies Latest reply: Nov 19, 2013 10:59 PM by Mahir M. Quluzade RSS

    Creating physical standby

    Jibu

      HI,

       

      I am trying to create a new physical standby for my production database.

      I have taken a copy of database.

      Then i created backup control file... This was created when database was open... Should create it when primary database is mounted ( not open )...

       

      I am getting following error while trying to apply archive files...

       

      ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

      ORA-01152: file 1 was not restored from a sufficiently old backup

      ORA-01110: data file 1: 'O:\ORADATA\NEFT\SYSTEM01.DBF'

       

      Regards,

      Jibu

        • 1. Re: Creating physical standby
          Fran

          how to create physical standby database --> Creating a Physical Standby Database

           

          to solve your proble, did you tried?

           

          sqlplus / as sysdba

          SQL> alter database open resetlogs

          ? you will open a NOT standby database. to do that you should read the first link, where explain how to create a backup for standby database and how to create it.

           

          Next time to do a Point in time recovery you should read first how to do it --> 7.6 Performing Database Point-In-Time Recovery

          • 2. Re: Creating physical standby
            Mahir M. Quluzade

            Jibu wrote:

             

            HI,

             

            I am trying to create a new physical standby for my production database.

            I have taken a copy of database.

            Then i created backup control file... This was created when database was open... Should create it when primary database is mounted ( not open )...

             

            I am getting following error while trying to apply archive files...

             

            ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

            ORA-01152: file 1 was not restored from a sufficiently old backup

            ORA-01110: data file 1: 'O:\ORADATA\NEFT\SYSTEM01.DBF'

             

            Regards,

            Jibu

            Hi,

             

            What is your version?

             

            Did you sure you are create backup  control file for standby?

            Please check on Standby side: select database_role from v$database;

             

            If you database is created successfully, then you must start  Apply process on standby database

            for recover managed standby.

             

            alter database recover managed standby database disconnect from session; 

            OR

            alter database recover managed standby database using current logfile disconnect from session;  -- real time apply (after 11g)

             

            Regards

            Mahir M. Quluzade

            • 3. Re: Creating physical standby
              Anar Godjaev

              Hi,

               

              Please check Oracle support id :

               

              While Duplicating the Database ,Rman Errors ora-1547,ora-1152,ora-1110 During Recovery (Doc ID 274118.1)

              Step By Step Guide To Create Physical Standby Database Using RMAN Backup and Restore (Doc ID 469493.1)

               

              Thank you


              • 4. Re: Creating physical standby
                nagulan.selvakumar
                Then i created backup control file... This was created when database was open... Should create it when primary database is mounted ( not open )...

                 

                Not necessarily the primary to be mounted as there is no downtime needed to create a physical standby database. Did you create a controlfile for standby?

                 

                Alter database create standby controlfile as '/location/of/file/name.ctl';
                

                 

                Use this controlfile to recover your cloned standby and don't attempt to open it; just start media recovery using MRP. Check the status of your log apply on standy.

                 

                Thank you!!

                • 5. Re: Creating physical standby
                  Jibu

                  Yes.. Standby control file was created from primary ( primary was OPEN for readwrite)...

                   

                  Database mode is PHYSICAL STANDBY...

                   

                  Reagards,

                  Jibu

                  • 6. Re: Creating physical standby
                    Mahir M. Quluzade

                    Hi,

                     

                    It is good.

                     

                    Please check my before reply and  after restore database, don't open database.

                    Check data guard configuration parameters is setting correctly.

                     

                    Check transport service is running, Apply process is started, Redo  changes received by standby.

                     

                    select max(sequence#) from v$archived_log;  -- on both side

                    select max(sequence#) from v$archived_log where applied='YES';  -- on standby side

                     

                    Regards

                    Mahir M. Quluzade