A couple of days ago I tried to register a standby database on ODA with a newer relase of ODA (in my case 18.8) and Grid Infrastructure. I followed the procedure of the Dbvisit Standby documentation.
In there, it is described that you need to start the database on the standby environment as "read only".
Afterwards, you should be able to register the database in the Grid Infrastructure using odacli.
The procedure is described at this manual in detail and should work with Dbvisit Standby Version 8 and 9.
Unfortunately, if you run the ODACLI to register the database, it fails.
odacli register-database -c OLTP -s odb6 -t SI -sn <mydb.mydbdomain.com> -p <somepassword>
The job at the ODA is started, but it errors out:
Job details
----------------------------------------------------------------
ID: 432c4c54-0d2f-XXXX-XXXX-aa15f27ea3ab
Description: Database service registration with db service name: <mydb.mydbdomain.com>
Status: Failure
Created: May 5, 2020 3:40:06 PM CEST
Message: DCS-10001:Internal error encountered: Failed to archive log all
Session altered.
alter system archive log current
*
ERROR at line 1:
ORA-01109: database not open
This also means, that you see the "failed" configurations in odacli list-databases.
I have created a Service Request with Dbvisit to check the manual/the process of registering the database on ODA. At the meantime, the only solution is to open the database "read/write" to register it at the ODA.
To open the standby read/write it's necessary to "switchover" the primary to the standby you want to register and run odacli register-database on the -now- primary. Afterwards you can switch the roles of the databases again, so your original standby is a standby again at the end.
For your application that means, that it is necessary to have a small maintenance window where the end users can't work.
I will edit this blog post as soon as I do have more information, so come back regularly if you are interested in any news.
Thank you for publishing this article, Joerg. It was very helpful with a problem involving a DB11.2.0.4 primary on an old ODA X5 that we have to migrate to a newer X7. An awful job, because of all the incompatibilities between the products. What I want to say is that we did find that we could run odacli register-database without having to do a switchover. It did, eventually, run against the standby open read only. This was using ODA 19.10, perhaps that is why it worked.
ReplyDelete