RE: Oracle Support and Standby
Date: Mon, 11 Apr 2016 18:58:07 +0000
Message-ID: <BY1PR09MB0535DA7796E59FAD9F24EC9289940_at_BY1PR09MB0535.namprd09.prod.outlook.com>
Yes, thank you for listening to my rant!
I have a primary and a non-active standby; we only use the standby for disaster recovery.
This weekend there was an application upgrade. It didn't go well but we had set a guaranteed restore point. We flashed back the primary and then also the standby:
Primary:
stop log apply
shut down database
startup database In mount
flashback to GRP
shutdown
select resetlogs_change# from v$database: and note the number
Standby:
flashback standby database to scn <primary scn -2);
stop database
start in mount (since it's a physical standby non-active)
At this point I'm going to say that someone else was driving the ship and it all went by fast. Then they went on vacation :(
This first flashback worked, we restarted Data Guard and were good to go.
The redid the application, had more problems so needed to flashback again.
We flashed back to the same GRP. Got the same information for the SCN and did the same scenario. At first we got the same message about the database being 'diverged', now we are getting
Warning: the given resetlogs_id 908669300 is not on the valid incarnation path.
There were some things done with incarnations that weren't recorded, a bad thing I know. I think she was thinking that "this will fix it and we're good" but now, a few days later not so good to not know this.
On the primary:
RMAN> list incarnation of database;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ---------- 1 2 COLLABP 951429914 PARENT 1 13-NOV-2014 13:39:38 1 811470 COLLABP 951429914 ORPHAN 77425738806 08-APR-2016 21:22:50 1 813678 COLLABP 951429914 ORPHAN 77425738806 08-APR-2016 23:22:00 1 816123 COLLABP 951429914 ORPHAN 77425738806 09-APR-2016 00:08:20 1 818353 COLLABP 951429914 CURRENT 77425738806 09-APR-2016 00:22:46
Standby:
RMAN> list incarnation of database;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ---------- 1 2 COLLABP 951429914 PARENT 1 13-NOV-2014 13:39:38 1 811470 COLLABP 951429914 ORPHAN 77425738806 08-APR-2016 21:22:50 1 813678 COLLABP 951429914 ORPHAN 77425738806 08-APR-2016 23:22:00 1 816123 COLLABP 951429914 ORPHAN 77425738806 09-APR-2016 00:08:20 1 818353 COLLABP 951429914 CURRENT 77425738806 09-APR-2016 00:22:46 *********************************************************Sherrie Kubis
Sr. Oracle DBA
Information Technology Bureau
Southwest Florida Water Management District 2379 Broad Street
Brooksville, FL 34604-6899
352.796.7211 x4033
sherrie.kubis_at_swfwmd.state.fl.us
Please take a moment to answer a few questions and let us how we're doing.
IMPORTANT NOTICE
E-mails made or received in conjunction with the official business of the District are public records. All e-mails sent to and from this address are automatically archived. For more information regarding the State of Florida public records laws, please visit www.myflorida.com.
-----Original Message-----
From: RajeevGM [mailto:rprabha01_at_gmail.com]
Sent: Monday, April 11, 2016 1:49 PM
To: Sherrie Kubis <Sherrie.Kubis_at_swfwmd.state.fl.us>
Cc: oracle-l_at_freelists.org
Subject: Re: Oracle Support
Sherrie,
My experience, for any non-Sev1 SRs, the turn around time varies..
Anyway, could you please describe the issue/ errors visible on the standby db ?
Rajeev
> On Apr 11, 2016, at 1:29 PM, Sherrie Kubis <Sherrie.Kubis_at_swfwmd.state.fl.us> wrote:
>
> Anyone else have this kind of experience with Oracle Support?
>
> I opened a ticket for a hosed standby on Saturday. I understand that because it's not a down system it can't be a Sev 1, and now I know that only a Sev 1 system gets weekend attention.
>
> Now it is Monday afternoon. I called support to ask what the status is, and the music was so loud I couldn't hear the person. I asked if she would hang up and call me back. Instead, she updated the ticket that an analyst needed to call me.
>
> Then I called back again (no music this time) and was told support engineers are only working Sev 1 tickets right now, they have a backlog. But somebody would call me back. When I asked when, she said "well, everyone is on their meal break, so it will be another 45 minutes before I can ask that". What? I know they have to eat, but really, everyone goes at the same time? I say that to myself as I'm eating my salad while sitting at my desk hoping for help.
>
> Because of budget cuts my management has asked me to think about third-party support and dropping maintenance, as most of our Districts are moving to another platform because of state budgets. I was horrified at first, thinking "how can I support Oracle databases without true Oracle support?!" Now I think I know.
>
>
>
> *********************************************************
> Sherrie Kubis
> Sr. Oracle DBA
> Information Technology Bureau
> Southwest Florida Water Management District
> 2379 Broad Street
> Brooksville, FL 34604-6899
> 352.796.7211 x4033
> sherrie.kubis_at_swfwmd.state.fl.us
>
>
> IMPORTANT NOTICE
> E-mails made or received in conjunction with the official business of the District are public records. All e-mails sent to and from this address are automatically archived. For more information regarding the State of Florida public records laws, please visit www.myflorida.com.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 11 2016 - 20:58:07 CEST