High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Can't duplicate for standby after reset incarnation

My scenario is this:

I have an Oracle database 10.2.0.4, called PRD, that on Apr 6 was rolled back to a previous incarnation.

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Apr 9 19:20:49 2014

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: PRD (DBID=1505744328)

connected to recovery catalog database

RMAN> list incarnation;

List of Database Incarnations

DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1      16      PRD      1505744328      PARENT  23754008914 21-JUL-07

1      2      PRD      1505744328      PARENT  24604164826 11-OCT-07

1      687387  PRD      1505744328      ORPHAN  11313935734057 23-MAY-13

1      726196  PRD      1505744328      PARENT  11313937887395 22-MAY-13

1      725008  PRD      1505744328      ORPHAN  11313963537516 23-MAY-13

1      725839  PRD      1505744328      CURRENT 11314042440148 29-MAY-13

1      989933  PRD      1505744328      ORPHAN  11321546326614 16-MAR-14

RMAN>

Then on Apr 8 a full backup was taken.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center