Results 1 to 2 of 2

Thread: Archive

  1. #1
    Join Date
    Jun 2003
    Posts
    45

    Unanswered: Archive

    Hi all,

    In a Production Database,Archive log destination is full.
    What is the immediate action should a dba need to take?

    Regards
    sudheer

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    The first step is to chage the Archive log destination using ALTER SYSTEM SET Archive_log_dest = /your/new/temp/dest.
    So that your database can be started back with a negligible downtime.

    Later, you have to back up the archived log filed from the old destination and then make it empty to use it again.
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

Posting Permissions

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