7 Replies Latest reply on Jul 19, 2012 10:48 AM by kuljeet singh -

    problem with rman duplicate

    nhidba
      Hi all,


      Hi all,

      I am trying to clone a 2 node rac database to single instance database using existing database backup. All the backupset including that of archive log,current control file and datafiles are there in /oracle/backup location. But when i fired duplicate command it failed with error 'RMAN-06024: no backup or copy of the control file found to restore'.

      rman script:


      RMAN> run{
      2> allocate channel c1 device type disk;
      3> allocate auxiliary channel c2 device type disk format '/oracle/backup/%U';
      4> set until sequence 62 thread 1;
      5> duplicate target database to dbrac;
      6> }



      error:(edited)


      Starting restore at 18-JUL-2012 15:44:39

      channel c2: starting datafile backup set restore
      channel c2: restoring control file
      channel c2: reading from backup piece +FLASH/dbrac/autobackup/2012_07_18/s_788963056.385.788963061
      channel c2: ORA-19870: error while restoring backup piece +FLASH/dbrac/autobackup/2012_07_18/s_788963056.385.788963061
      ORA-19505: failed to identify file "+FLASH/dbrac/autobackup/2012_07_18/s_788963056.385.788963061"
      ORA-17503: ksfdopn:2 Failed to open file +FLASH/dbrac/autobackup/2012_07_18/s_788963056.385.788963061
      ORA-15001: diskgroup "FLASH" does not exist or is not mounted
      ORA-15077: could not locate ASM instance serving a required diskgroug

      released channel: c1
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 07/18/2012 15:44:57
      RMAN-05501: aborting duplication of target database
      RMAN-03015: error occurred in stored script Memory Script
      RMAN-06026: some targets not found - aborting restore
      RMAN-06024: no backup or copy of the control file found to restore


      Here RMAN is trying to find controlfile backup in autobackup location even after i allocated auxiliary channel to different location.

      I copied the backups from source to target into same location.

      Need help

      Thanks
      Sandeep Vadlamudi
        • 1. Re: problem with rman duplicate
          kuljeet singh -
          ORA-15001: diskgroup "FLASH" does not exist or is not mounted
          DG not exist on target
          • 2. Re: problem with rman duplicate
            nhidba
            Hi Kuljeet,

            Thanks for ur update.

            Yes i have not configured ASM on target. I am using filesystem for storing datafiles on target. So RMAN duplicate will not support ASM to NON ASM ?


            Thanks,
            sandeep Vadlamudi
            • 3. Re: problem with rman duplicate
              kuljeet singh -
              its supported,
              I am using filesystem for storing datafiles on target.
              no issue,use SET NEWNAME FOR DATAFILE 1 to /file_system/dbf_filename
              or
              use DB_FILE_NAME_CONVERT


              http://oracleinstance.blogspot.in/2010/08/duplicatecloneconvert-asm-file-system.html



              Please close the thread if you feel you have the answer and keep the Oracle forum clean.
              https://forums.oracle.com/forums/ann.jspa?annID=885
              • 4. Re: problem with rman duplicate
                Sebastian Solbach -Database Community-Oracle
                Hi,

                RMAN does support duplication from ASM to NON ASM and vice versa.

                However you have to "rename" the datafiles and the Spfile parameters during the restore.
                Otherwise RMAN tries to recover to the same directory/directory structure:

                KeyWords are:

                spfile PARAMETER_VALUE_CONVERT '<diskgroup>','<path>'
                set CONTROL_FILES='<controlfilelocation>'
                set audit_file_dest='/u01/app/oracle/admin/orcl/adump'
                set diagnostic_dest='/u01/app/oracle'
                set LOG_FILE_NAME_CONVERT '<diskgroup>,'<path>'
                set DB_FILE_NAME_CONVERT '<diskgroup>','<path'>

                Another option would be to use
                'set newname for database' to replace pathes.

                Regards
                Sebastian
                • 5. Re: problem with rman duplicate
                  nhidba
                  Here is my pfile from target database. i used db_file_name_convert,log_file_name_convert. On source we have flash recovery area configured on diskgroup +flash. Where as on target i decided not to use flash recovery area. Is this related to my problem.

                  pfile content(edited)
                  *.compatible='11.2.0'
                  *.control_files='/oracle/app/oracle/dbrac/control.ctl'
                  *.db_files=50
                  *.db_name='DBRAC'
                  db_file_name_convert='+data/rhelrac-cluster/','/oracle/app/oracle/dbrac/'
                  log_file_name_convert='+data/rhelrac-cluster/','/oracle/app/oracle/dbrac/'
                  *.diagnostic_dest='/oracle/app/oracle/diag'
                  *.job_queue_processes=3
                  *.log_checkpoint_interval=10000
                  *.open_cursors=50
                  *.processes=200
                  *.remote_login_passwordfile='exclusive'
                  *.sessions=200
                  *.shared_pool_size=120m
                  *.undo_management='auto'
                  *.undo_tablespace=undo1
                  • 6. Re: problem with rman duplicate
                    nhidba
                    Issue resolved.

                    In my source database controlfile autobackup was configured to go in to flash destination. So whenever i run source database backup into '/oracle/backup' location automatically at the end of backup control file autobackup is getting generated into flash with highest SCN than the current controlfile backup created as part of backup. So i disabled controlfile autobackup,taken fresh backup copy of source and tried the cloning and it worked well for me.

                    My only doubt is when i allocated auxiliary channel to backup location why rman is looking for most recent backup of controlfile.


                    Thanks,
                    Sandeep Vadlamudi
                    • 7. Re: problem with rman duplicate
                      kuljeet singh -
                      Appear in this case ,its giving preference on autobackup control.
                      Glad to know that its has been fixed now.

                      Please close the thread if you feel you have the answer and keep the Oracle forum clean.
                      https://forums.oracle.com/forums/ann.jspa?annID=885