Delete Database Orphan Incarnation
449399Oct 23 2008 — edited Apr 6 2011Hi,
I have an old incarnation in my controlfile that I would like to delete. I have a logical standby set on this DB, and would like to avoid recreating the controlfile. I am not using a catalog. Here is the output:
RMAN> list incarnation;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 PRDACRMW 780390117 PARENT 1 03-AUG-07
2 2 PRDACRMW 780390117 ORPHAN 10010005714362 10-JUN-08
3 3 PRDACRMW 780390117 CURRENT 10010005715977 10-JUN-08
I deleted all the expired backups and archivelogs, and my retention window is 30 days. This is a 10.2.0.3 database.
Thanks in advance!
Idan.