Forum Stats

  • 3,816,836 Users
  • 2,259,238 Discussions
  • 7,893,569 Comments

Discussions

ORA-00257 on FRA and archives are not being deleted

User_NK0CG
User_NK0CG Member Posts: 1 Green Ribbon

Hi, I'm a kinda new in teh ORACLE world.

I'm dealing with an issue with a homologation base:

The FRA is 100% used and there was archives from a month ago.

I had to delete some archives to give some free space to FRA.

My client's RMAN configs are:

RMAN configuration parameters for database with db_unique_name HML are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.4/dbhome_2/dbs/snapcf_hmlmv2.f'; # default

--

My question is: If I change the archivelog deletion police to CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK; is it going to prevent it happens again? Is it enough?


My best regards

Answers

  • EdStevens
    EdStevens Member Posts: 28,778 Gold Crown

    It would help if we saw the actual rman backup scripts as well. They can very well override the configurations.

    And I'd like to know exactly how (commands used) to delete the old files.

  • Nikhil Kotak
    Nikhil Kotak Member Posts: 5 Red Ribbon

    You have "CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;"


    It should be one of below


    CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; 

    CONFIGURE ARCHIVELOG DELETION POLICY to SHIPPED TO ALL STANDBY;

    CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO 'SBT_TAPE';

    CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE' applied on all standby; 

    CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO 'SBT_TAPE';

    CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE';

  • nabjoshi-Oracle
    nabjoshi-Oracle Posts: 14 Employee

    You can schedule the below script in crontab to take a backup of archivelogs and clears the space from FRA.

    schedule it as per the archivelog generation rate. if it's very high, schedule scripts to run 4 to 5 times in a day.

    rman backup command ;

    RUN

    {

    ALLOCATE CHANNEL c1 DEVICE TYPE disk;

    ALLOCATE CHANNEL c2 DEVICE TYPE disk;

    ALLOCATE CHANNEL c3 DEVICE TYPE disk;

    ALLOCATE CHANNEL c4 DEVICE TYPE disk;

    crosscheck archivelog all;

    backup as compressed backupset archivelog all delete input format '/backup/$ORACLE_SID/%d_%T_%s_%p_ARCHIVE.bkp' filesperset 20; 

    backup current controlfile format '/u01/$ORACLE_SID/%d_%T_%s_%p_CONTROL';

    release channel c1;

    release channel c2;

    release channel c3;

    release channel c4;

    }


    Hope this helps.