pro/standby solution

[prodadmin]

hi

need some help

1/ assume i have db01(pro) and db02(standby) accessing same disk array and, if the db01 goes down i can activate db02.

2/if forexample db01 has data corruption like my redologs are corrupted the same thing will happen to db02., in this case my stanby will not help me.


is there any way i can preven my data corruption will not happen to stanby..I am sure lot of people might be using some thing to prevent these kind.



pls advise...

Thanks

[anandkl]

Hi,
Can u please let us know how u have created or planing to create the standby db.

From your info i understand that both PRO and standby are using the same .dbf files. If this is the case then there is not point or benifit of having a standby like this and more over i dont think a standby can be created like this.

Please give us more info if my above understanding is wrong.

regards
anandkl

[stmontgo]

Originally posted by prodadmin
hi

need some help

1/ assume i have db01(pro) and db02(standby) accessing same disk array and, if the db01 goes down i can activate db02.

2/if forexample db01 has data corruption like my redologs are corrupted the same thing will happen to db02., in this case my stanby will not help me.


why is this true? perhaps only one block on the array is corrupt?



pls advise...

Thanks

you could also have your standsby configured so that it's a few hours behind the primary so if the primary db get's corrupted you can roll forward to PIT before corruption on standby.

[marist89]

If that's your concern, you can use a logical standby.

[prodadmin]

what do you mean by logical standby ?
do we need to write a custom program for this?

you could also have your standsby configured so that it's a few hours behind the primary so if the primary db get's corrupted
You can roll forward to PIT before corruption on standby

Our system cannot afford to loose 10 minutes In 10 minutes i will be loosing 434 jobs ona busy day

[marist89]

Originally posted by prodadmin
what do you mean by logical standby ?
do we need to write a custom program for this?

http://tahiti.oracle.com search for logical standby

[stmontgo]

Originally posted by prodadmin
what do you mean by logical standby ?
do we need to write a custom program for this?




Our system cannot afford to loose 10 minutes In 10 minutes i will be loosing 434 jobs ona busy day

if you can't tolerate 10 mins of down time I'd suggest RAC with a physical standby running gauaranteed no data loss mode at a remote location as well a physical standby runnning with a time lag in the same location as the rac.

[marist89]

I can see it now, "But we can't affor that solution..."