7 Replies Latest reply: Oct 25, 2012 4:08 PM by 954935 RSS

    standby stop applying archivelogs

    954935
      Hello,

      yesterday, for the purpose of purgering flashback logs (it occupied a lot of FRA space) in standby, I dropped one 'restore point' in the standby database, and 'rm -r' one flashback log (because not very sure, so only rm one flashback log).

      this is what I did

      cc:
      To remove uncessary Flashback Logs, you need to do the following:
      1) drop any Guaranteed Restore Points that you don’t need (e.g. drop restore point ===> done in standby
      2) set the init parameter DB_FLASHBACK_RETENTION_TARGET adequately ===> done in standby
      3) Log in as root and run the following statements:
      ls -lrt …/flashback|tail -100 =====> only 'rm' one flashback log (in asm )
      prepare delete statement for each file you want to remove
      (e.g. rm -f)

      then this morning, I found last Applied log is stuck in yesterday afternoon. the stanby database won't apply archivelogs.
      SYS> alter database recover managed standby database using current logfile disconnect;
      alter database recover managed standby database using current logfile disconnect
      *
      ERROR at line 1:
      ORA-01153: an incompatible media recovery is active


      Any idea to fix those problem?

      thank you
        • 1. Re: standby stop applying archivelogs
          mseberg
          Hello;


          alter database recover managed standby database cancel;

          Then :

          alter database recover managed standby database using current logfile disconnect from session;

          Best Regards

          mseberg
          • 2. Re: standby stop applying archivelogs
            Sebastian Solbach -Dba Community-Oracle
            Hi,

            it could also be that he accidentally removed the flashback log, which was just written to.
            This would also permit the database from applying redo.

            In this case you have to stop flashback and reenable it before you can continue.

            So in between the cancel and the restart do

            alter database flashback off

            and

            alter database flashback on

            Regards
            Sebastian
            • 3. Re: standby stop applying archivelogs
              954935
              Hello,
              thank you very much all.

              when try to

              alter database recover managed standby database cancel;

              (...stuck here, no feedback, process running for 10 minutes without any feedback).
              ??

              thank you

              cc: alert log

              NOTE: ASMB process exiting due to lack of ASM file activity
              Thu Oct 25 12:19:22 2012
              Stopping background process RBAL
              Starting background process ASMB
              ASMB started with pid=44, OS id=53739542
              Starting background process RBAL
              RBAL started with pid=50, OS id=15597628
              Thu Oct 25 12:25:38 2012
              SUCCESS: diskgroup RECOVER was mounted
              SUCCESS: diskgroup RECOVER was dismounted
              Thu Oct 25 12:25:39 2012
              NOTE: ASMB process exiting due to lack of ASM file activity
              Thu Oct 25 12:25:39 2012
              Stopping background process RBAL
              Thu Oct 25 12:32:49 2012
              ORA-1013 signalled during: alter database recover managed standby database cancel...
              Thu Oct 25 12:33:15 2012
              alter database recover managed standby database cancel

              (..hanging...)

              Edited by: 951932 on Oct 25, 2012 10:40 AM
              • 4. Re: standby stop applying archivelogs
                mseberg
                Hello again;

                Try :

                Shutdown Immediate

                and post the results.

                If the shutdown works and you are NOT using Data Guard Broker then do this :

                SQL> startup mount

                SQL> alter database recover managed standby database disconnect from session;

                Change the second command to using current logfileif you need that.

                Best Regards

                mseberg

                Edited by: mseberg on Oct 25, 2012 12:31 PM
                • 5. Re: standby stop applying archivelogs
                  954935
                  Hello,

                  try

                  shutdown immediate

                  (database hangs for 12 minutes..)


                  I wonder if I can try

                  shutdown abort


                  thank you
                  • 6. Re: standby stop applying archivelogs
                    mseberg
                    Hello again;

                    I would not do a shutdown abort.

                    You want to avoid this as Oracle may bark hard and you could compound your issue.

                    Check the last 100 lines of your Standby alert log for warnings and errors and post the results.

                    Best Regards

                    mseberg
                    • 7. Re: standby stop applying archivelogs
                      954935
                      Mseberg and Sebastian ,

                      I got the problem fixed now, what I did is to combine you two suggestions together, and I did do shutdown abort, it proves no problem.

                      thank you very much !!!!

                      Edited by: 951932 on Oct 25, 2012 2:08 PM