Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Delete Database Orphan Incarnation

449399Oct 23 2008 — edited Apr 6 2011
Hi,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 4 2011
Added on Oct 23 2008
2 comments
8,879 views