Home » Server Options » Data Guard » how to make standy db consist wth primary db (merged)
how to make standy db consist wth primary db (merged) [message #382570] Fri, 23 January 2009 01:04 Go to next message
kashi24
Messages: 10
Registered: January 2009
Location: pakistan
Junior Member
on primary db
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/backup
Oldest online log sequence 1
Next log sequence to archive 1
Current log sequence 2


an on standy

rchive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/backup
Oldest online log sequence 2
Next log sequence to archive 0
Current log sequence 4


how to resolve this problem

Re: how to make standy db consist wth primary db (merged) [message #382573 is a reply to message #382570] Fri, 23 January 2009 01:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Reinstantiate the standby.

Regards
Michel
Re: how to make standy db consist wth primary db (merged) [message #382591 is a reply to message #382573] Fri, 23 January 2009 02:51 Go to previous messageGo to next message
kashi24
Messages: 10
Registered: January 2009
Location: pakistan
Junior Member
how can we Reinstantiate the standby.

Re: how to make standy db consist wth primary db (merged) [message #382593 is a reply to message #382591] Fri, 23 January 2009 02:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Drop and recreate it.

Regards
Michel
Re: how to make standy db consist wth primary db (merged) [message #382594 is a reply to message #382593] Fri, 23 January 2009 03:00 Go to previous messageGo to next message
kashi24
Messages: 10
Registered: January 2009
Location: pakistan
Junior Member
is thr any other possible wayy?//
Re: how to make standy db consist wth primary db (merged) [message #382598 is a reply to message #382594] Fri, 23 January 2009 03:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Noone I'm aware of.

Regards
Michel
Re: how to make standy db consist wth primary db (merged) [message #382662 is a reply to message #382570] Fri, 23 January 2009 09:24 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>how to resolve this problem
How can the standby DB have an SCN higher than primary?

>Oldest online log sequence 2
>Next log sequence to archive 0
>Current log sequence 4

What happened to SCN 3?

Previous Topic: Physical Standby from RAC (Primary) to non-RAC(Standby)
Next Topic: Log apply
Goto Forum:
  


Current Time: Thu Mar 28 13:41:33 CDT 2024