Home » Server Options » Streams & AQ » Oracle streams (10g and 9i RAC / Solaris and AIX )
Oracle streams [message #417446] Sat, 08 August 2009 16:08 Go to next message
krarjunkanna
Messages: 1
Registered: July 2009
Junior Member
Hi,
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....

Re: Oracle streams [message #417454 is a reply to message #417446] Sun, 09 August 2009 00:42 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How should I backup when streams apply process is enabled


If it is a cold backup then database is down and there is no apply process.

Quote:
Is there any manual procedure for sync the apply process after completing the backup?

No, apply will continue at the step it was stopped.

Regards
Michel
Previous Topic: AQ plsql callback won't work (9i)
Next Topic: Numeric Data Conversion from Oracle to SQL Server
Goto Forum:
  


Current Time: Fri Mar 29 01:47:00 CDT 2024