Is it possible to flashback a logical standby that's been opened and modified to where it was opened
edited Jan 15, 2013 2:26AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 1 commentAnswered
This is easier to do with Golden Gate but I don't have that product available.
I want to do a rolling upgrade and change of platform of a database, from Oracle 10.2.0.5 to 11gR2 and from Solaris to Linux.
Rather than having to re-migrate the database to Linux, upgrade it yet again and restart SQL Apply after test sessions on the new database that will effectively "trash" it with DML/DDL, is it possible for me to note the SCN when I open the database for testing, flash it back when that round of testing is over then restart SQL Apply?
I want to do a rolling upgrade and change of platform of a database, from Oracle 10.2.0.5 to 11gR2 and from Solaris to Linux.
Rather than having to re-migrate the database to Linux, upgrade it yet again and restart SQL Apply after test sessions on the new database that will effectively "trash" it with DML/DDL, is it possible for me to note the SCN when I open the database for testing, flash it back when that round of testing is over then restart SQL Apply?
0