8 Replies Latest reply: Apr 21, 2013 11:11 AM by KR10822864 RSS

    RMAN-06023

    999256
      Hi,

      Oracle 10.2.0.5
      Solaris 10

      plan is backup and restore testing
      while restoring amfacing below problem, can please suggest how to proceed further.

      RMAN> restore datafile 28;

      Starting restore at 21 APR 2013 20:40:28
      using channel ORA_DISK_1

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of restore command at 04/21/2013 20:40:28
      RMAN-06026: some targets not found - aborting restore
      RMAN-06023: no backup or copy of datafile 28 found to restore
      RMAN>

      appricate your help.

      thanks.
        • 1. Re: RMAN-06023
          sb92075
          visu996253 wrote:
          Hi,

          Oracle 10.2.0.5
          Solaris 10

          plan is backup and restore testing
          while restoring amfacing below problem, can please suggest how to proceed further.

          RMAN> restore datafile 28;

          Starting restore at 21 APR 2013 20:40:28
          using channel ORA_DISK_1

          RMAN-00571: ===========================================================
          RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
          RMAN-00571: ===========================================================
          RMAN-03002: failure of restore command at 04/21/2013 20:40:28
          RMAN-06026: some targets not found - aborting restore
          RMAN-06023: no backup or copy of datafile 28 found to restore
          RMAN>

          appricate your help.

          thanks.
          you need an older backup file where/when datafile 28 existed.
          • 2. Re: RMAN-06023
            KR10822864
            post below command output.

            RMAN> list backup of datafile 28;
            • 3. Re: RMAN-06023
              999256
              KR10822864 wrote:
              post below command output.

              RMAN> list backup of datafile 28;
              thanks for reply.

              it is showing specification does not match any backup in the repository
              • 4. Re: RMAN-06023
                KR10822864
                ok then...

                please post below commands outputs.

                RMAN> list copy of datafile 28;
                RMAN> list backup;

                select file#, status, enabled,
                to_char(creation_time,'dd-Mon-yyyy hh24:mi:ss') creation_tm
                ,foreign_dbid, plugged_readonly,
                to_char(foreign_creation_time,'dd-Mon-yyyy hh24:mi:ss') foreign_cr_tm,
                plugin_change#
                from v$datafile
                where file# = 28;

                support.oracle.com
                • 5. Re: RMAN-06023
                  999256
                  RMAN> list copy of datafile 28;
                  it is showing specification does not match any backup in the repository
                  RMAN> list backup;
                  List of Datafiles in backup set 32
                  File LV Type Ckp SCN Ckp Time Name

                  28 Full 563444 20 APR 2013 20:04:10

                  result is too long ........
                  select file#, status, enabled,
                  to_char(creation_time,'dd-Mon-yyyy hh24:mi:ss') creation_tm
                  ,foreign_dbid, plugged_readonly,
                  to_char(foreign_creation_time,'dd-Mon-yyyy hh24:mi:ss') foreign_cr_tm,
                  plugin_change#
                  from v$datafile
                  where file# = 28;
                  FILE# STATUS ENABLED CREATION_TM FOREIGN_DBID PLU FOREIGN_CR_TM PLUGIN_CHANGE#
                  ----------------------------------------------------------------------------------------------------------------------------------------------
                  28 ONLINE READ ONLY 20-Apr-2013 08:55:04 552936878 YES 20-Apr-2013 08:55:04 568809
                  • 6. Re: RMAN-06023
                    KR10822864
                    according to above results 28 datafile was in fact a plugged in datafile, and there has been no backups taken after the pluggin operation.
                    The PLUGIN_CHANGE# (568809) is higher than the 'Ckp SCN' (563444) from the backup.
                    So you need to plugin the datafile again from its source, then proceed what ever you want.

                    refer below notes for more info.

                    NOTE:1366610.1 - Common Causes for RMAN-06023
                    • 7. Re: RMAN-06023
                      999256
                      NOTE:1366610.1 - Common Causes for RMAN-06023
                      thanks for sharing MOS notes.
                      • 8. Re: RMAN-06023
                        KR10822864
                        wc :)

                        Also don't forget to close this thread if your issue is resolved