In my prod environment, oracle streams is implemented between oracle 10g and oracle 9i RAC.
It is a Table level that captures DML for XXX table in oracle10g and applies the changes to XXX table in oracle9i RAC.
The question is
I have to take coldbackup for oracle9i RAC (apply prcocess taking place), How should I backup when streams apply process is enabled
Is there any manual procedure for sync the apply process after completing the backup?
thanks in advance....
use rman and take a hotbackup, therfore you dont need to worry about anything
The customer has designed (backup stratergy) coldbackup for every weekend.
Your option was good, but RMAN backup is not configured.
configure it then - there is no need for a cold backup to take place
Click Here to Expand Forum to Full Width