Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I know it's possible to generate a full rman backup in a 10.2g database, move it to another server containing 11g, restore it there and finally do an upgrade.

Since I have to do this to a large database and there are several things involved (apps, servers, network, etc), it could take me a few days and not only one night.

Could I make a full rman backup in 10.2g, restore it in 11g, upgrade, and in the next days go making incremental rman backups in 10g and restoring it in 11g, until we decide to shutdown 10g and use 11g in production. Something like a standby database, but in this case current database would be 10g and standby database would be 11g.

share|improve this question
    
It won't work for many reasons, sorry. –  Phil Oct 26 '12 at 18:05
add comment

1 Answer 1

Once you upgrade the destination database to 11.2, you won't be able to apply archived logs (or incremental backups) from a 10.2 database. So no, this won't work.

It is, on the other hand, often possible to use an actual standby database to perform a rolling upgrade. You can create the 11.2 database as a logical standby of the 10.2 database, let the SQL apply process keep the databases in sync, and then switch over to the 11.2 database when you are ready to migrate. In a similar vein, you could also use Streams between the 10.2 database and the 11.2 database to keep the data synchronized and then switch over when you're ready to migrate.

share|improve this answer
    
Good point, but OP should surely thoroughly check the list of unsupported types for logical standby. Otherwise OP would get into great trouble in this scenario. –  kubanczyk Nov 24 '12 at 21:58
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.