10 Replies Latest reply on Oct 8, 2013 1:53 AM by Hemant K Chitale

    Restore DB from RAC (two nodes) DB to single node

    Mody82

      Hi guys,

       

           Environment:

                DB on RAC (2 nodes)

                OS Windows 2008R2

                Oracle 11gR2

                Backup : EMC Networker.

       

           Requirements :

                Need to do restore for this DB on another machine (one node) , for testing and updating purpose.

       

           Issue :

           Recovery is not succeeded , but restore of Controlfiles and DataFiles is done successfully to the new machine with new directory structures.

       

           Error:

      ORA-10879: error signaled in parallel recovery slave

      ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

      ORA-01152: file 1 was not restored from a sufficiently old backup

      ORA-01110: data file 1: 'D:\APP\DATA\SYSTEM01.DBF'

       

           Now, wants to open the DB after recovery, How can I do that ? (need a scripts ...)

       

       

      FYI , Scripts using ##

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

      run

      {

      ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'

      parms 'ENV=(NSR_SERVER=bkpsrv,NSR_CLIENT=dbsrv)';

      ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE'

      parms 'ENV=(NSR_SERVER=bkpsrv,NSR_CLIENT=dbsrv)';

      SET NEWNAME FOR DATAFILE '+DBDATA/SYSTEM.256.777377935' TO 'D:\app\data\SYSTEM01.DBF';

      SET NEWNAME FOR DATAFILE '+DBDATA/sysaux.257.777377935' to 'D:\app\data\sysaux.dbf';

      SET NEWNAME FOR DATAFILE '+DBDATA/undotbs1.258.777377935' to 'D:\app\data\undotbs01.dbf';

      SET NEWNAME FOR DATAFILE '+DBDATA/users.259.777377935' to 'D:\app\data\users01.dbf';

      SET NEWNAME FOR DATAFILE '+DBDATA/undotbs2.264.777378113' to 'D:\app\data\undotbs02.dbf';

      set until sequence 16510;

      restore database;

      recover database;

      RELEASE CHANNEL ch00;

      RELEASE CHANNEL ch01;

      }

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