This discussion is archived
11 Replies Latest reply: Dec 6, 2012 12:42 AM by 665048 RSS

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

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