4 Replies Latest reply on Jul 30, 2020 2:01 PM by Mark D Powell

    reset backup

    user609448

      Hi.

      Our database Oracle

      Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production              0

      PL/SQL Release 12.2.0.1.0 - Production                                                    0

      CORE 12.2.0.1.0 Production                                                                  0

      TNS for Linux: Version 12.2.0.1.0 - Production                                            0

      NLSRTL Version 12.2.0.1.0 - Production                                                    0

      on Linux

      is running good. But we need to forget all archived log files because they are very many.

      In short we need to create new backup life of our database.

      What is the best way to do it ?

      Thanks in advance.

      Andrii.

        • 1. Re: reset backup
          Sunny kichloo

          If your existing backups are running as per business requirement it is better to continue that process only.

           

          With respect to archivelog you can configure deletion of old archive log files based on your recovery objectives.

           

          https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmconfb.htm#BRADV89439

          • 2. Re: reset backup
            user609448

            If I do open resetlogs, make backup incr 0, and delete all old archived logs.

            Is it will be correct ?

            • 3. Re: reset backup
              EdStevens

              user609448 wrote:

               

              If I do open resetlogs, make backup incr 0, and delete all old archived logs.

              Is it will be correct ?

              I think the more important question is why do you have so many old archivelogs in the first place?  Your regular, daily, database backup job should also be backing up the archivelogs and deleting them as they are backed up.  Some variant of 'backup archivelog delete all input'.

               

              There should be no  reason to 'reset' anything.  If you've got a bunch of old archivelogs, just issue a one-time 'backup archivelog all delete all input'.  Then you can go look at your archivelog destination and manually delete any old archivelogs remaining.

              • 4. Re: reset backup
                Mark D Powell

                user609448, to add to or modify what Sunny posted you need to determine what your backup and recovery retention requirements are, compare that your implemented backup and retention practice, then make changes if the two are not in sync or the cleanup was not implemented correctly to match the requirements.

                - -

                HTH -- Mark D Powell --