4 Replies Latest reply: Jun 8, 2011 1:10 PM by Chinar RSS

    Recovery in Archive log

    AAP
      Hi,

      how to recover from the loss of datafile if the DB is running in archive log mode...
      Please some one give the steps...

      Thanks & Regards..
        • 1. Re: Recovery in Archive log
          BPeaslandDBA
          The recovery steps required to fix this situation depend on your backup steps. How do you backup your database?

          Cheers,
          Brian
          • 2. Re: Recovery in Archive log
            CKPT
            how to recover from the loss of datafile if the DB is running in archive log mode...
            Please some one give the steps...
            if from RMAN

            1) RMAN> restore datafile <file#>;

            from rman or from sql.
            2) RMAN> recover datafile <file#>;
            • 3. Re: Recovery in Archive log
              Aman....
              859678 wrote:
              Hi,

              how to recover from the loss of datafile if the DB is running in archive log mode...
              Please some one give the steps...

              Thanks & Regards..
              Please read the backup and recovery guide,
              http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmquick.htm#i999413

              Aman....
              • 4. Re: Recovery in Archive log
                Chinar
                how to recover from the loss of datafile if the DB is running in archive log mode...
                Just running archive log mode is not satisfy.Do you have backup of this datafile if yes then issue RESTORE DATAFILE <DATA FILE NO>;RECOVER DATAFILE <DATA FILE NO> or if you use user managed backup then restore that backup and issue RECOVER DATAFILE <DATA FILE NO> through sqlplus.But if you do not have backup of this dataflile then thare rest one way also(if your datafile created after creating control file),you can ALTER DATABASE CREATE DATAFILE 'FILE PATH ' AS 'FILE PATH ' and issue RECOVER DATAFILE 'FILE PATH ' through sqlplus.