Mani's Blog

November 4, 2011

RMAN-00571 RMAN-00569 ORA-01110 ORA-01180: can not create datafile 1

Filed under: Backup,Database,Oracle,RMAN — mani @ 5:05 pm
Tags:

Problem: while I was trying to restore RMAN backup into standby server.  Ran into below issues.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/02/2011 04:14:17
ORA-01180: can not create datafile 1
ORA-01110: data file 1: ‘+XN_DATA/xnodb02c/datafile/system.263.709351843’

Fix:  Tried many things like checking permission of ASM, the backup location is readable and list backup.  All looked good.  Finally checked incarnation, we had multiple incarnation.  I switch the incarnation and tried the restore then all went well.  Hope it is helpful to someone.

RMAN> list incarnation;

using target database control file instead of recovery catalog

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
——- ——- ——– —————- — ———- ———-
1       1       XNODB02C 2305192664       PARENT  1          27-JAN-10
2       2       XNODB02C 2305192664       CURRENT  1238601811 19-AUG-11

RMAN>

Fix:  Changed the incarnation.

RMAN> reset database to incarnation 1;

database reset to incarnation 1

Ran restore and recover.

run {
allocate channel d1 device type disk;
allocate channel d2 device type disk;
allocate channel d3 device type disk;
allocate channel d4 device type disk;
@new_names.cmd
restore database;
switch datafile all;
switch tempfile all;
recover database;
}

alter database open resetlogs;

 

Advertisements

2 Comments »

  1. Thanks mani sir,

    Regards,
    venkatesh

    Comment by Venkatesh — August 28, 2012 @ 10:42 am | Reply

  2. Sir, Can you please explain me that why this reset incarnation to the Parent (1) resolves our problem ?

    Comment by Tejas S A — January 8, 2013 @ 6:50 am | Reply


RSS feed for comments on this post. TrackBack URI

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

Blog at WordPress.com.

%d bloggers like this: