Hello!
How can i remove orphan incarnations of database?
The command
DELETE FROM dbinc WHERE dbinc_key=nnn;
mentioned in an other discussion is not possible, because no rman-catalog is present.
Thanks for your help.
Gerhard
RMAN> delete noprompt obsolete orphan;
using channel ORA_SBT_TAPE_1
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 711 23-SEP-13
Backup Piece 711 23-SEP-13 arch_ofokjarj_1_1
Backup Set 712 23-SEP-13
Backup Piece 712 23-SEP-13 arch_ogokjarj_1_1
Backup Set 713 23-SEP-13
Backup Piece 713 23-SEP-13 arch_ohokjaua_1_1
deleted backup piece
backup piece handle=arch_ofokjarj_1_1 RECID=711 STAMP=826911603
deleted backup piece
backup piece handle=arch_ogokjarj_1_1 RECID=712 STAMP=826911603
deleted backup piece
backup piece handle=arch_ohokjaua_1_1 RECID=713 STAMP=826911690
Deleted 3 objects
RMAN> list incarnation;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 LRSEQ 664050852 PARENT 1 21-OCT-11
2 2 LRSEQ 664050852 PARENT 1022598 22-APR-13
5 5 LRSEQ 664050852 CURRENT 3257779 22-MAY-13
3 3 LRSEQ 664050852 ORPHAN 3257779 17-MAY-13
4 4 LRSEQ 664050852 ORPHAN 1552694328 22-MAY-13