This discussion is archived
8 Replies Latest reply: Nov 18, 2012 3:45 AM by 757501 RSS

Recovery /restore through RMAN giving error

757501 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points