13 Replies Latest reply: Mar 21, 2013 2:07 PM by 617177 RSS

    Restore incremental backup to another server

    617177
      Hello, I'm trying to restore incremental level 0 backup to a new server, but RMAN says that is missing the first 5 files that is exactly the oracle default tablespaces.

      I've double checked the copied files and all then is ok and all of then are there, but the validate database restore command doesn't find then.

      Please give some advice.

      Thanks a lot.

      Carlos
        • 1. Re: Restore incremental backup to another server
          Mihael
          Hello, I'm trying to restore incremental level 0 backup to a new server, but RMAN says that is missing the first 5 files that is exactly the oracle default tablespaces.

          I've double checked the copied files and all then is ok and all of then are there, but the validate database restore command doesn't find then.
          Check the following:

          rman> list backup;
          rman> list copy;
          rman> crosscheck backup;
          rman> crosscheck copy;
          • 2. Re: Restore incremental backup to another server
            CKPT
            Hello, I'm trying to restore incremental level 0 backup to a new server, but RMAN says that is missing the first 5 files that is exactly the oracle default tablespaces.
            I've double checked the copied files and all then is ok and all of then are there, but the validate database restore command doesn't find then.
            Please do specify your database version.
            Which procedure you are using? Is it RMAN restore (or) duplicate?

            if you are using RMAN duplicate ensure the backups are in same location.

            If you are using only RMAN restore, if your backups are in different location than source, Then you have to register those backups by "RMAN> catalog start with 'backup location';" after you restore & mount the control file. Once you register them , You can go ahead and restore database. You can also issue this command after you mount to check whether those backups are available to restore or not "RMAN> Restore database preview"
            • 3. Re: Restore incremental backup to another server
              617177
              ok, thanks for your interest. As my database language is Portuguese, I've translated some few answers for your commands.

              Microsoft Windows [versão 6.0.6001]
              Copyright (c) 2006 Microsoft Corporation. Todos os direitos reservados.

              C:\Users\Administrador>rman target /

              Gerenciador de RecuperaþÒo: Release 11.2.0.1.0 - Production on Sßb Mar 2 16:28:10 2013

              Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

              conectado ao banco de dados de destino: ORCL (DBID=1268632144, nÒo aberto)

              RMAN> list backup;

              usar o arquivo de controle do banco de dados de destino em vez do catßlogo de recuperaþÒo

              Lista de Conjuntos de Backup
              ===================


              BS Key Type LV Size Device Type Elapsed Time Horßrio de ConclusÒo
              ------- ---- -- ---------- ----------- ------------ --------------------
              2657 Full 12.20M DISK 00:00:01 27/02/13
              Chave BP: 2808 Status: EXPIRED Compactado: NO Tag: TAG20130227T005823
              Nome do Componente: F:\APP\USER\RECOVERY_AREA\ORCL\BACKUPSET\C-1268632144-20130227-00
              Arquivo de Controle IncluÝdo: SCN Ckp: 159053110 Tempo Ckp: 27/02/13

              Tamanho da Chave BS Tipo de Dispositivo Tempo Decorrido Horßrio de ConclusÒo
              ------- ---------- ----------- ------------ --------------------
              2666 1.83G DISK 00:00:00 28/02/13
              Chave BP: 2825 Status: AVAILABLE Compactado: NO Tag: NIVEL-0
              Nome do Componente: H:\TEMP\2013_02_28\O1_MF_ANNNN_NIVEL_0_8LXL6HXS_.BKP

              Lista de Logs Arquivados no conjunto de backup 2666
              Thrd Seq Low SCN Tempo Inferior Next SCN Next Time
              ---- ------- ---------- -------------- ---------- ---------
              1 9788 158490347 24/02/13 158502800 24/02/13
              1 9789 158502800 24/02/13 158535814 24/02/13
              1 9790 158535814 24/02/13 158536480 24/02/13
              1 9791 158536480 24/02/13 158548862 24/02/13
              1 9792 158548862 24/02/13 158577864 24/02/13
              1 9793 158577864 24/02/13 158609476 24/02/13
              1 9794 158609476 24/02/13 158650712 24/02/13
              1 9795 158650712 24/02/13 158665884 24/02/13
              1 9796 158665884 24/02/13 158669504 24/02/13
              1 9797 158669504 24/02/13 158692486 24/02/13
              1 9798 158692486 24/02/13 158701015 25/02/13
              1 9799 158701015 25/02/13 158703909 25/02/13
              1 9800 158703909 25/02/13 158720567 25/02/13
              1 9801 158720567 25/02/13 158734560 25/02/13
              1 9802 158734560 25/02/13 158746975 25/02/13
              1 9803 158746975 25/02/13 158759698 25/02/13
              1 9804 158759698 25/02/13 158772202 25/02/13
              1 9805 158772202 25/02/13 158786026 25/02/13
              1 9806 158786026 25/02/13 158799494 25/02/13
              1 9807 158799494 25/02/13 158805217 25/02/13
              1 9808 158805217 25/02/13 158827263 25/02/13
              1 9809 158827263 25/02/13 158847619 25/02/13
              1 9810 158847619 25/02/13 158852298 26/02/13
              1 9811 158852298 26/02/13 158857485 26/02/13
              1 9812 158857485 26/02/13 158880023 26/02/13
              1 9813 158880023 26/02/13 158891488 26/02/13
              1 9814 158891488 26/02/13 158902639 26/02/13
              1 9815 158902639 26/02/13 158914837 26/02/13
              1 9816 158914837 26/02/13 158926047 26/02/13
              1 9817 158926047 26/02/13 158937551 26/02/13
              1 9818 158937551 26/02/13 158958135 26/02/13
              1 9819 158958135 26/02/13 158970319 26/02/13
              1 9820 158970319 26/02/13 158981847 26/02/13
              1 9821 158981847 26/02/13 158985420 26/02/13
              1 9822 158985420 26/02/13 159007542 26/02/13
              1 9823 159007542 26/02/13 159026222 26/02/13
              1 9824 159026222 26/02/13 159048780 27/02/13
              1 9825 159048780 27/02/13 159053095 27/02/13
              1 9826 159053095 27/02/13 159064587 27/02/13
              1 9827 159064587 27/02/13 159075469 27/02/13
              1 9828 159075469 27/02/13 159087429 27/02/13
              1 9829 159087429 27/02/13 159098009 27/02/13
              1 9830 159098009 27/02/13 159108891 27/02/13
              1 9831 159108891 27/02/13 159118609 27/02/13
              1 9832 159118609 27/02/13 159135892 27/02/13
              1 9833 159135892 27/02/13 159146282 27/02/13
              1 9834 159146282 27/02/13 159161283 27/02/13
              1 9835 159161283 27/02/13 159188028 27/02/13
              1 9836 159188028 27/02/13 159202385 27/02/13
              1 9837 159202385 27/02/13 159218373 27/02/13
              1 9838 159218373 27/02/13 159224332 28/02/13

              Tamanho da Chave BS Tipo de Dispositivo Tempo Decorrido Horßrio de ConclusÒo
              ------- ---------- ----------- ------------ --------------------
              2667 71.47M DISK 00:00:00 28/02/13
              Chave BP: 2826 Status: AVAILABLE Compactado: NO Tag: NIVEL-0
              Nome do Componente: H:\TEMP\2013_02_28\O1_MF_ANNNN_NIVEL_0_8LY3PFQG_.BKP

              Lista de Logs Arquivados no conjunto de backup 2667
              Thrd Seq Low SCN Tempo Inferior Next SCN Next Time
              ---- ------- ---------- -------------- ---------- ---------
              1 9839 159224332 28/02/13 159236336 28/02/13
              1 9840 159236336 28/02/13 159246762 28/02/13

              BS Key Type LV Size Device Type Elapsed Time Horßrio de ConclusÒo
              ------- ---- -- ---------- ----------- ------------ --------------------
              2671 Incr 0 32.00G DISK 00:00:00 28/02/13
              Lista de Arquivos de Dados no conjunto de backup 2671
              File LV Type Ckp SCN Tempo de Verif. Name
              ---- -- ---- ---------- --------------- ----
              6 0 Incr 159224737 28/02/13 F:\APP\USER\ORADATA\ORCL\SGO_01.DBF

              C¾pia do Conjunto de Backup n·m. 1 do conjunto de backup 2671
              Tipo de Dispositivo Tempo Decorrido Horßrio de ConclusÒo Tag Compactada
              ----------- ------------ -------------------- ---------- ---
              DISK 00:00:00 02/03/13 NO TAG20130228T000915

              Lista de Itens de Backup do conjunto de backup 2671 No. da C¾pia1
              BP Key Pc# Status Piece Name
              ------- --- ----------- ----------
              2827 1 AVAILABLE H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LXLLW0Z_.BKP
              2828 2 AVAILABLE H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LXMPZY8_.BKP
              2829 3 AVAILABLE H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LXNRXG5_.BKP
              2830 4 AVAILABLE H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LXPHS9R_.BKP

              BS Key Type LV Size Device Type Elapsed Time Horßrio de ConclusÒo
              ------- ---- -- ---------- ----------- ------------ --------------------
              2674 Incr 0 24.49G DISK 00:00:00 28/02/13
              Lista de Arquivos de Dados no conjunto de backup 2674
              File LV Type Ckp SCN Tempo de Verif. Name
              ---- -- ---- ---------- --------------- ----
              7 0 Incr 159230797 28/02/13 F:\APP\USER\ORADATA\ORCL\SGO_02.DBF

              C¾pia do Conjunto de Backup n·m. 1 do conjunto de backup 2674
              Tipo de Dispositivo Tempo Decorrido Horßrio de ConclusÒo Tag Compactada
              ----------- ------------ -------------------- ---------- ---
              DISK 00:00:00 02/03/13 NO TAG20130228T000915

              Lista de Itens de Backup do conjunto de backup 2674 No. da C¾pia1
              BP Key Pc# Status Piece Name
              ------- --- ----------- ----------
              2831 1 AVAILABLE H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LXPSO9R_.BKP
              2832 2 AVAILABLE H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LXRWG3F_.BKP
              2833 3 AVAILABLE H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LXT3CVC_.BKP

              BS Key Type LV Size Device Type Elapsed Time Horßrio de ConclusÒo
              ------- ---- -- ---------- ----------- ------------ --------------------
              2675 Incr 0 11.41G DISK 00:00:00 28/02/13
              Chave BP: 2834 Status: AVAILABLE Compactado: NO Tag: TAG20130228T000915
              Nome do Componente: H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LXTVPBQ_.BKP
              Lista de Arquivos de Dados no conjunto de backup 2675
              File LV Type Ckp SCN Tempo de Verif. Name
              ---- -- ---- ---------- --------------- ----
              1 0 Incr 159235548 28/02/13 F:\APP\USER\ORADATA\ORCL\SYSTEM01.DBF
              2 0 Incr 159235548 28/02/13 F:\APP\USER\ORADATA\ORCL\SYSAUX01.DBF
              3 0 Incr 159235548 28/02/13 F:\APP\USER\ORADATA\ORCL\UNDOTBS01.DBF
              4 0 Incr 159235548 28/02/13 F:\APP\USER\ORADATA\ORCL\USERS01.DBF
              5 0 Incr 159235548 28/02/13 F:\APP\USER\ORADATA\ORCL\EXAMPLE01.DBF
              11 0 Incr 159235548 28/02/13 F:\APP\USER\ORADATA\ORCL\SGO_06.DBF
              12 0 Incr 159235548 28/02/13 F:\APP\USER\ORADATA\ORCL\SGO_07.DBF

              BS Key Type LV Size Device Type Elapsed Time Horßrio de ConclusÒo
              ------- ---- -- ---------- ----------- ------------ --------------------
              2677 Incr 0 15.23G DISK 00:00:00 28/02/13
              Lista de Arquivos de Dados no conjunto de backup 2677
              File LV Type Ckp SCN Tempo de Verif. Name
              ---- -- ---- ---------- --------------- ----
              9 0 Incr 159240756 28/02/13 F:\APP\USER\ORADATA\ORCL\SGO_04.DBF

              C¾pia do Conjunto de Backup n·m. 1 do conjunto de backup 2677
              Tipo de Dispositivo Tempo Decorrido Horßrio de ConclusÒo Tag Compactada
              ----------- ------------ -------------------- ---------- ---
              DISK 00:00:00 02/03/13 NO TAG20130228T000915

              Lista de Itens de Backup do conjunto de backup 2677 No. da C¾pia1
              BP Key Pc# Status Piece Name
              ------- --- ----------- ----------
              2835 1 AVAILABLE H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LXZ0CJM_.BKP
              2836 2 AVAILABLE H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LY0YF1G_.BKP

              BS Key Type LV Size Device Type Elapsed Time Horßrio de ConclusÒo
              ------- ---- -- ---------- ----------- ------------ --------------------
              2679 Incr 0 15.22G DISK 00:00:00 28/02/13
              Lista de Arquivos de Dados no conjunto de backup 2679
              File LV Type Ckp SCN Tempo de Verif. Name
              ---- -- ---- ---------- --------------- ----
              10 0 Incr 159244059 28/02/13 F:\APP\USER\ORADATA\ORCL\SGO_05.DBF

              C¾pia do Conjunto de Backup n·m. 1 do conjunto de backup 2679
              Tipo de Dispositivo Tempo Decorrido Horßrio de ConclusÒo Tag Compactada
              ----------- ------------ -------------------- ---------- ---
              DISK 00:00:00 02/03/13 NO TAG20130228T000915

              Lista de Itens de Backup do conjunto de backup 2679 No. da C¾pia1
              BP Key Pc# Status Piece Name
              ------- --- ----------- ----------
              2837 1 AVAILABLE H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LY1LLYR_.BKP
              2838 2 AVAILABLE H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LY28BH4_.BKP

              BS Key Type LV Size Device Type Elapsed Time Horßrio de ConclusÒo
              ------- ---- -- ---------- ----------- ------------ --------------------
              2681 Incr 0 12.94G DISK 00:00:00 28/02/13
              Lista de Arquivos de Dados no conjunto de backup 2681
              File LV Type Ckp SCN Tempo de Verif. Name
              ---- -- ---- ---------- --------------- ----
              8 0 Incr 159245354 28/02/13 F:\APP\USER\ORADATA\ORCL\SGO_03.DBF

              C¾pia do Conjunto de Backup n·m. 1 do conjunto de backup 2681
              Tipo de Dispositivo Tempo Decorrido Horßrio de ConclusÒo Tag Compactada
              ----------- ------------ -------------------- ---------- ---
              DISK 00:00:00 02/03/13 NO TAG20130228T000915

              Lista de Itens de Backup do conjunto de backup 2681 No. da C¾pia1
              BP Key Pc# Status Piece Name
              ------- --- ----------- ----------
              2839 1 AVAILABLE H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LY2RGL2_.BKP
              2840 2 AVAILABLE H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LY3BS0H_.BKP

              RMAN>

              RMAN>

              RMAN> list copy;

              especificaþÒo nÒo corresponde Ós c¾pias de arquivos de dados contidas no reposit¾rio
              a especificaþÒo nÒo corresponde a nenhuma c¾pia de arquivo de controle no reposit¾rio
              Lista de C¾pias de Log Arquivadas para o banco de dados com db_unique_name ORCL
              =====================================================================

              Chave Seq. Thread S Tempo Inferior
              ------- ---- ------- - --------------
              9805 1 1 A 19/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_1_8L823V70_.ARC

              9806 1 2 A 19/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_2_8L8242NZ_.ARC

              9807 1 3 A 19/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_3_8L824D7O_.ARC

              9808 1 4 A 19/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_4_8L824P5Q_.ARC

              9809 1 5 A 19/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_5_8L824WS5_.ARC

              9810 1 6 A 19/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_6_8L82546S_.ARC

              9811 1 7 A 19/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_7_8L825CPP_.ARC

              9812 1 8 A 19/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_8_8L825NKH_.ARC

              9813 1 9 A 19/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_9_8L825V7P_.ARC

              9802 1 10 A 19/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_10_8L82633K_.ARC

              9803 1 11 A 19/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_11_8L827V2Q_.ARC

              9804 1 12 A 19/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_12_8L8827SC_.ARC

              9814 1 13 A 19/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_20\O1_MF_1_13_8L9ORR88_.ARC

              9815 1 14 A 20/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_20\O1_MF_1_14_8LBWG2RH_.ARC

              9816 1 15 A 20/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_20\O1_MF_1_15_8LC152X4_.ARC

              9817 1 16 A 20/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_21\O1_MF_1_16_8LDMCZPL_.ARC

              9818 1 17 A 21/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_21\O1_MF_1_17_8LFJSFQD_.ARC

              9819 1 18 A 21/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_22\O1_MF_1_18_8LFVORWK_.ARC

              9820 1 19 A 22/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_22\O1_MF_1_19_8LHMMZJJ_.ARC

              9821 1 20 A 22/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_22\O1_MF_1_20_8LJ8O794_.ARC

              9822 1 21 A 22/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_23\O1_MF_1_21_8LJPRK59_.ARC

              9823 1 22 A 23/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_23\O1_MF_1_22_8LKHN136_.ARC

              9824 1 23 A 23/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_23\O1_MF_1_23_8LLGZPTV_.ARC

              9825 1 24 A 23/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_23\O1_MF_1_24_8LLYNGQC_.ARC

              9826 1 25 A 23/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_24\O1_MF_1_25_8LMOOCQC_.ARC

              9827 1 26 A 24/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_24\O1_MF_1_26_8LNRVBSY_.ARC

              9828 1 27 A 24/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_24\O1_MF_1_27_8LOKWZV0_.ARC

              9829 1 28 A 24/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_25\O1_MF_1_28_8LP0SRVS_.ARC

              9830 1 29 A 25/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_25\O1_MF_1_29_8LQRHHX5_.ARC

              9831 1 30 A 25/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_25\O1_MF_1_30_8LR7M78C_.ARC

              9832 1 31 A 25/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_26\O1_MF_1_31_8LS99G4R_.ARC

              9833 1 32 A 26/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_26\O1_MF_1_32_8LTPO0RN_.ARC

              9834 1 33 A 26/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_26\O1_MF_1_33_8LTW2PWT_.ARC

              9835 1 34 A 26/02/13
              Nome: F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_27\O1_MF_1_34_8LVSTRGK_.ARC


              RMAN>

              RMAN>

              RMAN> crosscheck backup;

              a configuraþÒo para o canal DISK 2 foi ignorada
              a configuraþÒo para o canal DISK 3 foi ignorada
              canal alocado: ORA_DISK_1
              canal ORA_DISK_1: SID=191 tipo de dispositivo=DISK
              componente de backup submetido a verificaþÒo cruzada: localizado como 'EXPIRED'
              handle de componente de backup=F:\APP\USER\RECOVERY_AREA\ORCL\BACKUPSET\C-1268632144-20130227-00 RECID=2808 STAMP=8
              08448303
              componente de backup submetido a verificaþÒo cruzada: localizado como 'AVAILABLE'
              handle de componente de backup=H:\TEMP\2013_02_28\O1_MF_ANNNN_NIVEL_0_8LXL6HXS_.BKP RECID=2825 STAMP=808966371
              componente de backup submetido a verificaþÒo cruzada: localizado como 'AVAILABLE'
              handle de componente de backup=H:\TEMP\2013_02_28\O1_MF_ANNNN_NIVEL_0_8LY3PFQG_.BKP RECID=2826 STAMP=808966371
              componente de backup submetido a verificaþÒo cruzada: localizado como 'AVAILABLE'
              handle de componente de backup=H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LXLLW0Z_.BKP RECID=2827 STAMP=808
              966372
              componente de backup submetido a verificaþÒo cruzada: localizado como 'AVAILABLE'
              handle de componente de backup=H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LXMPZY8_.BKP RECID=2828 STAMP=808
              966372
              componente de backup submetido a verificaþÒo cruzada: localizado como 'AVAILABLE'
              handle de componente de backup=H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LXNRXG5_.BKP RECID=2829 STAMP=808
              966372
              componente de backup submetido a verificaþÒo cruzada: localizado como 'AVAILABLE'
              handle de componente de backup=H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LXPHS9R_.BKP RECID=2830 STAMP=808
              966373
              componente de backup submetido a verificaþÒo cruzada: localizado como 'AVAILABLE'
              handle de componente de backup=H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LXPSO9R_.BKP RECID=2831 STAMP=808
              966373
              componente de backup submetido a verificaþÒo cruzada: localizado como 'AVAILABLE'
              handle de componente de backup=H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LXRWG3F_.BKP RECID=2832 STAMP=808
              966373
              componente de backup submetido a verificaþÒo cruzada: localizado como 'AVAILABLE'
              handle de componente de backup=H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LXT3CVC_.BKP RECID=2833 STAMP=808
              966373
              componente de backup submetido a verificaþÒo cruzada: localizado como 'AVAILABLE'
              handle de componente de backup=H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LXTVPBQ_.BKP RECID=2834 STAMP=808
              966374
              componente de backup submetido a verificaþÒo cruzada: localizado como 'AVAILABLE'
              handle de componente de backup=H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LXZ0CJM_.BKP RECID=2835 STAMP=808
              966374
              componente de backup submetido a verificaþÒo cruzada: localizado como 'AVAILABLE'
              handle de componente de backup=H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LY0YF1G_.BKP RECID=2836 STAMP=808
              966374
              componente de backup submetido a verificaþÒo cruzada: localizado como 'AVAILABLE'
              handle de componente de backup=H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LY1LLYR_.BKP RECID=2837 STAMP=808
              966375
              componente de backup submetido a verificaþÒo cruzada: localizado como 'AVAILABLE'
              handle de componente de backup=H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LY28BH4_.BKP RECID=2838 STAMP=808
              966375
              componente de backup submetido a verificaþÒo cruzada: localizado como 'AVAILABLE'
              handle de componente de backup=H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LY2RGL2_.BKP RECID=2839 STAMP=808
              966376
              componente de backup submetido a verificaþÒo cruzada: localizado como 'AVAILABLE'
              handle de componente de backup=H:\TEMP\2013_02_28\O1_MF_NNND0_TAG20130228T000915_8LY3BS0H_.BKP RECID=2840 STAMP=808
              966376
              Fez a verificaþÒo cruzada de 17 objetos


              RMAN> crosscheck copy;

              canal liberado: ORA_DISK_1
              canal alocado: ORA_DISK_1
              canal ORA_DISK_1: SID=191 tipo de dispositivo=DISK
              specification doesn't corresponds to any datafiles into repository
              specification doesn't correspons to any copy of control file into repository
              succesfull validation to archievd log

              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_1_8L823V70_.ARC RECID
              =9805 STAMP=808966355
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_2_8L8242NZ_.ARC RECID
              =9806 STAMP=808966355
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_3_8L824D7O_.ARC RECID
              =9807 STAMP=808966355
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_4_8L824P5Q_.ARC RECID
              =9808 STAMP=808966355
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_5_8L824WS5_.ARC RECID
              =9809 STAMP=808966355
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_6_8L82546S_.ARC RECID
              =9810 STAMP=808966355
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_7_8L825CPP_.ARC RECID
              =9811 STAMP=808966355
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_8_8L825NKH_.ARC RECID
              =9812 STAMP=808966355
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_9_8L825V7P_.ARC RECID
              =9813 STAMP=808966355
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_10_8L82633K_.ARC RECI
              D=9802 STAMP=808966354
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_11_8L827V2Q_.ARC RECI
              D=9803 STAMP=808966355
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_19\O1_MF_1_12_8L8827SC_.ARC RECI
              D=9804 STAMP=808966355
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_20\O1_MF_1_13_8L9ORR88_.ARC RECI
              D=9814 STAMP=808966356
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_20\O1_MF_1_14_8LBWG2RH_.ARC RECI
              D=9815 STAMP=808966356
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_20\O1_MF_1_15_8LC152X4_.ARC RECI
              D=9816 STAMP=808966356
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_21\O1_MF_1_16_8LDMCZPL_.ARC RECI
              D=9817 STAMP=808966356
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_21\O1_MF_1_17_8LFJSFQD_.ARC RECI
              D=9818 STAMP=808966356
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_22\O1_MF_1_18_8LFVORWK_.ARC RECI
              D=9819 STAMP=808966356
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_22\O1_MF_1_19_8LHMMZJJ_.ARC RECI
              D=9820 STAMP=808966356
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_22\O1_MF_1_20_8LJ8O794_.ARC RECI
              D=9821 STAMP=808966356
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_23\O1_MF_1_21_8LJPRK59_.ARC RECI
              D=9822 STAMP=808966356
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_23\O1_MF_1_22_8LKHN136_.ARC RECI
              D=9823 STAMP=808966356
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_23\O1_MF_1_23_8LLGZPTV_.ARC RECI
              D=9824 STAMP=808966356
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_23\O1_MF_1_24_8LLYNGQC_.ARC RECI
              D=9825 STAMP=808966356
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_24\O1_MF_1_25_8LMOOCQC_.ARC RECI
              D=9826 STAMP=808966356
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_24\O1_MF_1_26_8LNRVBSY_.ARC RECI
              D=9827 STAMP=808966357
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_24\O1_MF_1_27_8LOKWZV0_.ARC RECI
              D=9828 STAMP=808966357
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_25\O1_MF_1_28_8LP0SRVS_.ARC RECI
              D=9829 STAMP=808966357
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_25\O1_MF_1_29_8LQRHHX5_.ARC RECI
              D=9830 STAMP=808966357
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_25\O1_MF_1_30_8LR7M78C_.ARC RECI
              D=9831 STAMP=808966357
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_26\O1_MF_1_31_8LS99G4R_.ARC RECI
              D=9832 STAMP=808966357
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_26\O1_MF_1_32_8LTPO0RN_.ARC RECI
              D=9833 STAMP=808966357
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_26\O1_MF_1_33_8LTW2PWT_.ARC RECI
              D=9834 STAMP=808966357
              validaþÒo bem-sucedida no log arquivado
              nome do arquivo de log arquivado=F:\APP\USER\RECOVERY_AREA\ORCL\ARCHIVELOG\2013_02_27\O1_MF_1_34_8LVSTRGK_.ARC RECI
              D=9835 STAMP=808966357
              Fez a verificaþÒo cruzada de 34 objetos


              RMAN>
              • 4. Re: Restore incremental backup to another server
                617177
                Oracle 11g 11.0.2.0
                Procedure: RMAN Restore

                I've done as you said (restore controlfile + catalog + , but got no success.


                Results for database restore preview
                RMAN> restore database preview;

                Iniciando restore em 02/03/13
                utilizando o canal ORA_DISK_1

                o arquivo de dados 6 serß criado automaticamente durante a operaþÒo de restauraþÒo
                o arquivo de dados 7 serß criado automaticamente durante a operaþÒo de restauraþÒo
                o arquivo de dados 8 serß criado automaticamente durante a operaþÒo de restauraþÒo
                o arquivo de dados 9 serß criado automaticamente durante a operaþÒo de restauraþÒo
                o arquivo de dados 10 serß criado automaticamente durante a operaþÒo de restauraþÒo
                o arquivo de dados 11 serß criado automaticamente durante a operaþÒo de restauraþÒo
                o arquivo de dados 12 serß criado automaticamente durante a operaþÒo de restauraþÒo
                RMAN-00571: ===========================================================
                RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                RMAN-00571: ===========================================================
                RMAN-03002: falha do comando restore em 03/02/2013 16:38:27
                RMAN-06026: alguns originais nÒo foram encontrados - abortando restauraþÒo
                RMAN-06023: nenhum backup ou c¾pia do arquivo de dados 5 encontrado para restaurar
                RMAN-06023: nenhum backup ou c¾pia do arquivo de dados 4 encontrado para restaurar
                RMAN-06023: nenhum backup ou c¾pia do arquivo de dados 3 encontrado para restaurar
                RMAN-06023: nenhum backup ou c¾pia do arquivo de dados 2 encontrado para restaurar
                RMAN-06023: nenhum backup ou c¾pia do arquivo de dados 1 encontrado para restaurar
                • 5. Re: Restore incremental backup to another server
                  CKPT
                  Results for database restore preview
                  RMAN> restore database preview;

                  Iniciando restore em 02/03/13
                  utilizando o canal ORA_DISK_1

                  o arquivo de dados 6 serß criado automaticamente durante a operaþÒo de restauraþÒo
                  o arquivo de dados 7 serß criado automaticamente durante a operaþÒo de restauraþÒo
                  o arquivo de dados 8 serß criado automaticamente durante a operaþÒo de restauraþÒo
                  If restore database preview doesn't show the backup as exist, that mean either you registered any incremental backups without full backup? i suspect on the backups.
                  Or take a full backup again and then do as above and share the results.
                  • 6. Re: Restore incremental backup to another server
                    617177
                    I have tried three diferents full backup of level 0 and the results is the same.

                    Is it necessary to make a backup at the second server prior to apply the backup from the first server?
                    • 7. Re: Restore incremental backup to another server
                      Hemant K Chitale
                      What is strange is that it doesn't find the backups for the first 5 datafiles but doesn't report any issues with the SGO_% datafiles that you also have in the database.


                      On the new server, have you copied the backup pieces to the same location (physical path) as they are on the source server ?

                      Is the LIST BACKUP output from the source server or the new server ?


                      Hemant K Chitale
                      • 8. Re: Restore incremental backup to another server
                        617177
                        Hello and thanks for yuor attention.

                        The files is in a different location but I've used catalog start with statement prior start the restore statement.

                        The List Backup is on the new server.

                        Regards,

                        Carlos
                        • 9. Re: Restore incremental backup to another server
                          Hemant K Chitale
                          If LIST BACKUP shows the datafiles, RESTORE DATABASE PREVIEW should also recognise them.

                          Can you show us the exact BACKUP commands you used (including the controlfile) ?
                          Did you take a separate backup fo the controlfile after the database and archivelog backup and restore that controlfile backup to the new server ?


                          Hemant K Chitale
                          • 10. Re: Restore incremental backup to another server
                            617177
                            Here is.
                            connect target /; crosscheck backupset; delete expired backup; delete obsolete; backup section size 10G incremental level 0 database plus archivelog tag = 'NIVEL-0'; list backup;
                            • 11. Re: Restore incremental backup to another server
                              Hemant K Chitale
                              There seems to be nothing wrong with your backup command.


                              Oracle would report RMAN-06023 if it finds no datafile backup that corresponds to the criteria specified. Thus, you could try a SET UNTIL clause set to the time of the end of the backup and see if it finds these datafile backups as usable.


                              Hemant K Chitale
                              • 12. Re: Restore incremental backup to another server
                                617177
                                Ok, I'll try this.

                                Will it be a problem if the first server was installed as Desktop Server and the second one installed as Server Class?
                                • 13. Re: Restore incremental backup to another server
                                  617177
                                  The problem is clear now. I was missing the SET DBID statement.

                                  Best regards.