Monday 29 May 2017

Restore failed with error ORA-01180: can not create datafile 1,ORA-01110: data file 1:

Issue while restoring standby database
Error:
creating datafile file number=1 name=+DATA/datafile/system.720.852465663
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/29/2017 01:58:08
ORA-01180: cannot create datafile 1
ORA-01110: data file 1: '+DATA/datafile/system.720.852465663'

As per oracle Doc ID 1573040.1  removed the Flash Recovery Area  parameters from the pfile  and used instead log_archive_dest_1, But no luck ,got same error
Checked incarnation on both production and standby side
RMAN>  list incarnation of database;----> Primary side
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       JAYAPRD   908018610        PARENT  1          14-AUG-09
2       2       JAYAPRD   908018610        ORPHAN  87595686997 05-AUG-14
3       3       JAYAPRD   908018610        CURRENT 87868863592 08-AUG-14

RMAN> list incarnation of database; ----> Standby side
List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       JAYAPRD   908018610        PARENT  1          14-AUG-09
2       2       JAYAPRD   908018610        ORPHAN  87595686997 05-AUG-14
3       3       JAYAPRD   908018610        PARENT  87868863592 08-AUG-14
6       6       JAYAPRD   908018610        ORPHAN  127718131302 17-OCT-16
4       4       JAYAPRD   908018610        ORPHAN  134661702530 10-MAR-17
5       5       JAYAPRD   908018610        CURRENT 138397007243 25-MAY-17

Change incarnation on standby side to 3
RMAN> reset database to incarnation 3;
database reset to incarnation 3

àRestore will work without any issue  

No comments:

Post a Comment