Thanks ANkur & others....Here're my concerns now.
Issue#1...My standby setting is indeed optional( by
default) 'cuz I use LGWR ASYNC NO AFFIRM for
log_archive_dest_2. In this case, I don't understand
why primary failed when I opened standby in managed
recovery mode after standby crashed. FYI, there was an
archive log gap between standby & primary (the
archivelogs making that gap were backed up by rman &
deleted from primary. Is this the reason why primary
failed?). Local archiveing on primary is set to
mandatory.
Issue#2: There are 2 cronjobs that the customer is
running on the primary database(9.0.1.3). These
cronjobs access some materialized views & create row
level locks on the tables. This causes locks(not sure
of deadlocks) due to which other processe hang. WHen I
try to kill these hanging oracle sessions, it marks it
for killing but doesn't kill it( looks like undo
segments ain't table to undo or are very slow)..When I
look for this process on OS side, it doesn't exist. So
the only alternative for me is to do a shutdown abort(
'cuz shutdown immidiate takes forever)...When I
startup up the primary, its comes up fine & things
start to roll thru' fine. THis has happened twice in 2
days now.( whenever the cusotmer runs these cronjobs).
I've asked them to remove these crons for now.
What is all this happeneing? Is this a bug? Where can
I find a similar postinng/article? Is there any white
paper for this? Please advise.
Thanks a lot in advance!
--- Ankur Shah <[Email Address Removed] wrote:
> Even Oracle recommends OPTIONAL , to have your
> production unaffected as what U are might missed out
> due to network error is nothing but a recovery
> data
> and that too U can recover manually
>
> But getting the Production hang over for a a HA
> solution
> that fails is not what I think should be a
> preference
>
> ========================================
>
> Regards
>
> Ankur Shah
> Oracle DBA
> DHR-GA
>
>
>
>
>
> ----- Original Message -----
> From: "Ashish Saxena" <[Email Address Removed] To: "Ankur Shah" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Sent: Friday, August 23, 2002 2:54 PM
> Subject: Re: Oracle 9i Data Guard Down. Please Help!
>
>
> Thanks Ankur,
> Your explaination helped. But with init.ora setting
> of
> OPTIONAL,there may be a risk of standby going down
> again(due to network/disk issues currently
> happening)
> and missing data. But nevertheless, Your idea of
> having OPTIONAL with reopen every few minutes
> gretaly
> helps my current situation.
> Thanks again...
>
> Ashish
>
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
=====
Ashish Saxena
Oracle DBA
__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
Oracle LazyDBA home page