DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: how to delete archive log files

  1. 01-15-2003, 11:56 PM #1
    castlerock
    castlerock is offline Member
    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
    Reply With Quote Reply With Quote
  2. 01-16-2003, 12:05 AM #2
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    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"
    Reply With Quote Reply With Quote
  3. 01-16-2003, 01:37 AM #3
    castlerock
    castlerock is offline Member
    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.
    Reply With Quote Reply With Quote
  4. 01-16-2003, 01:50 AM #4
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    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"
    Reply With Quote Reply With Quote
  5. 01-16-2003, 01:55 AM #5
    castlerock
    castlerock is offline Member
    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,
    Reply With Quote Reply With Quote
  6. 01-16-2003, 02:08 AM #6
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    http://download-west.oracle.com/docs...a96566/toc.htm
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"
    Reply With Quote Reply With Quote
  7. 01-16-2003, 02:21 AM #7
    castlerock
    castlerock is offline Member
    Join Date
    Jan 2003
    Posts
    141
    Hi,
    Got the Doc.Thanks! for the support.

    Thanks,
    Ramesh
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules

Click Here to Expand Forum to Full Width