4 Replies Latest reply: Jan 24, 2013 6:37 AM by EdStevens RSS

    How to clean redo log file?

    lxiscas
      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
          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
            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
              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
                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