Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN backup for Golden Gate environment

RobeenJan 7 2020 — edited Jan 7 2020

Oracle DB 12.1.0.2

Solaris 11.4

RAC 12.1.0.2

downstream configuration from source to target.

Hello,

The golden gate tables(replicated from source to target) are located in a specific schema. Is it necessary to perform daily RMAN backup of the DB? The point is in case I will perform an RMAN restore, Golden Gate will need to be reconfigured and export and import of all the GG tables(using flashback_scn) will need to be done for Golden Gate config. In my opinion, an export dump (daily) of specific schemas will be much better and faster. Maybe a full backup once a week will be ok? or still do you suggest me to do daily level 1 RMAN backup? If yes, in case of restore, how should I resync the Golden Gate tables?

Regards,

Joe

Comments
Post Details
Added on Jan 7 2020
0 comments
469 views