Results 1 to 2 of 2

Thread: archive logs

  1. 07-26-2006, 05:27 PM #1
    mojaveson
    mojaveson is offline Registered User
    Join Date
    Mar 2006
    Location
    barstow, ca
    Posts
    7

    archive logs

    I am using oracle 9i on windows 2003 server. It is in archive log mode. I have about 50GB database. I have had some issues where I need to restore and recover datafiles. The path to the archive logs is D:\oracle\oradata\dbname\archive. In that folder I have ~300 files that have names like 1_216.dbf or 1_267.dbf and each one is 100MB. This folder has filled the D drive. I moved some of the older files to another location to make room. However, when I need to do a restore and recover on a datafile I have to move these older files back to their original location on the D drive or the recovery bombs.
    I am wondering if there is a way to make it so I only need say the last 10 dbf files to do the recovery. Is it something like a checkpoint or some other command that will let me do away with some of these 300+ 100MB a piece files?
    I just can't figure out why it has to apply 300+ log files to recover the datafile.
    Thanks
    Reply With Quote Reply With Quote
  2. 07-27-2006, 09:50 PM #2
    stecal
    stecal is offline Registered User
    Join Date
    Oct 2005
    Posts
    2,557
    What is your backup/retention policy? It's a no-brainer.
    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