11 Replies Latest reply: Dec 6, 2012 2:42 AM by 665048 RSS

    ORA-01180: Cannot create datafile 1 when doing RMAN restore onto 2nd server

    529785
      Hi all.

      I'm trying to do a restore of an RMAN backup onto a new server with a different directory structure as detailed in this doc:

      http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmrecov002.htm#sthref723

      I've got to point 7 and instead of doing all the steps in a script, I've run the SET NEWNAME & SET UNTIL SCN commands separately and am now trying the RESTORE but i get the following error:

      RMAN> restore database;

      Starting restore at 30-MAR-07
      using channel ORA_DISK_1
      using channel ORA_DISK_2

      creating datafile fno=1 name=/orabase/10.1/oradata/HRLIVE/system01.dbf
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of restore command at 03/30/2007 12:22:11
      ORA-01180: can not create datafile 1
      ORA-01110: data file 1: '/orabase/10.1/oradata/HRLIVE/system01.dbf'

      I'm wondering whether I used the correct SCN from v$loghistory on the Live database when i did the SET UNTIL command - could this be the problem??

      here are my RMAN settings on "hostb":

      RMAN> show all;

      RMAN configuration parameters are:
      CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
      CONFIGURE BACKUP OPTIMIZATION OFF; # default
      CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
      CONFIGURE CONTROLFILE AUTOBACKUP ON;
      CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oradisk_backup/RMAN/%F';
      CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
      CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
      CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
      CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/dump_area/RMAN/channel1_%U';
      CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/dump_area/RMAN/channel2_%U';
      CONFIGURE CHANNEL 3 DEVICE TYPE DISK FORMAT '/oradisk_backup/RMAN/channel3_%U';
      CONFIGURE MAXSETSIZE TO UNLIMITED; # default
      CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
      CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/orabase/db10_1EE/dbs/snapcf_HRLIVE.f'; # default

      the backupsets exist in '/dump_area/RMAN' and I've successfully restored the controlfile and spfile from here.

      thanks in advance for any help

      Ric.
      Oracle DBA
      20:20 Mobile Group

      ps. this in 10.1.0.4Enterprise Edition on RedHat AS4