DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: Archive log

  1. 06-02-2003, 02:27 AM #1
    castlerock
    castlerock is offline Member
    Join Date
    Jan 2003
    Posts
    141

    Archive log

    Hi All,
    My database is running in archive log mode. When ever i shutdown and restart my database can i delete the archive files. Will this have any implication during recovery.


    Thanks,
    Reply With Quote Reply With Quote
  2. 06-02-2003, 02:37 AM #2
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    The correct way should be to backup your datafiles, backup the archivelogs and then delete them.
    It depends on how current your backedup datafiles are while recovering.

    HTH
    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. 06-02-2003, 02:37 AM #3
    vinit
    vinit is offline Senior Member
    Join Date
    Oct 2000
    Posts
    467
    Always better to backup the logs before deleting. Yes, you may not be able to perform complete recovery without the arch logs.
    Secondly do you take any backups ? (cold/hot).
    Vinit
    Reply With Quote Reply With Quote
  4. 06-02-2003, 02:39 AM #4
    castlerock
    castlerock is offline Member
    Join Date
    Jan 2003
    Posts
    141
    Thanks!
    Reply With Quote Reply With Quote
  5. 06-02-2003, 02:43 AM #5
    castlerock
    castlerock is offline Member
    Join Date
    Jan 2003
    Posts
    141
    Hi,
    The System is backed up using Veritas backup Exec. Using the veritas oracle agent all the datafiles and archive log files are backed up. Daily evening i will take an export dump ..without shutting down the database.

    Can i copy all the existing archive files to an external harddisk and delete the archive files.

    Thanks,
    Reply With Quote Reply With Quote
  6. 06-02-2003, 02:50 AM #6
    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
    Daily evening i will take an export dump ..
    What's the purpose of daily exports?
    If you are taking daily hotbackup and backing up the archive files. You should be fine. Do preform tests with your recovery procedure.
    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. 06-02-2003, 03:14 AM #7
    akhadar
    akhadar is offline Advisor
    Join Date
    May 2001
    Posts
    736
    When u are using Veritas Why don't u make script to delete the archivelogs once they successfully copied to tape or hard disk.In my backup up script the veritas will take care of backing up the archive log files and also deleting them.To reduce the MTTR keep atleast a week archive logs in a seperate folder on the hard disk.
    Reply With Quote Reply With Quote
  8. 06-02-2003, 03:15 AM #8
    castlerock
    castlerock is offline Member
    Join Date
    Jan 2003
    Posts
    141
    Hi,
    I have 300 users each user has 48 tables and 8 views.... if any one of the user looses some information in one or many tables. I will import the information from the latest export dump.

    What is the Perfrom test??? as of now i dont have any recovery procedures. If you have any recovery procedure? can you send it to me.

    Thanks,
    Reply With Quote Reply With Quote
  9. 06-02-2003, 03:19 AM #9
    castlerock
    castlerock is offline Member
    Join Date
    Jan 2003
    Posts
    141
    Hi akhadar,

    How to delete the archive log files using veritas after backing up to tape drive???


    Many Thanks,
    Reply With Quote Reply With Quote
  10. 06-02-2003, 03:28 AM #10
    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
    What is the Perfrom test??? as of now i dont have any recovery procedures. If you have any recovery procedure? can you send it to me.

    Thanks,
    The test to perform recovery. You can use a saperate machine to try recover database from your backup. You can also simulate the recovery scenarios like missing datafiles, missing redo log files missing constrol files etc.

    This test is to make sure whatever you are backing up is valid and usable backups.
    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
« 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