Implementing ARCHIVELOG - Any ideas?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Implementing ARCHIVELOG - Any ideas?

  1. #1
    Join Date
    Feb 2001
    Posts
    295

    Implementing ARCHIVELOG - Any ideas?

    Scary scenario:
    - Production database;
    - NOARCHIVELOG;
    - Only logical backups;
    - "Theoretically" 24x7; cold backups cannot be implemented (one MONTHLY backup MAY be possible);
    - No load balancing: all datafiles concentrated on the same RAID5 device
    - Disk capacity near the limit;
    - No resources or possibility of changing that architecture immediately;

    The question is: what is a proper way to force ARCHIVELOG on a scenario like that? some considerations I already made:

    - Archiving to a remote server is a bit dangerous; a network failure might impact database activity; anyway, even with no failures network bandwidth should be severely affected.

    - Maybe ARCHIVELOG could be implemented on the local disk with an automatic routine to clear archives. However, it would be an extra write activity on a RAID5 device busy enough. It might potentially affect performance.

    Any different and creative approaches to workaround that without hardware interventions?
    An ounce of action is worth a ton of theory.
    —Friedrich Engels

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    If you're going to archive, you've got to have space. Period.

    In your situation, I would plan on a daily hot backup. You could limit the growth of your log_archive_dest by running several archivelog backups to tape or NFS disk throughout the day and removing them once they are backed up. However, not having your archived redo logs on disk will severely limit your chances for a quick recovery.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Re: Implementing ARCHIVELOG - Any ideas?

    Originally posted by adrianomp
    - Only logical backups;
    I won't even touch that one...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Jan 2004
    Location
    Paris, France
    Posts
    52
    You may think about using RMAN.
    You will then alter the database to applied archivelog.
    With RMAN you have the availability to perform Hot Backup to tape.
    With RMAN you can run a script that backups all the archivelog periodicly and clear them from the disk.

    Latyr

  5. #5
    Join Date
    Feb 2001
    Posts
    295
    Originally posted by marist89
    In your situation, I would plan on a daily hot backup. You could limit the growth of your log_archive_dest by running several archivelog backups to tape or NFS disk throughout the day and removing them once they are backed up. However, not having your archived redo logs on disk will severely limit your chances for a quick recovery.
    Totally agree. However, it may be better to have a "not so quick" recovery than "no recovery" at all. According to my estimates, a full recovery would take 12+ hours.

    What about NFS? Based on your experience, would you recommend it? Personally, I had some problems on NFS mounting/umounting due to its persistency nature. Maybe just ignorance of mine, never tried it on Oracle myself.


    You may think about using RMAN.
    You will then alter the database to applied archivelog.
    With RMAN you have the availability to perform Hot Backup to tape.
    With RMAN you can run a script that backups all the archivelog periodicly and clear them from the disk.
    Oh, I forgot to tell... Not 9i. Not even 8i. I think I'll shoot my head

    Our 9i databases already use RMAN with ARCHIVELOG and happilly they aren't an issue for now.
    Last edited by adrianomp; 04-13-2004 at 03:15 PM.
    An ounce of action is worth a ton of theory.
    —Friedrich Engels

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by adrianomp
    What about NFS? Based on your experience, would you recommend it? Personally, I had some problems on NFS mounting/umounting due to its persistency nature. Maybe just ignorance of mine, never tried it on Oracle myself.

    Archiving directly to NFS? Nope, wouldn't do it. NFS and automounter are too flaky to trust to a running database. Backing up to NFS? Sure, I do it every day. If my backup fails because NFS flakes out my database stays up and keeps servicing users. I can always re-run my backup. Just my $.02, though.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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