Skip to Content
author's profile photo Former Member
Former Member

How to MOVE the ARCHIVE LOG files on unix OS.

Dear all,

we have sceduled a job for every 4 hours , that writes the offline redolog files(archived logs) to the other disk.

we have faced a situation that with in the periond of 4 hrs. ORAARCH directory got filled. ... so <b>no user is able to login</b>.

Now how to <b>move some of these files to the target disk MANUALLY at OS(UNIX)</b> level

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Posted on Nov 28, 2007 at 04:08 PM

    run the job you run... but manually...

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 28, 2007 at 04:14 PM

    the Unix move command is "mv".

    so you can login to your Unix box as orasid (replace sid with your SID in lowercase).

    find a dir that has free space (depend on which flavor of Unix you have you can either do "df" or "bdf" to see which file system has enough free space).

    let's assume /oracle/stage has 10GB free space, type in this:

    mkdir /oracle/stage/oraarch

    mv /oracle/SID/oraarch/*.dbf /oracle/stage/oraarch/

    HOWEVER, make sure that you will backup this separate directory in some way. The ordinary brarchive or RMAN backup won't backup archive logs in other dir. So if you Manually moved these archive logs but do not Manually back them up, you won't be able to recover with these files in case you need to.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Just a note of caution here...

      If you you mv and the target filesystem happens to fill up...you've just lost that archivelog that was being moved.

      I usually perform a copy then rm (after verifying the file exist on the target).

      Alternatively, you can simply modify your log destination on the fly.

      This will direct the Oracle Archiver process to archive to the new destination...

      This gives you breathing room to clean up the issue...

      This does not address your root cause though...

      1) Is your archive directory too small?

      2) Do you know why you are generating these spurious logs? i.e. is there a runaway process or is the DB still in hot mode, etc...

  • author's profile photo Former Member
    Former Member
    Posted on Dec 02, 2007 at 07:00 AM

    You can move the archived logs manually to free up space, but the recommended way is to temporary direct the archive destination to another directory. And if you use Brtools 7.00 and above, the Brarchive is able to locate and backup archived logs in different directories, thus preventing any gaps from occuring. Reference note : 391

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 02, 2007 at 11:45 AM

    Hello Siva,

    the following solution maybe the best.

    1) Create an auto-reaction method in the ccms for the archiving with an external system command (command: "mv $ORACLE_HOME/oraarch/* /<SAVE_DIRECTORY">

    2) Monitor the archivelog filesystem by CCMS and if a defined fill grade is reached you run the auto-reaction method

    In other ways you can also include the brtools in this scenario (instead of moving the archivelogs)

    Regards

    Stefan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 03, 2007 at 03:36 PM

    I guess most people have given the right answer but I will append mine as well from personal experience:

    Move the offline redo log files temporarely to a temp directory and then run the job again (manually) to free up some space.

    Why do not you consider running the job more frequent, every 2 hours for example?

    We run a similar one every 2 hours and if no offline redo logs are available (due to low activity) then the job reported as "missed".

    Rgds,

    Loukas

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 03:13 PM

    Hi siva,

    You can use the below command for moving files at Unix level.

    The below command should be executed with ora<sid> user.

    mv <filename> <target directory>

    Its better if you move only those files which have been saved earlier in your backup.

    Once there is enough space in the oraarch directory, you can trigger the redo log backup once more - to initiate your back up procedure

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.