This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,831 Users
  • 2,269,775 Discussions
  • 7,916,823 Comments

Discussions

Categories

Incremental Export/Import

LANCERIQUE
LANCERIQUE Member Posts: 180
edited Jan 11, 2016 6:02PM in Database Ideas - Ideas

Hi All,

The way we take an incremental backup in RMAN, can we have same functionality for Logical backup i.e. incremental export/import.

Advantages.

1) It will be very useful during Server Tech refresh where you need to migrate a database from one server to other. In this scenario, we can easily using incremental export/import to migrate the data in a limited downtime.

Regards,

Lancerique.

LANCERIQUEvinaykumar2JagadekaractriebmarkmevansPravin TakpireJitendracaadecarvalhoabhinivesh.jainManish ChaturvediborneselKiran PawarGeert Gruwezuser12218407Ajay VijayanPS_orclNerd
Share on TwitterShare on Facebook
13
Up Down
19 votes

Active · Last Updated

Comments

  • berx
    berx AustriaMember Posts: 219 Silver Badge

    Even this sounds a nice idea, it gets very complex when you dig into the details.

    At the end you have to check all the details any logical replication solution has to check.

    As long as only new columns are inserted you are fine, but from the moment where updates are made, those need to be tracked.

    To get an rough idea think about the technology used in materialized views, advanced replication, streams, logical dataguard, golden gate, ...

    · Share on TwitterShare on Facebook
  • Pravin Takpire
    Pravin Takpire Technical Manager BangaloreMember Posts: 1,770 Gold Trophy

    Though seems to be good idea, it would be very difficult to implement. And also you have other options like transportable tablespaces to migrate to different servers.

    regards

    Pravin

    · Share on TwitterShare on Facebook
  • top.gun
    top.gun Member Posts: 3,666 Gold Crown

    RMAN is very good with TTS, and migration conversions (eg endian and O/S conversions).

    Incremental datapump would surely be slower than RMAN (using inc0/inc1/archivelogs)

    So how would a migration using an incremental datapump be better than RMAN?

    · Share on TwitterShare on Facebook
  • top.gun
    top.gun Member Posts: 3,666 Gold Crown

    To migrate with no downtime you need replication, so the product to use is Golden Gate.

    · Share on TwitterShare on Facebook