1 2 Previous Next 15 Replies Latest reply: May 2, 2012 10:13 AM by Mody82 RSS

    RMAN 6053 & RMAN 6025  Unable to recover

    Mody82
      Dear all,

      I'm going to explain my issue.

      I have a production DB which is backed up daily including archives , and will be deleted from the server using " delete input " command.

      The problem is when I tried to do restore , I faced those two error ( Rman-6053 - Rman-6025 )
      --> RMAN 6053 unable to perform media recovery because of missing log
      --> RMAN 6025 no backup of log thread 1 sequence 11458 lowscn ......

      and when I checked the alert log file , I found :-
      --> Deleted Oracle managed file D:\ARCHIVE\2012_04_13\O1_MF_1_11458_7RK11G71_.ARC
      before it got backup , means backup will be taken at 18:00 , and archive has been deleted at 17:00

      So, what the reasons & assumptions that deleted this file.

      Best Regards
        • 1. Re: RMAN 6053 & RMAN 6025  Unable to recover
          kuljeet singh -
          appear you have flash recovery area define in database.

          please check the usage ,may be file deleted due to space pressure,also there is no of bugs regarding it.

          select * from v$flash_recovery_area_usage;
          select (SPACE_LIMIT/1024/1024/1024), (SPACE_USED/1024/1024/1024), (SPACE_RECLAIMABLE/1024/1024/1024) from v$recovery_file_dest;

          Have a look
          http://www.oraclefaq.net/2007/10/18/archive-log-automatically-getting-deleted-from-oracle-10g-database-with-omf/
          • 2. Re: RMAN 6053 & RMAN 6025  Unable to recover
            onedbguru
            I ran into that issue on a test box - how do you have your redundancy/recovery window defined? In my case, Apparently RMAN thought it had enough stuff to do the recovery, but as you see, rman thought that an archivelog that preceded the backup was not necessary and therefore backed up the file, deleted the file, then deleted the backup of that file.

            rman target /
            show all;

            To correct the situation, I run Full backups every other night (with archivelog NO DELETE INPUT), and then on the "off" nights backup/delete input the archivelogs. with a recovery window of 4 days. YConfiguationMV / YMMV. Since discovering this, I have been too busy with other stuff to go back and figure out the real problem. Since implementing this, I have restore and recovered this database several times using this configuration (to dev/test systems - production still runs fine.)

            Test Test Test.
            • 3. Re: RMAN 6053 & RMAN 6025  Unable to recover
              Mody82
              Dear Kuljeet Pal Singh      ,

              Thanks for your reply.

              As you said , I checkded
              • 4. Re: RMAN 6053 & RMAN 6025  Unable to recover
                Mody82
                Dear Kuljeet Pal Singh      ,

                The space of " db_recovery_file_dest_size " is 12G , and it never reached up to now 3G and the space on the disk is still available.

                and when I query ( select flashback_on from v$database ) it display NO.

                Here the Alert log file , plz read it :
                ----------------
                Tue Apr 17 18:58:58 2012
                Thread 1 advanced to log sequence 11694
                Current log# 2 seq# 11694 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MYDB\REDO02.LOG
                Thread 1 cannot allocate new log, sequence 11695
                Checkpoint not complete
                Current log# 2 seq# 11694 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MYDB\REDO02.LOG
                Thread 1 advanced to log sequence 11695
                Current log# 3 seq# 11695 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MYDB\REDO03.LOG
                Tue Apr 17 18:58:59 2012
                Deleted Oracle managed file D:\ARCHIVE\MYDB\ARCHIVELOG\2012_04_16\O1_MF_1_11667_7RRV20GD_.ARC
                Deleted Oracle managed file D:\ARCHIVE\MYDB\ARCHIVELOG\2012_04_16\O1_MF_1_11668_7RRVC65T_.ARC
                Tue Apr 17 19:00:48 2012
                --------------------------

                So, what did you think ?

                Regards
                • 5. Re: RMAN 6053 & RMAN 6025  Unable to recover
                  kuljeet singh -
                  post the output of below cmd
                  also check MOS note 4911954.8


                  select * from V$FLASH_RECOVERY_AREA_USAGE;

                  SELECT
                  name,
                  space_limit/(1073741824) AS space_limit_GB,
                  space_used/(1073741824) AS space_Used_GB,
                  space_reclaimable/(1073741824) AS Reclaimable_GB,
                  number_of_files FROM v$recovery_file_dest ;
                  • 6. Re: RMAN 6053 & RMAN 6025  Unable to recover
                    Mody82
                    First Query :---

                    FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
                    ------------ ------------------ ------------------------- ---------------
                    CONTROLFILE 0 0 0
                    ONLINELOG 0 0 0
                    ARCHIVELOG 1.49 0 4
                    BACKUPPIECE 0 0 0
                    IMAGECOPY 0 0 0
                    FLASHBACKLOG 0 0 0

                    6 rows selected.


                    Second Query :---

                    NAME
                    --------------------------------------------------------------------------------
                    SPACE_LIMIT_GB SPACE_USED_GB RECLAIMABLE_GB NUMBER_OF_FILES
                    -------------- ------------- -------------- ---------------
                    D:\Archive
                    12 .178582191 0 1.8447E+19

                    Really I'm in trouble & worried

                    Regards
                    • 7. Re: RMAN 6053 & RMAN 6025  Unable to recover
                      viconstg
                      Mody82 wrote:
                      Here the Alert log file , plz read it :
                      ----------------
                      Tue Apr 17 18:58:59 2012
                      Deleted Oracle managed file D:\ARCHIVE\MYDB\ARCHIVELOG\2012_04_16\O1_MF_1_11667_7RRV20GD_.ARC
                      Deleted Oracle managed file D:\ARCHIVE\MYDB\ARCHIVELOG\2012_04_16\O1_MF_1_11668_7RRVC65T_.ARC
                      Tue Apr 17 19:00:48 2012
                      --------------------------
                      You spoke that backup started at 18:00. We can see in alert.log that arclogs was deleted at 18:58:59. Perhaps it's just because these archivelogs was deleted within "delete input"? Try to recover these arclogs -- maybe they was backed up before deletion? Or simply exec in RMAN:

                      list backup of archivelog sequence between 11667 and 11668;
                      • 8. Re: RMAN 6053 & RMAN 6025  Unable to recover
                        Mody82
                        Dear viconstg ;

                        i just said 18:00 PM for example only , but really the archives deleted before taken backup , and when I issue the command " list backup of archivelog sequence between 11667 and 11668;"

                        It wasn't there , that means deleted.

                        This is the alert log file :
                        ---------------
                        Wed Apr 18 18:55:36 2012
                        Starting control autobackup
                        Wed Apr 18 18:55:43 2012
                        Errors in file c:\oracle\product\10.2.0\admin\MYDB\udump\MYDB_ora_8096.trc:

                        Wed Apr 18 18:55:43 2012
                        Errors in file c:\oracle\product\10.2.0\admin\mydb\udump\mydb_ora_8096.trc:

                        Wed Apr 18 18:55:43 2012
                        Errors in file c:\oracle\product\10.2.0\admin\mydb\udump\mydb_ora_8096.trc:

                        Control autobackup written to SBT_TAPE device
                        comment 'API Version 2.0,MMS Version 1.2.0.0',
                        media 'DD860HQ1.001.RO'
                        handle 'c-837325866-20120418-00'
                        Wed Apr 18 18:55:55 2012
                        Thread 1 cannot allocate new log, sequence 11721
                        Private strand flush not complete
                        Current log# 1 seq# 11720 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\mydb\REDO01.LOG
                        Thread 1 advanced to log sequence 11721
                        Current log# 2 seq# 11721 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\mydb\REDO02.LOG
                        Thread 1 advanced to log sequence 11722
                        Current log# 3 seq# 11722 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\mydb\REDO03.LOG
                        Wed Apr 18 18:56:00 2012
                        Deleted Oracle managed file D:\ARCHIVE\mydb\ARCHIVELOG\2012_04_17\O1_MF_1_11695_7RVF1CP2_.ARC
                        Deleted Oracle managed file D:\ARCHIVE\mydb\ARCHIVELOG\2012_04_17\O1_MF_1_11696_7RVHHQFB_.ARC
                        Wed Apr 18 18:57:42 2012
                        Starting control autobackup
                        Wed Apr 18 18:57:48 2012
                        Errors in file c:\oracle\product\10.2.0\admin\mydb\udump\mydb_ora_8096.trc:

                        Regards
                        • 9. Re: RMAN 6053 & RMAN 6025  Unable to recover
                          Mody82
                          Dear Kuljeet ,

                          Waiting your reply with solution , the case as it is , and some archives are deleted at the time of backup taken.

                          Regards
                          • 10. Re: RMAN 6053 & RMAN 6025  Unable to recover
                            Mody82
                            Dear colleagues

                            No one has give me solution up to now.

                            The archives still deleted daily , I have no idea so try to support me.

                            Regards
                            • 11. Re: RMAN 6053 & RMAN 6025  Unable to recover
                              viconstg
                              Please post the results of SHOW ALL from rman.
                              • 12. Re: RMAN 6053 & RMAN 6025  Unable to recover
                                Mody82
                                RMAN> show all;

                                using target database control file instead of recovery catalog
                                RMAN configuration parameters are:
                                CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
                                CONFIGURE BACKUP OPTIMIZATION OFF; # default
                                CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
                                CONFIGURE CONTROLFILE AUTOBACKUP ON;
                                CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
                                CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
                                CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
                                CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
                                CONFIGURE MAXSETSIZE TO UNLIMITED; # default
                                CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
                                CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
                                CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
                                CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFMYDB.ORA'; # default

                                RMAN>
                                • 13. Re: RMAN 6053 & RMAN 6025  Unable to recover
                                  viconstg
                                  Try to issue the command
                                  CONFIGURE RETENTION POLICY TO recovery window of 2 days;
                                  and check the unwanted deletion after this.
                                  • 14. Re: RMAN 6053 & RMAN 6025  Unable to recover
                                    Mody82
                                    Dear Viconstg

                                    Thanks for your support , I configured the retention policy to recovery of 2 days as you suggested.

                                    Today I'm going to perform the backup in the evening and will see if the archive log deleted or not.

                                    Any how I will inform you.

                                    Regards
                                    1 2 Previous Next