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