How to register database for ODA via odacli

[myvon]

Hello All,
I am hoping to get good advice from you guys .
I have multiple non-registered ODA databases currently running on ODA environment, and they have been registered in the clusterware using service control (srvctl). However, they have not been registered in ODA repository.
As databases already been created, running and registered on clusterware. My questions are
1. Before I execute "odacli register-database" Do I need to run the command  "odacli create-storage" first for every database I register?
2. I understand that the command of "odacli register-database"  will perform "register DB with clusterware" , but databases have already been registered on clusterware. So Do you think the command may fail? Can the command be re-run or does it corrupt the oda metadata repository? (I heard you may need to cleanup the Apache Derby database manually?)
3. Do you have any better suggestions to register these non-oda database back to ODA?

Your prompt reply would be appreciated.
 
Thanks

 

[ErmanArslansOracleBlog]

Hi,

As far as I can see, odacli register-database doesn't support RAC databases.
So if it is a RAC database, then you have to follow the steps documented in
whitepaper named "Oracle Database Appliance: Implementing MAA Disaster Recovery Solutions Using Oracle Data Guard"

https://www.oracle.com/technetwork/database/database-appliance/learnmore/oda-dg-maa-wp-r1-19-5869757.pdf

-Create an instance only database with odacli create-database -io
-Restore the database from backup or clone the database

And I don't think you can successfully register a database in ODA without using creating db storage. there is a important relationship between these two actions.. See the following MOS note ->

Can't Register CLONE Database On ODA X7-2M (Doc ID 2553315.1)

It even expects the name used in creating db storage to be the same as the one used with registering the database. So those are tightly coupled..

However; you can ask this to Oracle Support, as well.. Because currently I don't have a TEST environment to test/or find an alternative method for you...

[myvon]

Thanks for your replied. All these existing Databases are non-RAC and register to grid Infrastructure (standalone) using srvctl on ODA 19.8.
I may try with odacli update-register command first (and create storage) ? If I follow the instruction from "Implementing MAA Disaster Recovery Solutions Using Oracle Data Guard" doc, I need to restore/duplicate for all of them to fix the oda metadata not in sync issue.

[ErmanArslansOracleBlog]

creating a dbstorage is necessary..
registering the database will probably fail without a storage.. As I mentioned in my earlier post;

And I don't think you can successfully register a database in ODA without using creating db storage. there is a important relationship between these two actions.. See the following MOS note ->

Can't Register CLONE Database On ODA X7-2M (Doc ID 2553315.1)

It even expects the name used in creating db storage to be the same as the one used with registering the database. So those are tightly coupled..

You may try creating a db storage according to the current ASM disgkrups that you use and then  registering your db afterwards..

***When I check the manual, I get the following info from there, and this makes me think that it can be done even in your case.. But it needs to be tested, and I don't have a TEST environment for testing this.. So you should plan your tests on your own and take the risk...

*For creating the dbstorage: When you select ASM, the command only creates the supporting directory structure for storing non-database files.
*For registering: The database being registered must use Oracle Managed Files and the file location must match the DATA Location, REDO Location and RECO Location of the odacli describe-dbstorage command.
The register-database command validates the datafile and log file locations and moves the controlfile and spfile to the correct locations

[myvon]

Thanks for your help. Much appreciated.