Home » Server Options » Data Guard » Standby database : archive log shipping vs redo shipping (Oracle 8i,9i,10g)
Standby database : archive log shipping vs redo shipping [message #442789] Wed, 10 February 2010 09:21 Go to next message
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
Senior Member
Hi,

I was tring to understand the difference between archive redo shipping which was existing in 8i and in 9i
though we have redo shipping as well in 9i

my confusion started and continued with statements like logs are archived on standby database (even) in 8i

according to my understanding :

1)
8i,9i
archive log shipping :
archive logs are created on primary and are transported to standby database and then are applied on standby database

2)
9i
redolog shipping
the online redo logs are transported on standby database and are applied on standby database and then are archived on standby database

3)
9i,10g
standby redologs
these are additional redo logs with its' location on standby database server
Not sure when these standby redo logs apply while redo logs are available


Is my understanding clear or archivelogs are created 'simlutaneoulsy' on primary as well as standby database?

Thanks and Regards,
Chetana
Re: Standby database : archive log shipping vs redo shipping [message #442790 is a reply to message #442789] Wed, 10 February 2010 09:32 Go to previous message
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
Senior Member
Correction ..Please help me understand this

the standby redo logs are just an additional copy of redologs on the standby database as transported bt LGWR then those are applied and then archived or vice versa?

A-1)
8i,9i
archivelogs are created on primary
arch process transports archivelogs to standby database
these archivelogs are applied to standby database.

OR

A-2)
8i,9i
archivelogs are simulateously created on primary as well as standby database
these archivelogs are applied to standby database.


And

B-1)
9i,10g
LGWR creates additional copy of online redo logs on standby database - standby redo logs
online redo logs are archived on local database
standby redologs are archived on standby database
above archivelogs are applied to standby database
thus there is no transport of archivelogs from primary to standby

OR

B-2)
9i,10g
LGWR creates additional copy of online redo logs on standby database - standby redo logs
online redo logs are archived on local database
standby redologs are applied to standby database
above standby redologs are archived on standby database
thus there is no transport of archivelogs from primary to standby

Thanks and Regards,
Chetana
Previous Topic: DATA GURAD IMPLENTATION
Next Topic: How to create 10g standby database???
Goto Forum:
  


Current Time: Thu Mar 28 18:47:50 CDT 2024