Were the steps mentioned in
Doc ID - 728374.1 followed ?
On Apr 11, 2016, at 2:58 PM, Sherrie Kubis <Sherrie.Kubis@xxxxxxxxxxxxxxxxxx>--
wrote:
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@xxxxxxxxxxxxxxxxxx
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@xxxxxxxxx] ;
Sent: Monday, April 11, 2016 1:49 PM
To: Sherrie Kubis <Sherrie.Kubis@xxxxxxxxxxxxxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxx
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.
--
//www.freelists.org/webpage/oracle-l