12 Replies Latest reply: Sep 17, 2013 6:26 AM by user12075536123 RSS

    Catalog controlfile and spfile rman backups

    user472167

      I am trying to catalog the control file and spfile backups but are not recognized.

       

      After issuing the following command I examine the current backups using OEM but the files are not listed.

       

      rman>CATALOG START WITH 'D:\Oracle\Ora11g_home1\backup\ControlFile_And_SpFile\C-';

       

      List of Files Unknown to the Database

      =====================================

      File Name: D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-201

      30916-00

      File Name: D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-201

      30916-01

       

       

      Do you really want to catalog the above files (enter YES or NO)? y

      cataloging files...

      cataloging done

       

      List of Cataloged Files

      =======================

      File Name: D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-201

      30916-00

      File Name: D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-201

      30916-01

        • 1. Re: Catalog controlfile and spfile rman backups
          user12075536123

          Please, ppost the output of below cmd

           

          set ORACLE_SID=[sid]
          rman target / nocatalog

          list backuppiece 'D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-20130916-00';
          list backuppiece 'D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-20130916-01';

          • 2. Re: Catalog controlfile and spfile rman backups
            user472167

            Error "backup piece not found in the repository".

             

            For a new backup I made the command works fine:

            RMAN> list backuppiece 'D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-20130916-02';

             

             

            List of Backup Pieces

            BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name

            ------- ------- --- --- ----------- ----------- ----------

            10      10      1   1   AVAILABLE   DISK        D:\ORACLE\ORA11G_HOME1\BACKUP\CO

            NTROLFILE_AND_SPFILE\C-3695925691-20130916-02

             

            Output:

            Recovery Manager: Release 11.2.0.3.0 - Production on Mon Sep 16 12:29:42 2013

             

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

             

            connected to target database: DOCMANTE (DBID=3695925691)

            using target database control file instead of recovery catalog

             

            RMAN> list backuppiece 'D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3

            695925691-20130916-00';

             

            RMAN-00571: ===========================================================

            RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

            RMAN-00571: ===========================================================

            RMAN-03002: failure of list command at 09/16/2013 12:29:53

            RMAN-20260: backup piece not found in the repository

            RMAN-06092: error while looking up backup piece

             

            RMAN> list backuppiece 'D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3

            695925691-20130916-01';

             

            RMAN-00571: ===========================================================

            RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

            RMAN-00571: ===========================================================

            RMAN-03002: failure of list command at 09/16/2013 12:30:58

            RMAN-20260: backup piece not found in the repository

            RMAN-06092: error while looking up backup piece

            • 3. Re: Catalog controlfile and spfile rman backups
              user12075536123

              Please, post the output of below cmd

               

              set ORACLE_SID=[sid]
              rman target / nocatalog

               

              catalog start with 'D:\Oracle\Ora11g_home1\backup\ControlFile_And_SpFile\C-';

               

              list backuppiece 'D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-20130916-00';
              list backuppiece 'D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-20130916-01';

              list backup;

              • 4. Re: Catalog controlfile and spfile rman backups
                user472167

                set ORACLE_SID=DocmanTest

                 

                rman target / nocatalog

                 

                Recovery Manager: Release 11.2.0.3.0 - Production on Mon Sep 16 12:29:42 2013

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

                connected to target database: DOCMANTE (DBID=3695925691)

                using target database control file instead of recovery catalog

                RMAN> list backuppiece 'D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-20130916-00';

                RMAN-00571: ===========================================================

                RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

                RMAN-00571: ===========================================================

                RMAN-03002: failure of list command at 09/16/2013 12:29:53

                RMAN-20260: backup piece not found in the repository

                RMAN-06092: error while looking up backup piece

                RMAN> list backuppiece 'D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-20130916-01';

                 

                RMAN-00571: ===========================================================

                RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

                RMAN-00571: ===========================================================

                RMAN-03002: failure of list command at 09/16/2013 13:08:32

                RMAN-20260: backup piece not found in the repository

                RMAN-06092: error while looking up backup piece

                 

                 

                RMAN> list backup;

                 

                List of Backup Sets

                ===================

                 

                BS Key  Type LV Size       Device Type Elapsed Time Completion Time

                ------- ---- -- ---------- ----------- ------------ ---------------

                 

                11      Incr 0  3.82G      DISK        00:03:27     16-SEP-13

                        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: TAG20130916T123921

                        Piece Name: D:\ORACLE\ORA11G_HOME1\BACKUP\DB\08OK0AJQ_1_1

                 

                  List of Datafiles in backup set 11

                 

                  File LV Type Ckp SCN    Ckp Time  Name

                  ---- -- ---- ---------- --------- ----

                  1    0  Incr 8802398    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SYSTEM01.DBF

                  2    0  Incr 8802398    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SYSAUX01.DBF

                  3    0  Incr 8802398    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\UNDOTBS01.DBF

                  4    0  Incr 8802398    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\USERS01.DBF

                  5    0  Incr 8802398    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\IDEAL.DBF

                  6    0  Incr 8802398    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\IDEAL_OKSIGN.DBF

                  7    0  Incr 8802398    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\IDEAL_OKSIGN_BLOB.DBF

                  8    0  Incr 8802398    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SMARTCLEAR.DBF

                  9    0  Incr 8802398    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SMARTDOC.DBF

                  10   0  Incr 8802398    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SMARTDOC_BLOB.DBF

                  11   0  Incr 8802398    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SMARTDOC_CHEQUES.DBF

                  12   0  Incr 8802398    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SMARTDOC_CHEQUES_BLOB.DBF

                 

                BS Key  Size       Device Type Elapsed Time Completion Time

                ------- ---------- ----------- ------------ ---------------

                13      801.00K    DISK        00:00:01     16-SEP-13

                        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20130916T124303

                        Piece Name: D:\ORACLE\ORA11G_HOME1\BACKUP\DB\0AOK0AQN_1_1

                 

                  List of Archived Logs in backup set 13

                 

                  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

                  ---- ------- ---------- --------- ---------- ---------

                  1    25      8801611    16-SEP-13 8802654    16-SEP-13

                 

                BS Key  Type LV Size       Device Type Elapsed Time Completion Time

                ------- ---- -- ---------- ----------- ------------ ---------------

                15      Incr 0  3.82G      DISK        00:02:59     16-SEP-13

                        BP Key: 15   Status: AVAILABLE  Compressed: NO  Tag: TAG20130916T124826

                        Piece Name: D:\ORACLE\ORA11G_HOME1\BACKUP\DB\0COK0B4Q_1_1

                 

                  List of Datafiles in backup set 15

                 

                  File LV Type Ckp SCN    Ckp Time  Name

                  ---- -- ---- ---------- --------- ----

                  1    0  Incr 8803004    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SYSTEM01.DBF

                  2    0  Incr 8803004    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SYSAUX01.DBF

                  3    0  Incr 8803004    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\UNDOTBS01.DBF

                  4    0  Incr 8803004    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\USERS01.DBF

                  5    0  Incr 8803004    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\IDEAL.DBF

                  6    0  Incr 8803004    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\IDEAL_OKSIGN.DBF

                  7    0  Incr 8803004    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\IDEAL_OKSIGN_BLOB.DBF

                  8    0  Incr 8803004    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SMARTCLEAR.DBF

                  9    0  Incr 8803004    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SMARTDOC.DBF

                  10   0  Incr 8803004    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SMARTDOC_BLOB.DBF

                  11   0  Incr 8803004    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SMARTDOC_CHEQUES.DBF

                  12   0  Incr 8803004    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SMARTDOC_CHEQUES_BLOB.DBF

                 

                BS Key  Type LV Size       Device Type Elapsed Time Completion Time

                ------- ---- -- ---------- ----------- ------------ ---------------

                16      Full    9.36M      DISK        00:00:02     16-SEP-13

                        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20130916T125132

                        Piece Name: D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-20130916-05

                  SPFILE Included: Modification time: 16-SEP-13

                  SPFILE db_unique_name: DOCMANTEST

                  Control File Included: Ckp SCN: 8803177      Ckp time: 16-SEP-13

                 

                BS Key  Size       Device Type Elapsed Time Completion Time

                ------- ---------- ----------- ------------ ---------------

                17      407.50K    DISK        00:00:00     16-SEP-13

                        BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20130916T125138

                        Piece Name: D:\ORACLE\ORA11G_HOME1\BACKUP\DB\0EOK0BAQ_1_1

                 

                  List of Archived Logs in backup set 17

                  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

                  ---- ------- ---------- --------- ---------- ---------

                  1    26      8802654    16-SEP-13 8803194    16-SEP-13

                 

                BS Key  Type LV Size       Device Type Elapsed Time Completion Time

                ------- ---- -- ---------- ----------- ------------ ---------------

                18      Full    9.36M      DISK        00:00:02     16-SEP-13

                        BP Key: 18   Status: AVAILABLE  Compressed: NO  Tag: TAG20130916T125139

                        Piece Name: D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-36959

                25691-20130916-06

                  SPFILE Included: Modification time: 16-SEP-13

                  SPFILE db_unique_name: DOCMANTEST

                  Control File Included: Ckp SCN: 8803203      Ckp time: 16-SEP-13

                • 5. Re: Catalog controlfile and spfile rman backups
                  user12075536123

                  backup is deleted.

                   

                  now ,the following commands is error.
                  list backuppiece 'D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-20130916-02';

                   

                  please retry

                  # rman
                  catalog start with 'D:\Oracle\Ora11g_home1\backup\ControlFile_And_SpFile\C-';

                  list backup;

                   

                  # EM
                  check the current backups using OEM

                  • 6. Re: Catalog controlfile and spfile rman backups
                    user472167

                    Still they are not shown in OEM current backups.

                    • 7. Re: Catalog controlfile and spfile rman backups
                      user12075536123

                      is the following commands error ?
                      > list backuppiece 'D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-20130916-02';

                       

                      please post the output of two commands
                      > # rman
                      > catalog start with 'D:\Oracle\Ora11g_home1\backup\ControlFile_And_SpFile\C-';
                      > list backup;

                      • 8. Re: Catalog controlfile and spfile rman backups
                        user472167

                        Yes. the command produced the following error (I already posted it above)

                        RMAN-00571: ===========================================================

                        RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

                        RMAN-00571: ===========================================================

                        RMAN-03002: failure of list command at 09/16/2013 14:13:25

                        RMAN-20260: backup piece not found in the repository

                        RMAN-06092: error while looking up backup piece

                         

                        the output of two commands:

                        Recovery Manager: Release 11.2.0.3.0 - Production on Mon Sep 16 14:14:24 2013

                         

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

                         

                        RMAN> connect target *

                        2> catalog start with 'D:\Oracle\Ora11g_home1\backup\ControlFile_And_SpFile\C-';

                        3> list backup;

                        4>

                        connected to target database: DOCMANTE (DBID=3695925691)

                         

                        using target database control file instead of recovery catalog

                        searching for all files that match the pattern D:\Oracle\Ora11g_home1\backup\ControlFile_And_SpFile\C-

                         

                        List of Files Unknown to the Database

                        =====================================

                        File Name: D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-20130916-00

                        File Name: D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-20130916-01

                        cataloging files...

                        cataloging done

                         

                        List of Cataloged Files

                        =======================

                        File Name: D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-20130916-00

                        File Name: D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-20130916-01

                         

                         

                        List of Backup Sets

                        ===================

                         

                         

                        BS Key  Type LV Size       Device Type Elapsed Time Completion Time

                        ------- ---- -- ---------- ----------- ------------ ---------------

                        27      Incr 0  3.82G      DISK        00:03:23     16-SEP-13     

                                BP Key: 27   Status: AVAILABLE  Compressed: NO  Tag: TAG20130916T135543

                                Piece Name: D:\ORACLE\ORA11G_HOME1\BACKUP\DB\0OOK0F2V_1_1

                          List of Datafiles in backup set 27

                          File LV Type Ckp SCN    Ckp Time  Name

                          ---- -- ---- ---------- --------- ----

                          1    0  Incr 8807284    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SYSTEM01.DBF

                          2    0  Incr 8807284    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SYSAUX01.DBF

                          3    0  Incr 8807284    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\UNDOTBS01.DBF

                          4    0  Incr 8807284    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\USERS01.DBF

                          5    0  Incr 8807284    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\IDEAL.DBF

                          6    0  Incr 8807284    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\IDEAL_OKSIGN.DBF

                          7    0  Incr 8807284    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\IDEAL_OKSIGN_BLOB.DBF

                          8    0  Incr 8807284    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SMARTCLEAR.DBF

                          9    0  Incr 8807284    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SMARTDOC.DBF

                          10   0  Incr 8807284    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SMARTDOC_BLOB.DBF

                          11   0  Incr 8807284    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SMARTDOC_CHEQUES.DBF

                          12   0  Incr 8807284    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SMARTDOC_CHEQUES_BLOB.DBF

                         

                        BS Key  Size       Device Type Elapsed Time Completion Time

                        ------- ---------- ----------- ------------ ---------------

                        29      1.68M      DISK        00:00:01     16-SEP-13     

                                BP Key: 29   Status: AVAILABLE  Compressed: NO  Tag: TAG20130916T135915

                                Piece Name: D:\ORACLE\ORA11G_HOME1\BACKUP\DB\0QOK0F9J_1_1

                         

                          List of Archived Logs in backup set 29

                          Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

                          ---- ------- ---------- --------- ---------- ---------

                          1    29      8805369    16-SEP-13 8807531    16-SEP-13

                         

                        BS Key  Type LV Size       Device Type Elapsed Time Completion Time

                        ------- ---- -- ---------- ----------- ------------ ---------------

                        31      Incr 1  3.50M      DISK        00:00:51     16-SEP-13     

                                BP Key: 31   Status: AVAILABLE  Compressed: NO  Tag: TAG20130916T140250

                                Piece Name: D:\ORACLE\ORA11G_HOME1\BACKUP\DB\0SOK0FGB_1_1

                          List of Datafiles in backup set 31

                          File LV Type Ckp SCN    Ckp Time  Name

                          ---- -- ---- ---------- --------- ----

                          1    1  Incr 8807969    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SYSTEM01.DBF

                          2    1  Incr 8807969    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SYSAUX01.DBF

                          3    1  Incr 8807969    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\UNDOTBS01.DBF

                          4    1  Incr 8807969    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\USERS01.DBF

                          5    1  Incr 8807969    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\IDEAL.DBF

                          6    1  Incr 8807969    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\IDEAL_OKSIGN.DBF

                          7    1  Incr 8807969    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\IDEAL_OKSIGN_BLOB.DBF

                          8    1  Incr 8807969    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SMARTCLEAR.DBF

                          9    1  Incr 8807969    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SMARTDOC.DBF

                          10   1  Incr 8807969    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SMARTDOC_BLOB.DBF

                          11   1  Incr 8807969    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SMARTDOC_CHEQUES.DBF

                          12   1  Incr 8807969    16-SEP-13 D:\ORACLE\ORA11G_HOME1\ORADATA\DOCMANTEST\DOCMANTEST\SMARTDOC_CHEQUES_BLOB.DBF

                         

                        BS Key  Type LV Size       Device Type Elapsed Time Completion Time

                        ------- ---- -- ---------- ----------- ------------ ---------------

                        32      Full    9.36M      DISK        00:00:03     16-SEP-13     

                                BP Key: 32   Status: AVAILABLE  Compressed: NO  Tag: TAG20130916T140347

                                Piece Name: D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-20130916-0D

                          SPFILE Included: Modification time: 16-SEP-13

                          SPFILE db_unique_name: DOCMANTEST

                          Control File Included: Ckp SCN: 8808010      Ckp time: 16-SEP-13

                         

                        BS Key  Size       Device Type Elapsed Time Completion Time

                        ------- ---------- ----------- ------------ ---------------

                        33      944.00K    DISK        00:00:01     16-SEP-13     

                                BP Key: 33   Status: AVAILABLE  Compressed: NO  Tag: TAG20130916T140357

                                Piece Name: D:\ORACLE\ORA11G_HOME1\BACKUP\DB\0UOK0FID_1_1

                         

                          List of Archived Logs in backup set 33

                          Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

                          ---- ------- ---------- --------- ---------- ---------

                          1    30      8807531    16-SEP-13 8808029    16-SEP-13

                         

                        BS Key  Type LV Size       Device Type Elapsed Time Completion Time

                        ------- ---- -- ---------- ----------- ------------ ---------------

                        34      Full    9.36M      DISK        00:00:02     16-SEP-13     

                                BP Key: 34   Status: AVAILABLE  Compressed: NO  Tag: TAG20130916T140359

                                Piece Name: D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-20130916-0E

                          SPFILE Included: Modification time: 16-SEP-13

                          SPFILE db_unique_name: DOCMANTEST

                          Control File Included: Ckp SCN: 8808038      Ckp time: 16-SEP-13

                         

                        Recovery Manager complete.

                        • 9. Re: Catalog controlfile and spfile rman backups
                          user472167

                          I am trying to test replication of rman backups to a different server. what I would do on the second server is to catalog the backups.

                           

                          Since i do not currently have the second server what I do is to copy the backups on a temporary location on the disk and delete the backups using OEM.

                           

                          Then I move the backups back to the folders they should be and catalog them. For the database backups this method works fine. For the control file and spfile backups it does not work. I do not know if the catalog was done on a different server if it would work fine.

                          • 10. Re: Catalog controlfile and spfile rman backups
                            user12075536123

                            I tested


                            RMAN> list backup;


                            specification does not match any backup in the repository


                            RMAN> catalog start with '/tmp/c-';


                            searching for all files that match the pattern /tmp/c-


                            List of Files Unknown to the Database
                            =====================================
                            File Name: /tmp/c-3445172167-20130916-00


                            Do you really want to catalog the above files (enter YES or NO)? yes
                            cataloging files...
                            cataloging done


                            List of Cataloged Files
                            =======================
                            File Name: /tmp/c-3445172167-20130916-00


                            RMAN> list backup;


                            specification does not match any backup in the repository


                            ※why!!


                            RMAN> catalog backuppiece '/tmp/c-3445172167-20130916-00';


                            cataloged backup piece
                            backup piece handle=/tmp/c-3445172167-20130916-00 RECID=4 STAMP=826317796


                            RMAN> list backup;


                            List of Backup Sets
                            ===================


                            BS Key  Type LV Size       Device Type Elapsed Time Completion Time
                            ------- ---- -- ---------- ----------- ------------ ---------------
                            4       Full    18.92M     DISK        00:00:00     16-SEP-13
                                    BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20130916T181652
                                    Piece Name: /tmp/c-3445172167-20130916-00
                              SPFILE Included: Modification time: 16-SEP-13
                              SPFILE db_unique_name: ORCL
                              Control File Included: Ckp SCN: 2602200      Ckp time: 16-SEP-13


                            ※good!!

                             

                            please try
                            # rman
                            catalog backuppiece 'D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-20130916-00';
                            catalog backuppiece 'D:\ORACLE\ORA11G_HOME1\BACKUP\CONTROLFILE_AND_SPFILE\C-3695925691-20130916-01';
                            list backup;


                            # EM
                            check the current backups using OEM

                            • 11. Re: Catalog controlfile and spfile rman backups
                              user472167

                              It works like a charm!

                              Thanks for your help.

                               

                              Do you have any idea why the catalog start with does not work?

                              • 12. Re: Catalog controlfile and spfile rman backups
                                user12075536123

                                I think, "bug with 11.2.0"


                                I tested


                                # 10.2.0.1
                                RMAN> catalog start with 'c:\temp\O1_MF_S';


                                searching for all files that match the pattern c:\temp\O1_MF_S


                                List of Files Unknown to the Database
                                =====================================
                                File Name: C:\TEMP\O1_MF_S_826402191_93JG3ZF4_.BKP


                                Do you really want to catalog the above files (enter YES or NO)? yes
                                cataloging files...
                                cataloging done


                                List of Cataloged Files
                                =======================
                                File Name: C:\TEMP\O1_MF_S_826402191_93JG3ZF4_.BKP


                                RMAN> list backup;


                                List of Backup Sets
                                ===================


                                BS Key  Type LV Size       Device Type Elapsed Time Completion Time
                                ------- ---- -- ---------- ----------- ------------ ---------------
                                2       Full    6.80M      DISK        00:00:00     17-SEP-13
                                        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20130917T200951
                                        Piece Name: C:\TEMP\O1_MF_S_826402191_93JG3ZF4_.BKP
                                  Control File Included: Ckp SCN: 576077       Ckp time: 17-SEP-13
                                  SPFILE Included: Modification time: 17-SEP-13