6 Replies Latest reply: Dec 27, 2013 11:51 PM by TSharma-Oracle RSS

    How to rename online redo log files in restore rman backup to another server with different asm location?

    884659

      I'm using Oracle Database 11.2.0.3.  I'm trying to restore (not using duplicate command) rman backup as another database (newtest) on another server with different asm location but I cannot figure how to rename redo log files.

       

      The following is the result returned from v$logfile of the database (test) which was backed up using rman:

       

          GROUP# STATUS  TYPE    MEMBER                                    
      ---------- ------- ------- -------------------------------------------
               1         STANDBY +REDOA/test/onlinelog/group_1.262.834271241
               1         STANDBY +REDOB/test/onlinelog/group_1.262.834271243
               2         STANDBY +REDOA/test/onlinelog/group_2.263.834271245
               2         STANDBY +REDOB/test/onlinelog/group_2.263.834271249
               3         STANDBY +REDOA/test/onlinelog/group_3.264.834271251
               3         STANDBY +REDOB/test/onlinelog/group_3.264.834271255
               4         STANDBY +REDOA/test/onlinelog/group_4.265.834271257
               4         STANDBY +REDOB/test/onlinelog/group_4.265.834271259
               5         STANDBY +REDOB/test/onlinelog/group_5.266.834271265
               5         STANDBY +REDOA/test/onlinelog/group_5.266.834271263
               6         STANDBY +REDOA/test/onlinelog/group_6.267.834271269
               6         STANDBY +REDOB/test/onlinelog/group_6.267.834271271
              17         ONLINE  +REDOA/redo17.log                         
              17         ONLINE  +REDOB/redo17.log                         
              18         ONLINE  +REDOB/redo18.log                         
              18         ONLINE  +REDOA/redo18.log                         
              19         ONLINE  +REDOB/redo19.log                         
              19         ONLINE  +REDOA/redo19.log                         
              20         ONLINE  +REDOB/redo20.log                         
              20         ONLINE  +REDOA/redo20.log                         
              21         ONLINE  +REDOA/redo21.log                         
              21         ONLINE  +REDOB/redo21.log                         
              22         ONLINE  +REDOA/redo22.log                         
              22         ONLINE  +REDOB/redo22.log                         

      24 rows selected

       

       

      The asm locations in the destination server are +REDOC and +REDOD so +REDOA should be renamed to +REDOC and +REDOB should renamed to +REDOD.  There won't be a standby database for database newtest.  I have tried adding

      *.log_file_name_convert='+REDOA','+REDOC','+REDOB','+REDOD' to inittest2.ora but I got the following errors:

       

      RMAN-03002:failure of alter db command

      ORA-00349: failure obtaining block size for '+REDOA/redo17.log'

      ORA-15001: diskgroup "REDOA" does not exist or is not mounted

      ORA-15001: diskgroup "REDOA" does not exist or is not mounted

       

       

       

      Thanks for any help.