Home > RMAN > ORA-01180: can not create datafile 1

ORA-01180: can not create datafile 1

Symptoms

I moved the backup sets  from a production 10g database into a development server for restoration. I could restore spfile and control files. Once  I started the database in mount mode and restore database. It returned the following errors.

creating datafile fno=1 name=/u01/oradata/videv/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/10/2011 22:32:23
ORA-01180: can not create datafile 1
ORA-01110: data file 1: ‘/u01/oradata/videv/system01.dbf’

Fix

Then I cataloged the backup sets, it worked as the following

RMAN> catalog start with ‘/u01/oracle/instance/bkup_VIDEV_3509_1_750301226.dat';

using target database control file instead of recovery catalog
searching for all files that match the pattern /u01/oracle/instance/bkup_VIDEV_3509_1_750301226.dat

List of Files Unknown to the Database
=====================================
File Name: /u01/oracle/instance/bkup_VIDEV_3509_1_750301226.dat

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files…
cataloging done

List of Cataloged Files
=======================
File Name: /u01/oracle/instance/bkup_VIDEV_3509_1_750301226.dat

RMAN> restore database;

Starting restore at 10-MAY-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=2193 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/oradata/videv/system01.dbf
restoring datafile 00002 to /u01/oradata/videv/undotbs01.dbf
restoring datafile 00003 to /u01/oradata/videv/sysaux01.dbf
restoring datafile 00004 to /u01/oradata/videv/users01.dbf
restoring datafile 00005 to /u01/oradata/videv/vi_tbs_dat01_01.dbf
restoring datafile 00006 to /u01/oradata/videv/vi_tbs_dat02_01.dbf
restoring datafile 00007 to /u01/oradata/videv/vi_tbs_dat03_01.dbf
restoring datafile 00008 to /u01/oradata/videv/vi_tbs_idx01_01.dbf
restoring datafile 00009 to /u01/oradata/videv/vi_tbs_idx02_01.dbf
restoring datafile 00010 to /u01/oradata/videv/vi_tbs_idx03_01.dbf
channel ORA_DISK_1: reading from backup piece /u01/oracle/instance/bkup_VIDEV_3509_1_750301226.dat

channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/oracle/instance/bkup_VIDEV_3509_1_750301226.dat tag=TAG20110505T010026
channel ORA_DISK_1: restore complete, elapsed time: 00:09:09
Finished restore at 10-MAY-11

About these ads
Categories: RMAN
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: