This discussion is archived
4 Replies Latest reply: Jan 24, 2013 4:37 AM by EdStevens RSS

How to clean redo log file?

lxiscas Newbie
Currently Being Moderated
Hi, guys:

I need to migrate data from external tables to normal tables. But the connection is always frozen half the way of executing script. The error message is ORA-00257. it looks redo log file is full. I tried to delete redo log file with RMAN, but I got this error message:

delete archivelog until time 'trunc(sysdate)';

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=43 device type=DISK
specification does not match any archived log in the repository

Any suggestion would be appreciated.

Sam
  • 1. Re: How to clean redo log file?
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Did you check MOS notes :
    How to Resolve ORA-00257: Archiver is Stuck Error in 10g and higher [ID 278308.1]

    also use
    backup archivelog all delete input
  • 2. Re: How to clean redo log file?
    damorgan Oracle ACE Director
    Currently Being Moderated
    No database version.
    No alert log excerpt.
    No code showing how you are "migrating".

    I see No way we can help you at this time.

    Please post ALL relevant information such that someone can try to replicate the problem.
  • 3. Re: How to clean redo log file?
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    The message indicates that there are no known archivelogs to delete.

    I hope that you ensure that archivelogs are backed up before they are deleted.


    Hemant K Chitale
  • 4. Re: How to clean redo log file?
    EdStevens Guru
    Currently Being Moderated
    lxiscas wrote:
    Hi, guys:

    I need to migrate data from external tables to normal tables. But the connection is always frozen half the way of executing script. The error message is ORA-00257. it looks redo log file is full. I tried to delete redo log file with RMAN, but I got this error message:
    Sounds like you are confusing (online) redo logs with "archivelogs" (archived redo logs).

    You don't delete redo logs at all. You can delete archivelogs with rman, which is what your command is trying to do. Do you ever backup the archivelogs? A proper backup/recovery policy would backup the archivelogs on at least a daily (if not more often) basis, and delete them after they are backed up. That will keep the archivelog destination from filling up in all but the most extreme circumstances.
    delete archivelog until time 'trunc(sysdate)';

    using target database control file instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=43 device type=DISK
    specification does not match any archived log in the repository

    Any suggestion would be appreciated.

    Sam

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points