Forum Stats

  • 3,735,222 Users
  • 2,247,146 Discussions
  • 7,857,788 Comments

Discussions

reset backup

user609448
user609448 Member Posts: 72 Blue Ribbon
edited Jul 30, 2020 10:01AM in General Database Discussions

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.

user609448

Best Answer

Answers

  • Sunny kichloo
    Sunny kichloo Member Posts: 2,443 Gold Trophy
    edited Jul 30, 2020 4:16AM Accepted Answer

    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

    user609448
  • user609448
    user609448 Member Posts: 72 Blue Ribbon
    edited Jul 30, 2020 4:37AM

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

    Is it will be correct ?

  • EdStevens
    EdStevens Member Posts: 28,158 Gold Crown
    edited Jul 30, 2020 8:22AM
    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.

  • Mark D Powell
    Mark D Powell Member Posts: 5,914 Blue Diamond
    edited Jul 30, 2020 10:01AM

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

Sign In or Register to comment.