3 Replies Latest reply: Sep 8, 2013 8:55 PM by Hemant K Chitale RSS

    set new name in RMAN

    977068

      Hi,

       

      We have 12 TB of data to be restored from PROD to DEV.

       

      In Prod, we have ASM having 12TB of space and in DEV, we have 2 filesystem (DATA1 & DATA2) shares 6TB each.

       

      We used the below script for RMAN restore using set new name to restore it to the different locations in DEV:

       

      connect target /

      run

      {

      sql "alter session set optimizer_mode=RULE";

      allocate channel c1 device type disk;

      allocate channel c2 device type disk;

      allocate channel c3 device type disk;

      allocate channel c4 device type disk;

      allocate channel c5 device type disk;

      allocate channel c6 device type disk;

      allocate channel c7 device type disk;

      allocate channel c8 device type disk;

      allocate channel c9 device type disk;

      allocate channel c10 device type disk;

      allocate channel c11 device type disk;

      CATALOG START WITH '/oracle/backup/ora-prod-ebs/RMAN/EBSGOLD_08062013';

      set until time "to_date('2013-JUL-14 01:00:00','YYYY-MON-DD HH24:MI:SS')";

      SET NEWNAME FOR DATAFILE '+DATA/stbyprod/datafile/a_media08.dbf' to '/oracle/oradata/VMWDEV1/DATA1/VMPRD/a_media08.dbf';

      SET NEWNAME FOR DATAFILE '+DATA/stbyprod/datafile/a_media02.dbf' to '/oracle/oradata/VMWDEV1/DATA1/VMPRD/a_media02.dbf';

      SET NEWNAME FOR DATAFILE '+DATA/stbyprod/datafile/a_media03.dbf' to '/oracle/oradata/VMWDEV1/DATA1/VMPRD/a_media03.dbf';

      SET NEWNAME FOR DATAFILE '+DATA/stbyprod/datafile/a_media04.dbf' to '/oracle/oradata/VMWDEV1/DATA1/VMPRD/a_media04.dbf';

      SET NEWNAME FOR DATAFILE '+DATA/stbyprod/datafile/a_media05.dbf' to '/oracle/oradata/VMWDEV1/DATA1/VMPRD/a_media05.dbf';

      SET NEWNAME FOR DATAFILE '+DATA/stbyprod/datafile/apps_ts_tx_idx.521.799600075' to '/oracle/oradata/VMWDEV1/DATA1/VMPRD/apps

      .......................................................................................

      ..........................................................................................

      ......................................................................................

      SET NEWNAME FOR DATAFILE '+DATA/stbyprod/datafile/sysaux.344.809874457' to '/oracle/oradata/VMWDEV1/DATA2/VMPRD/sysaux.344.809874457';

      SET NEWNAME FOR DATAFILE '+DATA/stbyprod/datafile/apps_ts_tx_data.343.810623133' to '/oracle/oradata/VMWDEV1/DATA2/VMPRD/apps_ts_tx_data.343.810623133';

      SET NEWNAME FOR DATAFILE '+DATA/stbyprod/datafile/apps_ts_tx_data.342.810623199' to '/oracle/oradata/VMWDEV1/DATA2/VMPRD/apps_ts_tx_data.342.810623199';

      SET NEWNAME FOR DATAFILE '+DATA/stbyprod/datafile/apps_ts_tx_data.341.810623265' to '/oracle/oradata/VMWDEV1/DATA2/VMPRD/apps_ts_tx_data.341.810623265';

      SET NEWNAME FOR DATAFILE '+DATA/stbyprod/datafile/apps_ts_tx_data.340.810623327' to '/oracle/oradata/VMWDEV1/DATA2/VMPRD/apps_ts_tx_data.340.810623327';

      SET NEWNAME FOR DATAFILE '+DATA/stbyprod/datafile/apps_ts_tx_data.339.810623399' to '/oracle/oradata/VMWDEV1/DATA2/VMPRD/apps_ts_tx_data.339.810623399';

      SET NEWNAME FOR DATAFILE '+DATA/stbyprod/datafile/apps_ts_tx_data.338.810623475' to '/oracle/oradata/VMWDEV1/DATA2/VMPRD/apps_ts_tx_data.338.810623475';

      SET NEWNAME FOR DATAFILE '+DATA/stbyprod/datafile/apps_ts_tx_data.337.810623543' to '/oracle/oradata/VMWDEV1/DATA2/VMPRD/apps_ts_tx_data.337.810623543';

      SET NEWNAME FOR DATAFILE '+DATA/stbyprod/datafile/apps_ts_tx_data.336.810623611' to '/oracle/oradata/VMWDEV1/DATA2/VMPRD/apps_ts_tx_data.336.810623611';

      restore database;

      switch datafile all;

      recover database delete archivelog;

      alter database open resetlogs;

      }

       

       

      But, unfortunately all the files were getting restored to only one of the filesystem DATA1 and not to DATA2 at all.

      Hence, RMAN restore failed with the following error since no space is available in DATA1

       

      channel c9: ORA-19870: error while restoring backup piece /oracle/backup/ora-prod-ebs/RMAN/EBSGOLD_08062013/vmwprod_full_backup_JUN8_VMWPROD_34228_1

      ORA-19502: write error on file "/oracle/oradata/VMWDEV1/DATA1/VMPRD/a_txn_data01.dbf", block number 523904 (block size=8192)

      ORA-27072: File I/O error

      Linux-x86_64 Error: 28: No space left on device

      Additional information: 4

      Additional information: 523904

      Additional information: -

      failover to previous backup

       

      Please help us to solve this issue.

       

      DB Version: 11.2.0.3