1

Topic: DGMRL

Hello friends! Is primary and standby, all worked normally, but one fine day primary fell and switched with the help switchover on standby, later the server lifted and when we want to switch reversely produces errors
show configuration
Configuration - mb_dg
Protection Mode: MaxAvailability
Databases:
mbs - Primary database
Error: ORA-16810: multiple errors or warnings detected for the database
mb - Physical standby database
Warning: ORA-16826: apply service state is inconsistent with the DelayMins property
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
DGMGRL> show database mb
Database - mb
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: (unknown)
Apply Lag: 189 days 16 hours 56 minutes 18 seconds (computed 1 second ago)
Apply Rate: (unknown)
Real Time Query: OFF
Instance (s):
mb
Database Warning (s):
ORA-16826: apply service state is inconsistent with the DelayMins property
Database Status:
WARNING
DGMGRL> show database mbs
Database - mbs
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance (s):
mbs
Database Error (s):
ORA-16783: cannot resolve gap for database mb
Database Warning (s):
ORA-16629: database reports a different protection level from the protection mode
Database Status:
ERROR
mbs
SQL> select database_role, switchover_status from v$database;
DATABASE_ROLE SWITCHOVER_STATUS
---------------- --------------------
PRIMARY UNRESOLVABLE GAP
mb
SQL> select database_role, switchover_status from v$database;
DATABASE_ROLE SWITCHOVER_STATUS
---------------- --------------------
PHYSICAL STANDBY NOT ALLOWED
Pozh help!

2

Re: DGMRL

denaro;
Look where the log which he waits got to...
If in  left - recover.
It to begin with.

3

Re: DGMRL

Q.Tarantino;
You mean ?

4

Re: DGMRL

denaro wrote:

Q.Tarantino;
You mean ?

Yes. He writes about GAP...

5

Re: DGMRL

Q.Tarantino;
With  everything is all right

6

Re: DGMRL

denaro wrote:

Q.Tarantino;
With  everything is all right

$ oerr ORA 16783
16783, 00000, "cannot resolve gap for database %s"
//*Cause: The primary database could not resolve a gap request from the
//specified standby database (s).
//*Action: Copy the missing archived redo log files from either backups or
//from another database in the configuration that has the files to
//the standby database (s) missing the files.

7

Re: DGMRL

denaro wrote:

Q.Tarantino;
With  everything is all right

And   it confirms? smile

8

Re: DGMRL

denaro wrote:

Q.Tarantino;
With  everything is all right

Well, well...

denaro wrote:

DGMGRL> show database mb
Database - mb
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: (unknown)
Apply Lag: 189 days 16 hours 56 minutes 18 seconds (computed 1 second ago)
Apply Rate: (unknown)
Real Time Query: OFF
Instance (s):
mb

9

Re: DGMRL

andrey_anonymous wrote:

Well, well...

It is easier nonsense not to suffer and   smile

10

Re: DGMRL

D wrote:

it is passed...
It is such as you easier 
Do not advertize the  once again
In the modern world  are synchronized incremental

The person sees for the first time DG... You think about actualization  incremental  it heard?
And how you think, whether for a floor of year strongly big difference, to pour or inc?
Well if, of course, there it is a lot of contemporary records...
And so, you solved once again ? You time a nose  - will be now in each butt a plug?

11

Re: DGMRL

You would stop the mutual sword-play
You better as could not explain the HARDWARE a smog:
In "Protection Mode: MaxAvailability" switched "with the help switchover on standby" when "primary fell" during one fine instant.

12

Re: DGMRL

dba123 wrote:

you would Stop the mutual sword-play

I that that, it  permanently something want...

13

Re: DGMRL

dba123 wrote:

you better as could not explain the HARDWARE a smog:
In "Protection Mode: MaxAvailability" switched "with the help switchover on standby" when "primary fell" during one fine instant.

I would assume that was nevertheless failover (without  as  that?), but here strange that were  in the status .
Reasonable explanation -  did not die, simply there were certain problems, made a switch...
Then disconnected.

14

Re: DGMRL

D wrote:

it is passed...
Yes you , are simple  all time))

On business is what to tell? Where ?  here only you.

15

Re: DGMRL

D wrote:

on business here there is nothing to speak - or to learn  from the very beginning, or to invite those who switched \adjusted \lifted or is able to do it
Instead of to pose as a hero -  I at a forum I ask also all I will make

Not, well so that yes!
It is possible to send everyone at a forum to learn a floor-mat a part smile
And then only one topic - with  on the documentation will be necessary smile

16

Re: DGMRL

Thanks all for the help! Reading correspondence decided to be engaged most, will be more favor!

17

Re: DGMRL

denaro wrote:

Thanks all for the help! Reading correspondence decided to be engaged most, will be more favor!

The wise decision!

18

Re: DGMRL

D wrote:

For example spanned pens broad gulls

Aha. For a half-year broad gulls - here simply took and spanned, is direct drags-n-dropom under a rock'n'roll smile

19

Re: DGMRL

andrey_anonymous wrote:

it is passed...
Aha. For a half-year broad gulls - here simply took and spanned, is direct drags-n-dropom under a rock'n'roll smile

Considering that DBA in office is not present, it is possible to assume that basis with low activity, broad gulls enough rarely  can there smile