Forum Stats

  • 3,825,996 Users
  • 2,260,586 Discussions
  • 7,896,760 Comments

Discussions

standby database incarnations

User_UAEUZ
User_UAEUZ Member Posts: 188 Blue Ribbon

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