10 Replies Latest reply: Mar 14, 2014 3:44 AM by ManishS137 RSS

    Restoring Control File from 'Location' Giving RMAN-06172

    ManishS137

      Hi Friends ,

       

      I am restoring RMAN backup to new Server (With Same Name and Directory Structure) no catalog,

      Now while Restoring controlfile from Rman backup location I am getting below Error

       

      RMAN> restore controlfile from '/orabackup/RMANBKP/RMSPRD/RMAN_08_Mar_2014/control__20140308_cf_D-RMSPRD_id-1023643844_35p2lff5.ctl';

       

      Starting restore at 08-MAR-14

      using channel ORA_DISK_1

       

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

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

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

      RMAN-03002: failure of restore command at 03/08/2014 23:41:29

      RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

       

      RMAN>

       

      DB Version 11gr2

       

       

      ~Manish

        • 1. Re: Restoring Control File from 'Location' Giving RMAN-06172
          kumap7

          Is OS same on new server?

          • 2. Re: Restoring Control File from 'Location' Giving RMAN-06172
            ManishS137

            Hi ,

             

            Its same OS (Solaris10).

             

            ~Manish

            • 3. Re: Restoring Control File from 'Location' Giving RMAN-06172
              Anand...

              Hi,

               

              rman> set dbid <dbid_of_db>

              rman> restore controlfile from '/orabackup/RMANBKP/RMSPRD/RMAN_08_Mar_2014/control__20140308_cf_D-RMSPRD_id-1023643844_35p2lff5.ctl';

               

               

              Anand

              • 4. Re: Restoring Control File from 'Location' Giving RMAN-06172
                ManishS137

                Hi Anand ,

                 

                Its still the same

                 

                RMAN> set dbid 1023643844

                 

                executing command: SET DBID

                 

                RMAN> restore controlfile from '/orabackup/RMANBKP/RMSPRD/RMAN_08_Mar_2014/control__20140308_cf_D-RMSPRD_id-1023643844_35p2lff5.ctl';

                 

                Starting restore at 09-MAR-14

                using target database control file instead of recovery catalog

                allocated channel: ORA_DISK_1

                channel ORA_DISK_1: SID=601 device type=DISK

                 

                channel ORA_DISK_1: no AUTOBACKUP in 7 days found

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

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

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

                RMAN-03002: failure of restore command at 03/09/2014 10:59:46

                RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

                 

                RMAN>

                 

                 

                ~Manish

                • 5. Re: Restoring Control File from 'Location' Giving RMAN-06172
                  Anand...

                  Hi,

                   

                  can you paste the output of

                   

                  ls -lrt /orabackup/RMANBKP/RMSPRD/RMAN_08_Mar_2014/control__20140308_cf_D-RMSPRD_id-1023643844_35p2lff5.ctl

                  • 6. Re: Restoring Control File from 'Location' Giving RMAN-06172
                    ASulthan

                    Can you output

                    rman setting

                     

                    Show all;

                    • 7. Re: Restoring Control File from 'Location' Giving RMAN-06172
                      ManishS137

                      From Primary Server

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

                       

                      [oramom@nhlmomprd] /export/home/oramom> rman target /

                       

                      Recovery Manager: Release 11.2.0.3.0 - Production on Thu Mar 13 12:12:25 2014

                       

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

                       

                      connected to target database: RMSPRD (DBID=1023643844)

                       

                      RMAN> show all;

                       

                      using target database control file instead of recovery catalog

                      RMAN configuration parameters for database with db_unique_name RMSPRD are:

                      CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

                      CONFIGURE BACKUP OPTIMIZATION ON;

                      CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

                      CONFIGURE CONTROLFILE AUTOBACKUP ON;

                      CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';

                      CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/orabackup/RMANBKP/RMSPRD/%F';

                      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 'SBT_TAPE' TO 1;

                      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 COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

                      CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

                      CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/orabackup/RMANBKP/RMSPRD/snapcf_RMSPRD.f';

                      RMAN>

                       

                       

                       

                      Rman Setting from RMAN Restore  server

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

                       

                      [oradba@nhlbkp] /orabackup/RMANBKP/RMSPRD/RMAN_12_Mar_2014> rman target /

                       

                      Recovery Manager: Release 11.2.0.3.0 - Production on Thu Mar 13 12:20:15 2014

                       

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

                       

                      connected to target database: RMSPRD (not mounted)

                       

                      RMAN> show all;

                      using target database control file instead of recovery catalog

                      RMAN configuration parameters for database with db_unique_name RMSPRD are:

                      CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

                      CONFIGURE BACKUP OPTIMIZATION OFF; # default

                      CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

                      CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

                      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 COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

                      CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

                       

                       

                      ~Manish

                      • 8. Re: Restoring Control File from 'Location' Giving RMAN-06172
                        ManishS137

                        HI Anand ,

                        PF Update

                        where oradba is DB user

                         

                        [oradba@nhlbkp] /orabackup/RMANBKP/RMSPRD/RMAN_12_Mar_2014> ls -lrt control__20140312_cf_D-RMSPRD_id-1023643844_kgp313is.ctl

                        -rwxrwxrwx   1 oradba   oinstall 35700736 Mar 12 21:20 control__20140312_cf_D-RMSPRD_id-1023643844_kgp313is.ctl

                         

                        [oradba@nhlbkp] /orabackup/RMANBKP/RMSPRD/RMAN_12_Mar_2014> rman target /

                         

                        Recovery Manager: Release 11.2.0.3.0 - Production on Thu Mar 13 12:32:16 2014

                         

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

                         

                        connected to target database: RMSPRD (not mounted)

                         

                        RMAN> restore controlfile from '/orabackup/RMANBKP/RMSPRD/RMAN_12_Mar_2014/control__20140312_cf_D-RMSPRD_id-1023643844_kgp313is.ctl';

                         

                        Starting restore at 13-MAR-14

                        using target database control file instead of recovery catalog

                        allocated channel: ORA_DISK_1

                        channel ORA_DISK_1: SID=601 device type=DISK

                         

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

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

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

                        RMAN-03002: failure of restore command at 03/13/2014 12:32:41

                        RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

                         

                        RMAN>

                         

                        ~Manish

                        • 10. Re: Restoring Control File from 'Location' Giving RMAN-06172
                          ManishS137

                          Hi Guys ,

                           

                          Thanks for the update I got the solution .

                          The problem was NFS mount from where I was restoring the backup .I remounted the mount point with right options and problem got solved .

                           

                           

                          Regards,

                          Manish