ORA-01113: file 21 needs media recovery

  • Hello all,

    I am receiving this error for a specific Datafile which is offline.

    I am trying to change it to online but I receive another error.

    My DB is in Archivelog and I have a full backup saved in a disk and many Differential backup sotred in the storage.

    In order to do:

    SQL>recover datafile 'C:\DB11\ORADATA\DB11\Example01.dbf';

    do I have to shutdown the DB first or what command do I have to give first?

    thanks in advance

    Mimas

  • I tried to do the recovery of the Datafile but I receive an error saying that a specific Archive log is missing (6335).

    What can I do now?

    thnx

    Mimas

  • Hi,

    Are you sure that this error is happening in Microsoft SQL Server? Error seems like Oracle?

    Regards,
    Sakthi
    My Blog -> http://www.sqlserverdba.co.cc

  • Yes it is in Oracle 10g.

    Am I in a wrong forum?

  • gpet (10/9/2008)


    Yes it is in Oracle 10g.

    Am I in a wrong forum?

    Yes. This forum is dedicated to Microsoft's SQL Server.

    May I suggest DBForums[/url] as they have an Oracle section.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply