how to delete archive log files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: how to delete archive log files

  1. #1
    Join Date
    Jan 2003
    Posts
    141

    how to delete archive log files

    Hi,
    I have lot of archive log files in the production database.I am not running using RMAN.Can i delete all the archive logs except for the last week.Will this deletion will have any effect if there is recovery.can anyone adivce me on this.


    Thanks

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    What backup strategy do you have? If you are taking regular hotbackups then backup the archived logs as well immediately after hot backup and delete them.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Jan 2003
    Posts
    141
    Hi ,
    we are taking hot backup(control file,datafiles) to tape drive. We are not backing up the archive log files.

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by castlerock
    Hi ,
    we are taking hot backup(control file,datafiles) to tape drive. We are not backing up the archive log files.
    Backing up archive log files must be a part of any hotbackup. You can look for some scripts on this site to include archive log backup in your hotbackup script.
    Think of moving to RMAN if your DB version is > 8.X
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  5. #5
    Join Date
    Jan 2003
    Posts
    141
    hi,
    I have three oracle 8.1.5.0.0 databse and two 9i databases. Can you tell me how to enable the RMAN in the environment.

    Thanks,

  6. #6
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  7. #7
    Join Date
    Jan 2003
    Posts
    141
    Hi,
    Got the Doc.Thanks! for the support.

    Thanks,
    Ramesh

Posting Permissions

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



Click Here to Expand Forum to Full Width