5 Replies Latest reply: Jan 25, 2014 3:49 PM by Nelson Calero RSS

    Recover database using cold backup

    Avadhut

      Hi All,

       

      One of the table is delete by one of our DBA from PROD accidentally. We have a cold backup on one day before.

       

      Now we are trying to restore it from the cold backup. PROD DB is in archivelog and all the archive is in tact.

       

      The table got truncated today at 8 PM. Can we apply the database till 8 PM so that we can restore the truncated table using cold backup.

       

      Please find the below steps which we are using to restore.

       

      creating controlfile

      starting the db in mount state

      recover database;

      Will it ask for latest archive log when we try to recover it.

       

      ENV details -

      DB - 11.2.0.1

       

      Please suggest.

       

      Thanks