-
pro/standby solution
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
-
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
anandkl
-
Re: pro/standby solution
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.
I'm stmontgo and I approve of this message
-
If that's your concern, you can use a logical standby.
Jeff Hunter
-
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
-
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
Jeff Hunter
-
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.
I'm stmontgo and I approve of this message
-
I can see it now, "But we can't affor that solution..."
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|