1 2 3 4 5 Previous Next 68 Replies Latest reply: Apr 16, 2012 5:37 AM by __OUTSIDER___ Go to original post RSS
      • 15. Re: RMAN duplicate database
        __OUTSIDER___
        Nikolay Ivankin  wrote:
        __OUTSIDER___ wrote:
        This file */storage/oracle_RBS_backup/RBS/archivelog/2012_03_23/o1_mf_1_22139_%u_.arc*
        doesn't exist. It is very old and I don't realize how and whence can I restore it.
        If you have backed up archivelog, then you can restore it.
        No I can't.
        RMAN> restore archivelog sequence 22139
        2> ;
        
        Starting restore at 23-MAR-12
        allocated channel: ORA_DISK_1
        channel ORA_DISK_1: sid=51 devtype=DISK
        
        RMAN-00571: ===========================================================
        RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
        RMAN-00571: ===========================================================
        RMAN-03002: failure of restore command at 03/23/2012 11:35:27
        RMAN-06026: some targets not found - aborting restore
        RMAN-06025: no backup of log thread 1 seq 22139 lowscn 727227244 found to restore
        • 16. Re: RMAN duplicate database
          NikolayIvankin
          __OUTSIDER___ wrote:
          Nikolay Ivankin  wrote:
          __OUTSIDER___ wrote:
          This file */storage/oracle_RBS_backup/RBS/archivelog/2012_03_23/o1_mf_1_22139_%u_.arc*
          doesn't exist. It is very old and I don't realize how and whence can I restore it.
          If you have backed up archivelog, then you can restore it.
          No I can't.
          RMAN> restore archivelog sequence 22139
          2> ;
          
          Starting restore at 23-MAR-12
          allocated channel: ORA_DISK_1
          channel ORA_DISK_1: sid=51 devtype=DISK
          
          RMAN-00571: ===========================================================
          RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
          RMAN-00571: ===========================================================
          RMAN-03002: failure of restore command at 03/23/2012 11:35:27
          RMAN-06026: some targets not found - aborting restore
          RMAN-06025: no backup of log thread 1 seq 22139 lowscn 727227244 found to restore
          So you are able to restore/recover only until seq 22139.
          • 17. Re: RMAN duplicate database
            __OUTSIDER___
            Nikolay Ivankin  wrote:
            __OUTSIDER___ wrote:
            Nikolay Ivankin  wrote:
            __OUTSIDER___ wrote:
            This file */storage/oracle_RBS_backup/RBS/archivelog/2012_03_23/o1_mf_1_22139_%u_.arc*
            doesn't exist. It is very old and I don't realize how and whence can I restore it.
            If you have backed up archivelog, then you can restore it.
            No I can't.
            RMAN> restore archivelog sequence 22139
            2> ;
            
            Starting restore at 23-MAR-12
            allocated channel: ORA_DISK_1
            channel ORA_DISK_1: sid=51 devtype=DISK
            
            RMAN-00571: ===========================================================
            RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
            RMAN-00571: ===========================================================
            RMAN-03002: failure of restore command at 03/23/2012 11:35:27
            RMAN-06026: some targets not found - aborting restore
            RMAN-06025: no backup of log thread 1 seq 22139 lowscn 727227244 found to restore
            So you are able to restore/recover only until seq 22139.
            Sorry but seq 22139 is generated at 10/11/2011. Why Oracle wants this very old log ?
            • 18. Re: RMAN duplicate database
              NikolayIvankin
              Perhaps you have very old backup of control file.
              Make sure, that all files are current in backup.
              • 19. Re: RMAN duplicate database
                __OUTSIDER___
                Nikolay Ivankin  wrote:
                Perhaps you have very old backup of control file.
                Make sure, that all files are current in backup.
                So I need to delete controlfile backup and recreate again ?
                • 20. Re: RMAN duplicate database
                  NikolayIvankin
                  __OUTSIDER___ wrote:
                  Nikolay Ivankin  wrote:
                  Perhaps you have very old backup of control file.
                  Make sure, that all files are current in backup.
                  So I need to delete controlfile backup and recreate again ?
                  Yes.
                  • 21. Re: RMAN duplicate database
                    __OUTSIDER___
                    Thanks , but I found that in my current controlfile also contain this record.
                    I tried with rman expired, obsolete command but nothing. Did you know how can I delete old records from
                    current controlfile ?
                    • 22. Re: RMAN duplicate database
                      CKPT
                      >
                      SQL> recover database using backup controlfile until cancel
                      ORA-00279: change 727227244 generated at 10/11/2011 17:57:36 needed for thread
                      1
                      ORA-00289: suggestion :
                      */storage/oracle_RBS_backup/RBS/archivelog/2012_03_23/o1_mf_1_22139_%u_.arc*
                      >

                      Sorry for delay response, Just now i checked your update.

                      Controlfile is requesting for the sequence *22139* , can you check the time stamp of it?

                      SQL> select to_char(completion_time,'DD-MON-YYYY HH24:MI:SS') from v$archived_log where sequence#=22139;

                      Have you restore backup from Tapes? Can you refer your RMAN restore log file whether it failed to previous backups?

                      Thanks.
                      • 23. Re: RMAN duplicate database
                        __OUTSIDER___
                        Thanks for you help.
                        CKPT wrote:
                        Controlfile is requesting for the sequence *22139* , can you check the time stamp of it?

                        SQL> select to_char(completion_time,'DD-MON-YYYY HH24:MI:SS') from v$archived_log where sequence#=22139;
                        SQL> select to_char(completion_time,'DD-MON-YYYY HH24:MI:SS')
                        from v$archived_log where sequence#=22139;  2
                        
                        TO_CHAR(COMPLETION_T
                        --------------------
                        11-OCT-2011 17:58:09
                        Have you restore backup from Tapes? Can you refer your RMAN restore log file whether it failed to previous backups?
                        Last backup was successfully finished. This DB in archive log mode during last one year but I deleted
                        usually archivelogs. So now Oracle requests very old log file which I don't have. I found in control file records
                        about this log. So is there any way to delete that old record from control file?
                        • 24. Re: RMAN duplicate database
                          CKPT
                          from v$archived_log where sequence#=22139; 2

                          TO_CHAR(COMPLETION_T
                          --------------------
                          11-OCT-2011 17:58:09

                          So it points to very old archive log file,
                          Have you restore backup from Tapes? Can you refer your RMAN restore log file whether it failed to previous backups?
                          Last backup was successfully finished. This DB in archive log mode during last one year but I deleted
                          usually archivelogs. So now Oracle requests very old log file which I don't have. I found in control file records
                          about this log. So is there any way to delete that old record from control file?
                          Is this enabled FRA, any old backups exist in this FRA location? Cleanup FRA & when you start restore It will mention the handle from where it is reading that piece. Based on that handle use below query to find out time, So that you can track are you able to restore from the latest backup or not.

                          So first cleanup FRA better if you disable Once after performing duplicate you can enable it back. Also if possible post your RMAN log file here check for messages "Falied to previous backup"

                          Check your log file and find out what is the handle
                          SQL> select completion_time from v$backup_piece_details where handle='&handle';
                          • 25. Re: RMAN duplicate database
                            __OUTSIDER___
                            Before duplication I cleaned everything. I did backup database plus archivelog. After backup I started with
                            duplication. So FRA contain archivelogs, datafilecopys and autobackup files generated during database backup. All these files are fresh I don't have anything old. I want understand why RMAN wants this old file..... because records about that old file exists in control file ?
                            • 26. Re: RMAN duplicate database
                              CKPT
                              __OUTSIDER___ wrote:
                              Before duplication I cleaned everything. I did backup database plus archivelog. After backup I started with
                              duplication. So FRA contain archivelogs, datafilecopys and autobackup files generated during database backup. All these files are fresh I don't have anything old. I want understand why RMAN wants this old file..... because records about that old file exists in control file ?
                              RMAN asking archive log file for before 5 months. which is weird.
                              I previously asked about RMAN log file and handle completion time, you havent checked that and posted too.

                              Always after successful backup perform test as below.

                              1) Restore controlifle
                              2) Mount & RMAN> restore database preview;

                              So you can validate your backup.

                              So either refer log file an try to find out handle completion time or perform new backup and duplication too.
                              • 27. Re: RMAN duplicate database
                                __OUTSIDER___
                                CKPT wrote:
                                __OUTSIDER___ wrote:
                                Before duplication I cleaned everything. I did backup database plus archivelog. After backup I started with
                                duplication. So FRA contain archivelogs, datafilecopys and autobackup files generated during database backup. All these files are fresh I don't have anything old. I want understand why RMAN wants this old file..... because records about that old file exists in control file ?
                                RMAN asking archive log file for before 5 months. which is weird.
                                I previously asked about RMAN log file and handle completion time, you havent checked that and posted too.
                                Sorry where can I find RMAN log ?
                                • 28. Re: RMAN duplicate database
                                  CKPT
                                  Sorry where can I find RMAN log ?
                                  Have you run RMAN in background? If so where you scheduled?

                                  If you run on console, if history exist then scrolldown. if doesnt exist really i cant help.
                                  Start for Backup + RMAN duplicate from scratch
                                  • 29. Re: RMAN duplicate database
                                    __OUTSIDER___
                                    CKPT wrote:
                                    Sorry where can I find RMAN log ?
                                    Have you run RMAN in background? If so where you scheduled?

                                    If you run on console, if history exist then scrolldown. if doesnt exist really i cant help.
                                    Start for Backup + RMAN duplicate from scratch
                                    OK thanks , I will backup and duplicate again and post all steps but I thing something wrong with this DB because
                                    during DB backup nothing is wrong, everything is fine. Do you know some command that can clean this old
                                    information from controlfile ?