Forgot your password?    
+ Reply to Thread
Results 1 to 8 of 8

Thread: Archivelog gets full

  1. #1
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    31

    Archivelog gets full

    Suppose alert came -archive log gets full say at 80%

    And if I issue Backup archive log delete input command in RMAN -
    this command somehow not run successfully and chances of delete input
    came into effect.

    Then what could be the solution in such a a scenario?

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    If the Backup does not run successfully , the delete wont take place.
    However , let us assume that the backup of archive was taken and later the backup went bad on account of corruption.
    In such a case we will not have archives with us , unless we configure more than one log_archive_dest (maybe to a secondary location or to standby)

    By using "DELETE INPUT" RMAN will backup only one copy of all the archivelogs in one archivelog destination and then delete only the backed up copies of all the archivelogs in only one archivelog destination, but by using "DELETE ALL INPUT", RMAN will backup only one copy of all the archivelogs in one archivelog destination and then delete all the copies of all the archivelogs in all the archivelog destinations.

    This situation is not related to Archives getting full. It may be that archive destination has a lot of space and our backup script is configured with 'DELETE INPUT'

  3. #3
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    31

    Archivelog gets full..

    further down the line ... Plz guide ...

    Q1) Should RMAN backup script contain DELETE INPUT clause or not particularly when
    archive log gets full or reached at certain percentage?

    Q2) Another thing I put up=> When archive log gets full (Received Monitoring Alert) then what should be the proper action plan which is to be followed ?
    Last edited by Hemant; 10-31-2011 at 11:22 PM.

  4. #4
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    Q1) Should RMAN backup script contain DELETE INPUT clause or not particularly when
    archive log gets full or reached at certain percentage?

    Ans : Its advisable to use the DELETE INPUT clause as it takes care of both backing up and clearing the archive space

    Q2) Another thing I put up=> When archive log gets full (Received Monitoring Alert) then what should be the proper action plan which is to be followed ?

    And : If your archive destination is 100% full , immediately change the log_archive_dest to rectify the database hang scenario.
    If archive alert is triggered on account of archive dest being <100% full (perhaps 70% full) , Backup the archives and remove them from the log_archive_dest

  5. #5
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    31
    One thing more if archive gets 100% full then database freeze (Cannot do any transaction) so we can change log archive dest after system reboot else no.
    Is it right or wrong? [Shutdown abort does not work even then]
    My point is how can we change immediately...when nothing happens due to freeze... Please clear this point also.

  6. #6
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128
    Clear up space on the archive destination to allow a few log switches. Use appropriate OS commands to move a few files to another location. Files can be removed if you are certain that they have been backed up.

    At this point the archive process should resume archiving again, and normal database activity should be possible. This is a prerequisite for continuing, since changing the archive destination cannot be done if the database is stuck waiting for the archive process.

    2. Issue commands to dynamicly change the log archive destination.
    a) In Enterprise edition
    ALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = ('LOCATION=/oradata/ORCL/archive');
    b) In Standard Edition
    ALTER SYSTEM SET LOG_ARCHIVE_DEST=/oradata/ORCL/archive

    Note: LOG_ARCHIVE_DEST_n parameters are not valid parameter in the Standard
    Edtion for Oracle versions lesser than 10.1. Trying to use it on Standard Edition will result in a ORA-00439: feature not enabled: %s error.

    3. Restart the archive process to use the new archive destinatin
    a) SQL> ALTER SYSTEM ARCHIVE LOG STOP;
    System altered.
    SQL> ALTER SYSTEM ARCHIVE LOG START;
    System altered.

    The newly created archiver procecess will now recognize the new archive destination.
    Regards,
    -Amit

  7. #7
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    You dont have to Shutdown DB to do switch log file only. Neither do you need to reboot.

    Just change the archive destination and issue 'alter system archive log current' to confirm that new archives are being created in the new destination.

  8. #8
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128
    My suggestion is to regularly monitor your alert and files system to avoid any situation like this..
    Regards,
    -Amit

+ Reply to Thread

Similar Threads

  1. mountpoint gets full
    By saioracleappsdba in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 4
    Last Post: 08-31-2012, 11:43 PM
  2. Archivelog Mode On RAC
    By devesh_ocp in forum RAC Installation, ASM Install , ASM Administration
    Replies: 0
    Last Post: 04-25-2012, 03:28 PM
  3. Issues regarding FULL GCs in JVMs and JVM crashing in 11.5.10 EBS environment
    By Chitiz in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 1
    Last Post: 02-29-2012, 03:45 PM
  4. Changing the Archivelog Mode on 9i and earlier
    By Sandeep Sharma in forum Core Database Administration and Monitoring
    Replies: 3
    Last Post: 12-22-2011, 09:29 PM
  5. Changing Oracle Database from Noarchivelog to Archivelog mode
    By Pradeep in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 12-14-2011, 05:10 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics