RMAN-06059: expected archived log not found

RMAN-06059: expected archived log not found

RMAN attempted to backup an archive log file, but couldn’t find it.

This can happen for a variety of reasons; the file has been manually moved or deleted, the archive log destination has recently been changed, the file has been compressed, etc.

Starting backup at 26-JUL-12
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 07/26/2012 22:55:32
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /app/oracle/product/10.2/dbs/arch1_1_781981525.dbf
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

Your options are either to restore the missing file(s), or to perform a crosscheck. To perform a crosscheck, run the following command from within RMAN:

change archivelog all crosscheck;
It is advisable to perform a full backup of the database at this point.

When an archive log crosscheck is performed, RMAN checks each archive log in turn to make sure that it exists on disk (or tape). Those that are missing are marked as unavailable. If you have got missing logs, this won’t bring them back. It will allow you to get past this error and back-up the database though.

Advertisements

About mpoojari
Oracle Database/Applications Administrator

8 Responses to RMAN-06059: expected archived log not found

  1. jytdeepa says:

    Hi Mohan, I am trying to install DB 11GR2 (11.2.0.3.0) on Windows Server 2008 R2 Data Cener and I am getting below error :

    PRKN-1019 : Failed to create directory “C:\Users\username\AppData\Local\Temp\2\\oraremservice\” on node “hostname” Error: “0|Logon failure: unknown user name or bad password.

    Please help me to resolve this issue. Really appreciate your help.

    thanks
    Jyothi

    • mpoojari says:

      Hi Jyothi

      Perform try the following steps :
      Stop the OracleRemExecService.
      Stop the dbconsole process and EMagent:
      emctl stop dbconsole

      Let me know if the above workaround helps.

      Thanks Mohan

      • jytdeepa says:

        Mohan, thank you for getting back to me. It is brand new AWS instance having windows 2008 R2 Datacenter OS. Nothing installed in that. DB is the first software I am trying to install.

        thanks
        Jyothi

      • mpoojari says:

        Hi Jyothi

        Oracle Database 11.2.0.3.0 is certified on Microsoft Windows x64 (64-bit) 2008 R2

        Have you crosschecked all the pre-requisities and permissions required to create files/directories on C: drive.

        Thanks

        Mohan

  2. jytdeepa says:

    Hi Mohan, I logged in as Administrator and installing as Administrator. I should be good regarding permissions right ? Is there anything specially I need to look into it regarding the privileges for Administrator to install database ?

    Please let me know.

    thanks
    Jyothi

  3. jytdeepa says:

    Mohan, I thought it could be false notification by oracle precheck..and I continued with installation..but now at 90% installation point, it is taking more than an hour to respond…..
    so, it may not be false notification…looks like there is something missing in the OS setup…

    thank you
    Jyoth

  4. jytdeepa says:

    please ignore my issues… it is realted to low memory…I never thought low memory will lead to misleading errors like this :-).

    thanks
    Jyothi

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: