Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
standby database incarnations

hi all
incarnation 1 - flashback on / archivelog on standby database
T1) generated flashback logs
T2) generated archive logs
T3) alter database activate standby database;
incarnation 2 - flashback on / archivelog on primary ( ex-standby ) database
T4) generated flashback logs
T5) generated archive logs
T6) flashback database to_timestamp sysdate-1
T7) apply archive gap / mrp as usual
incarnation 2 became orphaned in v$database_incarnations
=============
q1) how do we delete
i) orphan incarnation in controlfile
ii) orphan archivelogs in T5
iii) orphan flashback logs in T4
that belongs to incarnation 2
=============
q2) are flashback logs / archivelogs from incarnation1 generated at T1 and T2 still usable after T7 ?
=============
q3) anyway to flash "forward" back to incarnation 2 after flashing back to incarnation 1 ?
thank you