Physical StandBy on a Standard Edition 11.2 [message #610553] |
Fri, 21 March 2014 03:41 |
|
Elleme
Messages: 2 Registered: March 2014 Location: Dinan (France)
|
Junior Member |
|
|
See below in French
Hello,
I've got a standby database on a Standard Edition with a Manual Recovery of the archivelogs from my primary.
It seems to be all right but I'm not sure that my standby is Ok.
In fact, when my standby is mounted I can see that the last sequence number is the same that the last one of my primary. But when I open it in read-only mode I don't find the last data that I've generated in my primary.
For example, below are the data I've got in a table where I've modified some data in my primary :
SQL> select min(e8), max(e8) from cortexte.temoin;
MIN(E8) MAX(E8)
---------- ----------
1 500
And below the data in the same table of my standby after having played the archivelogs :
SQL> select min(e8), max(e8) from cortexte.temoin;
MIN(E8) MAX(E8)
---------- ----------
1 1500
I don't understand why my data aren't updated or accessible as soon as my archivelogs have been recovered.
Does anyone could explain me this ?
Thanks a lot
Laurent
Bonjour à tous,
J'ai une standby database (Standard Edition) sur laquelle je viens rejouer régulièrement les archivelogs de ma primary. Tout semble techniquement se passer correctement et le dernier numéro de séquence que je trouve sur ma standby à l'état Mounted est conforme au dernier numéro de séquence généré sur ma primary.
Ce que je ne comprends pas c'est la raison pour laquelle, lorsque je passe ma base à l'état Open (read-only), je ne retrouve pas dans une table témoin les dernières données que j'ai généré sur la primary.
Si quelqu'un a une explication, je serais preneur.
Merci d'avance,
Laurent
|
|
|
|
|
|
Re: Physical StandBy on a Standard Edition 11.2 [message #610600 is a reply to message #610575] |
Fri, 21 March 2014 12:13 |
|
Michel Cadot
Messages: 68694 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Please this forum is english stay on this language.
Note there are other languages at bottom of the main including a French one if you want to continue (just tell me and I will move the topic) but you will then have less answers which would be too bad for you.
Now, the SCN in both databases will not be the same ones. Once you open the standby database in read only mode scn is frozen when the scn of the primary database will still goes on but you will see with this statement that you have the same content in your table in both databases for the same scn.
The scn of your standby database depends if you apply the modification based on complete archived log or with option USING CURRENT LOGFILE. Have a look at alert.log file and/or query gv$dataguard_status as well as v$archived_log.applied to follow the apply, gv$archive_gap to know if some logs are missing...
(Note: I don't know if all these ones applies to standard edition, maybe John knows.)
|
|
|