| Standby database : archive log shipping vs redo shipping [message #442789] |
Wed, 10 February 2010 09:21  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
