3 Replies Latest reply: Dec 26, 2012 9:52 PM by Shivananda Rao RSS

    RMAN Not able to find Controlfile autobackup.

    678298
      Hi All, I am trying to restore DB from one server to another using RMAN. I took backup of source DB and mounted backup location on Traget server.

      I allready created requried directory and pfile on the target server. I am facing problem during restore controlfile from autobackup. Below is what I was trying on my target sever.

      oracle@mpbdb:/backup/TEST> . oraenv
      ORACLE_SID = [TEST] ?
      The Oracle base remains unchanged with value /u01/app/oracle

      rman target /


      RMAN> startup nomount;

      Oracle instance started

      Total System Global Area 785227776 bytes

      Fixed Size 2106616 bytes
      Variable Size 201333512 bytes
      Database Buffers 578813952 bytes
      Redo Buffers 2973696 bytes


      RMAN> set DBID 3194512843

      RMAN> restore controlfile from autobackup;

      Starting restore at 27-DEC-12
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: SID=537 device type=DISK

      channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121227
      channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121226
      channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121225
      channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121224
      channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121223
      channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121222
      channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121221
      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 12/27/2012 12:46:13
      RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece


      Here is RMAN setting on my target server for this unmounted database.

      RMAN> show all;

      RMAN configuration parameters for database with db_unique_name TEST 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 'BZIP2'; # default
      CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default



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

      Rman setting on source sever.

      RMAN> show all;

      using target database control file instead of recovery catalog
      RMAN configuration parameters for database with db_unique_name TEST are:
      CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
      CONFIGURE BACKUP OPTIMIZATION OFF; # default
      CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
      CONFIGURE CONTROLFILE AUTOBACKUP ON;
      CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/%d/controlfile_backup_%d_%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 DISK TO 1; # default
      CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/%d/%U';
      CONFIGURE MAXSETSIZE TO UNLIMITED; # default
      CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
      CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
      CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
      CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
      CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.1.0/dbs/snapcf_TEST1.f'; # default


      Can you pleae give some idea why my target DB is not able to see controlfile autobackup.

      My source and Target DB is 11.1.0.7 But my source DB is under ASM, and I am trying to migrate from ASM to NonASM.

      Thanks
        • 1. Re: RMAN Not able to find Controlfile autobackup.
          Shivananda Rao
          Hello,
          RMAN> set DBID 3194512843
          
          RMAN> restore controlfile from autobackup;
          
          Starting restore at 27-DEC-12
          allocated channel: ORA_DISK_1
          channel ORA_DISK_1: SID=537 device type=DISK
          
          channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121227
          channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121226
          channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121225
          channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121224
          channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121223
          channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121222
          channel ORA_DISK_1: looking for AUTOBACKUP on day: 20121221
          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 12/27/2012 12:46:13
          RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
          Restore the controlfile from the backup piece by specifying the entire path along with the backup piece name. RMAN backs up controlfile by default and would have it placed in the backup piece of system datafile.

          You can also refer this http://www.oracle-ckpt.com/restore-spfile-no-autobackup-found-rman-06172/


          Regards,
          Shivananda
          • 2. Re: RMAN Not able to find Controlfile autobackup.
            678298
            Hi Shivananda,

            I tried but got below error.

            RMAN-03002: failure of restore command at 12/27/2012 13:17:51
            RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP

            Regards.
            • 3. Re: RMAN Not able to find Controlfile autobackup.
              Shivananda Rao
              Your source database has the controlfile autobackup set to a non-default location.
              CONFIGURE CONTROLFILE AUTOBACKUP ON;
              CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/%d/controlfile_backup_%d_%F';
              Set the controlfile autobackup format on the target and try to restore it.

              Refer this http://waseemslearning.blogspot.com/2011/03/rman-06563-control-file-or-spfile-must.html

              Suppose on the target server, you have copied the controlfile autobackup to location "/u01/autobackup/", then on the target server do as:
              RMAN>run
              {
              set controlfile autobackup format for device type disk to '/u01/autobackup/%F';
              restore controlfile from autobackup;
              }
              Hope it helps !!

              Regards,
              Shivananda