8 Replies Latest reply: Nov 18, 2012 5:45 AM by 757501 RSS

    Recovery /restore through RMAN giving error

    757501
      Hi Everyone,

      I have a production server with Oracle 11g database, backup is happening thrice a day to G drive i.e. G:\archive
      I am creating a new database server, from the Backup as part of the audit (verify the backup), In the new test server i dont have the G drive. i copy the backup files to E drive i.e. e:\archive

      I have made the changes to PFILE, regarding the Controlfile path, flash recovery and Restore of Control files happens successfully, but when i try to restore the database, it says the backup has expired and the path it shows is of G:\archive and not E:\archive.

      Please help.


      Regards
      Jaskirat Singh
        • 1. Re: Recovery /restore through RMAN giving error
          mseberg
          Hello;

          From RMAN post
          SHOW ALL;
          Also post the backup script you are using.

          Best Regards

          mseberg
          • 2. Re: Recovery /restore through RMAN giving error
            757501
            HI,

            from RMAN Show ALL

            its reading the files from Old destination only and not from new (copied) backup location.
            • 3. Re: Recovery /restore through RMAN giving error
              mseberg
              Please post the results of

              SHOW ALL

              That is Not your backup script it is your restore script.

              Best Regards

              mseberg
              • 4. Re: Recovery /restore through RMAN giving error
                757501
                backup script being used is

                RUN
                {

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT01.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT01.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT02.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT02.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT03.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT03.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT04.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT04.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT05.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT05.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT06.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT06.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT07.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT07.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT08.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT08.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT09.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT09.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT10.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT10.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT11.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT11.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT12.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT12.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT13.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT13.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT14.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT14.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT15.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT15.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT16.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT16.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT17.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT17.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT18.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT18.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT19.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT19.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT20.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT20.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT21.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT21.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT21.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT21.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT22.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT22.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT23.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT23.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT24.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT24.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT25.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT25.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT26.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT26.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT27.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT27.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT28.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT28.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT29.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT29.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT30.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT30.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT31.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT31.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT32.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT32.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT33.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT33.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT34.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT34.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT35.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT35.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT36.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT36.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT37.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT37.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT38.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT38.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT39.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT39.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT40.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT40.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT41.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT41.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT42.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT42.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT43.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT43.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT44.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT44.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT45.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT45.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\DAT46.DBF' TO
                'K:\Oracle\11.2.0\Orcl\DAT46.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND01.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND01.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND02.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND02.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND03.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND03.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND04.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND04.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND05.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND05.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND06.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND06.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND07.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND07.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND08.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND08.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND09.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND09.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND10.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND10.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND11.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND11.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND12.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND12.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND13.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND13.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND14.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND14.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND15.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND15.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND16.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND16.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND17.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND17.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND18.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND18.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND19.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND19.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND20.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND20.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND21.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND21.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND22.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND22.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND23.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND23.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND24.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND24.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND25.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND25.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND26.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND26.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND27.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND27.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND28.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND28.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND29.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND29.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND30.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND30.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND31.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND31.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND32.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND32.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND33.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND33.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND34.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND34.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND35.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND35.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND36.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND36.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND37.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND37.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND38.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND38.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND39.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND39.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\IND40.DBF' TO
                'K:\Oracle\11.2.0\Orcl\IND40.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\USERS01.DBF' TO
                                    'K:\Oracle\11.2.0\Orcl\USERS01.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSTEM01.DBF' TO
                                    'K:\Oracle\11.2.0\Orcl\SYSTEM01.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\UNDOTBS01.DBF' TO
                                    'K:\Oracle\11.2.0\Orcl\UNDOTBS01.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSAUX01.DBF' TO
                               'K:\Oracle\11.2.0\Orcl\SYSAUX01.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\EXAMPLE01.DBF' TO
                               'K:\Oracle\11.2.0\Orcl\EXAMPLE01.DBF';

                SET NEWNAME FOR DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\UNDOTBS02.DBF' TO
                               'K:\Oracle\11.2.0\Orcl\UNDOTBS02.DBF';

                RESTORE database;

                SWITCH DATAFILE ALL;

                RECOVER database

                }

                At the time of Restore this is the error i get
                ORA-27041: unable to open file
                OSD-04002: unable to open file
                O/S-Error: (OS 3) The system cannot find the path specified.
                • 5. Re: Recovery /restore through RMAN giving error
                  757501
                  Sorry

                  backup Script is

                  RMAN> run {

                  allocate channel oem_disk_backup device type disk;

                  recover copy of database with tag 'ORA_OEM_LEVEL_0';

                  backup incremental level 1 cumulative copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;

                  }


                  Regards
                  Jaskirat Singh
                  • 6. Re: Recovery /restore through RMAN giving error
                    mseberg
                    Hello;

                    I would change my backup script to this :
                    RUN {
                    ALLOCATE CHANNEL ch1 TYPE
                    DISK FORMAT 'e:\archive\BACKUPS11%d_DB_%u_%s_%p';
                    BACKUP incremental level 0 DATABASE PLUS ARCHIVELOG;
                    RELEASE CHANNEL ch1;
                    }
                    And I would change my CONFIGURE too
                    RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON;
                    
                    CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
                    RETENTION POLICY can be greater, but I never was able to see it.

                    Please consider marking your question as answered.

                    Best Regards

                    mseberg
                    • 7. Re: Recovery /restore through RMAN giving error
                      Shivananda Rao
                      Hello Jaskirat,

                      If I've understood your problem correctly, then you mean to say that you have mounted the new database successfully by restoring the controlfile but restoring the database is failing. The reason why controlfile is saying that the backup is expired and the reason why it is showing as "G:\archive" is because that the newly restored controlfile is unaware that you have copied the backups to the location "E:\archive" on the new server. On the production, you had taken the backup at location "G:\archive" and you restore the same controlfile on the new server which is completely unaware of the new location.

                      After you restored the controlfile, catalog the backup pieces stored at "E:\archive" so that the controlfile looks for the backup at this location and not at "G:\archive".
                      RMAN>catalog start with 'E:\archive';
                      Say YES when RMAN asks to catalog the backups placed at E:\archive and then
                      RMAN>restore database;
                      RMAN>recover database;
                      This might help you out http://shivanandarao.wordpress.com/2012/04/19/duplicating-primary-database-to-a-new-host-without-connecting-to-the-primary-database-in-oracle-10g11g/

                      Please consider closing your question by providing appropriate points once your issue is resolved.
                      • 8. Re: Recovery /restore through RMAN giving error
                        757501
                        Thanks everyone,

                        For the time being, all i did is i have renamed the drive letter from E to G drive and it has restored the database since it was looking for the backup files in G drive.
                        this has resolved my issue.

                        Lets see now how much time it take to restore 600 GB Database. :)

                        Thanks once again.



                        Regards
                        Jaskirat Singh