5 Replies Latest reply: Feb 12, 2013 4:09 PM by 990515 RSS

    Manual Standby Database not in sync with missing archivelogs

    990515
      Hello,

      OS: Solaris
      DB: Oracle 11.2.0.1 EE
      Not Using ASM or RAC

      I have a Production database that is in archivelog mode and a Standby DR server.
      Both servers (Prod, Standby) have exact same structure and db name/version.

      We manually scp archive logs and recover them to a manual standby database via SQL Scripts "cron". (I.E. set autorecovery on; recover standby database;)
      We recently got out of sync with our log files and have not been applying them to the standby. As part of Prod Maintenance, these log files were deleted and are not available anymore.
      I've tried several ways to "rebuild" our standby database. I have tried to Shutdown prod, backup all the db files and scp them to standby, re-create standby controlfile and startup mount and recover standby.
      Every time I try to apply a new archive log via recover standby, these are the errors:

      ORA-00279: change 211077622 generated at 1/27/2012 12:18:42 needed for thread 1
      ORA-00289: suggestion : /oradump/arch/PROD/PROD_arch_1_69486_736618850.arc
      ORA-00280: change 211077622 for thread 1 is in sequence #69486


      ORA-00308: cannot open archived log '/oradump/arch/PROD/PROD_arch_1_69486_736618850.arc'
      ORA-27037: unable to obtain file status
      SVR4 Error: 2: No such file or directory
      Additional information: 3

      ORA-10879: error signaled in parallel recovery slave
      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: '/oradevices/PROD/oraPRODsystem1.dbf'

      When I check v$log_history, the new logs have not been applied.
      I've also tried the "Restore from incremental backup via SCN" method with same results.

      Is there a way to re-create the standby clean and ensure that the log chain that is currently broken gets fixed or reset?
      I would eventually like to get DataGuard in here, but that's not the case at the moment.
      Thanks for your suggestions.

      -Dav
        • 1. Re: Manual Standby Database not in sync with missing archivelogs
          kuljeet singh -
          ORA-00308: cannot open archived log '/oradump/arch/PROD/PROD_arch_1_69486_736618850.arc'
          ORA-27037: unable to obtain file status
          SVR4 Error: 2: No such file or directory
          is this archive log present on above destination
          post output of
          ls -ltr /oradump/arch/PROD/PROD_arch_1_69486_736618850.arc

          also post error msg while applying incremental backup.
          • 2. Re: Manual Standby Database not in sync with missing archivelogs
            saurabh
            if you are using the cold backup to create the standby database, Check that have you followed the following steps or not.

            1. remove
            all the datafiles and controlfiles from the standby database.

            2. Create a new standby controlfile of the production for standby using the following cmd
            'alter database create standby controlfile as 'Location';'

            3. move the new controlfile to standby database server location as specified in initialization parameter file.

            4. Restore all the datafiles to its appropriate loaction which was taken through cold backup.

            5. startup nomount

            6. alter database mount standby database;

            7. recover standby database.
            scp the archive log sequence that is asked by the database, from production.

            You can try this steps.
            • 3. Re: Manual Standby Database not in sync with missing archivelogs
              Mihael
              1. check that log_archive_format is the same for primary and standby
              2. put all logs to some directory, ex. /dir1
              3. run
              alter database recover automatic from '/dir1' standby database;
              • 4. Re: Manual Standby Database not in sync with missing archivelogs
                Step_Into_Oracle_DBA
                987512 wrote:
                Is there a way to re-create the standby clean and ensure that the log chain that is currently broken gets fixed or reset?
                Do Roll Forwarding of Standby Database which is the easier way to bring Primary and Standby SYNC when archive logs are not available.

                Rolling a Standby Forward using an RMAN Incremental Backup in 10g onwards [ID 290814.1]


                Mark your Post as Answered or Helpful if Your question is answered.

                Thanks & Regards,
                SID

                (StepIntoOracleDBA)

                Email : stepintooracledba@gmail.com

                http://stepintooracledba.blogspot.in/

                http://www.stepintooracledba.com/

                Edited by: Step Into Oracle DBA on Feb 12, 2013 5:16 AM
                • 5. Re: Manual Standby Database not in sync with missing archivelogs
                  990515
                  Thank you everyone for your responses. I've seen the roll forward article.
                  I'm pretty sure I followed those directions properly before without success, but now I have it the standby up and receiving new archive logs after performing the complete cold backup and recover method.
                  Question is marked as answered.
                  Cheers.
                  -Dav