3 Replies Latest reply: Sep 23, 2013 11:32 PM by Anar Godjaev RSS

    RMAN Recovery Help

    Kanaiya Sindhavad

      Hi,

           Iam new to RAM Backup and Recovery

           Currently my HDD Faile and i try restore backup it gives me error hear i give the detail below

       

           Oracle 10gXE 10.2.0

           Upgrade to APEX Ver 3.2

       

          After Reinstall 10gXE 10.2.0 ., I try to restore old backup it give me error please help ,me

      Error log is below

       

      This operation will shut down and restore the database. Are you sure [Y/N]?y
      Restore in progress...
      The requested service has already been started.

      More help is available by typing NET HELPMSG 2182.


      Recovery Manager: Release 10.2.0.1.0 - Production on Fri Sep 20 19:51:08 2013

      Copyright (c) 1982, 2005, Oracle.  All rights reserved.

      connected to target database: XE (DBID=2678069288, not open)

      RMAN> set echo on;
      2> startup nomount pfile=C:\Users\ACER\AppData\Local\Temp\rman_dummy.ora force;
      3>
      echo set on

      Oracle instance started

      Total System Global Area     285212672 bytes

      Fixed Size                     1287016 bytes
      Variable Size                 92277912 bytes
      Database Buffers             188743680 bytes
      Redo Buffers                   2904064 bytes

      Recovery Manager complete.

      Recovery Manager: Release 10.2.0.1.0 - Production on Fri Sep 20 19:51:21 2013

      Copyright (c) 1982, 2005, Oracle.  All rights reserved.

      connected to target database: xe (not mounted)

      RMAN> set echo on;
      2> shutdown immediate;
      3> startup nomount pfile="C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\
      SPFILE2INIT.ORA";
      4> restore (spfile from autobackup) (controlfile from autobackup);
      5> startup mount force;
      6> configure controlfile autobackup off;
      7> restore database;
      8>
      echo set on

      using target database control file instead of recovery catalog
      Oracle instance shut down

      connected to target database (not started)
      Oracle instance started

      Total System Global Area     503316480 bytes

      Fixed Size                     1288264 bytes
      Variable Size                150996920 bytes
      Database Buffers             348127232 bytes
      Redo Buffers                   2904064 bytes

      Starting restore at 20-SEP-13
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: sid=36 devtype=DISK

      recovery area destination: C:\oraclexe\app\oracle\flash_recovery_area
      database name (or database unique name) used for search: XE
      channel ORA_DISK_1: autobackup found in the recovery area
      channel ORA_DISK_1: autobackup found: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA
      \XE\AUTOBACKUP\2013_09_10\O1_MF_S_825788285_92Y301PG_.BKP
      channel ORA_DISK_1: SPFILE restore from autobackup complete
      failover to previous backup

      recovery area destination: C:\oraclexe\app\oracle\flash_recovery_area
      database name (or database unique name) used for search: XE
      channel ORA_DISK_1: autobackup found in the recovery area
      channel ORA_DISK_1: autobackup found: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA
      \XE\AUTOBACKUP\2013_09_10\O1_MF_S_825788285_92Y301PG_.BKP
      channel ORA_DISK_1: control file restore from autobackup complete
      output filename=C:\ORACLEXE\ORADATA\XE\CONTROL.DBF
      Finished restore at 20-SEP-13

      Oracle instance started
      database mounted

      Total System Global Area     805306368 bytes

      Fixed Size                     1289996 bytes
      Variable Size                230686964 bytes
      Database Buffers             570425344 bytes
      Redo Buffers                   2904064 bytes

      old RMAN configuration parameters:
      CONFIGURE CONTROLFILE AUTOBACKUP ON;
      new RMAN configuration parameters:
      CONFIGURE CONTROLFILE AUTOBACKUP OFF;
      new RMAN configuration parameters are successfully stored

      Starting restore at 20-SEP-13
      Starting implicit crosscheck backup at 20-SEP-13
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: sid=35 devtype=DISK
      Crosschecked 5 objects
      Finished implicit crosscheck backup at 20-SEP-13

      Starting implicit crosscheck copy at 20-SEP-13
      using channel ORA_DISK_1
      Finished implicit crosscheck copy at 20-SEP-13

      searching for all files in the recovery area
      cataloging files...
      cataloging done

      List of Cataloged Files
      =======================
      File Name: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\AUTOBACKUP\2013_05_27\O
      1_MF_S_816529244_8T65CC5C_.BKP
      File Name: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\AUTOBACKUP\2013_05_28\O
      1_MF_S_816632777_8T9BGFWB_.BKP
      File Name: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\AUTOBACKUP\2013_08_09\O
      1_MF_S_823016025_909HQD7B_.BKP
      File Name: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\AUTOBACKUP\2013_09_10\O
      1_MF_S_825788285_92Y301PG_.BKP
      File Name: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\BACKUPSET\2013_05_27\O1
      _MF_NNNDF_TAG20130527T134120_8T65997T_.BKP
      File Name: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\BACKUPSET\2013_05_28\O1
      _MF_NNNDF_TAG20130528T182642_8T9BDCMK_.BKP
      File Name: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\BACKUPSET\2013_07_22\O1
      _MF_NNNDF_TAG20130722T180706_8YT9VMB8_.BKP

      using channel ORA_DISK_1

      channel ORA_DISK_1: starting datafile backupset restore
      channel ORA_DISK_1: specifying datafile(s) to restore from backup set
      restoring datafile 00001 to C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF
      restoring datafile 00002 to C:\ORACLEXE\ORADATA\XE\UNDO.DBF
      restoring datafile 00003 to C:\ORACLEXE\ORADATA\XE\SYSAUX.DBF
      restoring datafile 00004 to C:\ORACLEXE\ORADATA\XE\USERS.DBF
      restoring datafile 00005 to C:\ORACLEXE\ORADATA\XE\FLOW_1.DBF
      channel ORA_DISK_1: reading from backup piece C:\ORACLEXE\APP\ORACLE\FLASH_RECOV
      ERY_AREA\XE\BACKUPSET\2013_07_22\O1_MF_NNNDF_TAG20130722T180706_8YT9VMB8_.BKP
      channel ORA_DISK_1: restored backup piece 1
      piece handle=C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\BACKUPSET\2013_07_22\
      O1_MF_NNNDF_TAG20130722T180706_8YT9VMB8_.BKP tag=TAG20130722T180706
      channel ORA_DISK_1: restore complete, elapsed time: 00:00:55
      Finished restore at 20-SEP-13

      Recovery Manager complete.

      Recovery Manager: Release 10.2.0.1.0 - Production on Fri Sep 20 19:52:57 2013

      Copyright (c) 1982, 2005, Oracle.  All rights reserved.

      connected to target database: XE (DBID=2678069288, not open)

      RMAN> set echo on;
      2> alter database open resetlogs;
      3>
      echo set on

      using target database control file instead of recovery catalog
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of alter db command at 09/20/2013 19:53:05
      ORA-01152: file 1 was not restored from a sufficiently old backup
      ORA-01110: data file 1: 'C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF'

      Recovery Manager complete.
      ====================   ERROR =============================
               Restore of the database failed.
               RMAN Error - See log for details .
               Log file is at C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\OX
      E_RESTORE.LOG.
      ====================   ERROR =============================
      Press any key to continue . . .