Hi,

Did you use srvctl add database, srvctl add instance (2 times with different instance names or target nodes)?

What is the output of ssrvctl config database -d <dbunique name>?

Br,

krisz

That is correct as 19.13 to 19.19 is patching and not upgrade. You must use odacli update-dbhome instead of odacli upgrade-database.

Br,

krisz

Hi,

So how are the unregistered databases preserved during DPR if they've been removed from clusterware?

The files that belong to the database won't be removed from ASM/ACFS.
If the dbhome from where the db is running resides on ACFS that will be also preserved.
In that case, you just need to add the db resource back to the clusterware (srvctl add database)

Regarding Option 1, all of those prerequisites have been met, except we can't check against dbstorage because we don't know what will happen if it finds the directories and files are already there so we haven't tried to create the dbstorage yet.

I have to disagree. Based on the error message dbstorage doesn't exist, so one prerequisite is not met.
You can't create the dbstorgae when the db exists.
The only option is to take a remote backup, remove all db files from ASM, create dbstorage using odacli create-dbstorage, restore the db from backup.
Data files, undo tablespaces, temp tablespace(s) go onto +DATA
FRA, controlfile, redo must go to +RECO

option 3 - manual metadata modification

Hacking the metadata is strongly discouraged

Br,

krisz

Hi,

Controlfile and online logs and FRA are expected under +RECO.

Br,

krisz

Hi,

1. Certain prerequisites must be met to register a database on ODA.

https://docs.oracle.com/en/engineered-systems/oracle-database-appliance/19.29/odale/oracle-database-appliance-command-line-interface2.html#GUID-D96979EE-C905-4309-AE90-104FE38508B4

Seems dbstorage had not been created for this db before the db was created or restored from backup.

This can be only fixed if you take a backup of the db to a remote location and delete it and restore it using the correct procedure.

https://docs.oracle.com/en/engineered-systems/oracle-database-appliance/19.29/odale/managing-databases-oda.html#GUID-3EF1632D-9BB9-4995-9708-8E4C76DB2C62

2. The other option you could think of is to remove the DB service from the clusterware (srvctl remove database) temporarily before DPR. In that case, DPR won't complain about it as it won't know about it.
Please note, in this case you must recreate the dbhome manually including the tnsnames.ora/sqlnet.ora, spfile, passwordfile, … and register the database into clusterware (srvctl add database)

I recommend to go for the 1st option to make your database ODA compliant. Once done, all lifecycle operations could be done using odacli including backup/restore, modify-database, patching, …

Br,

krisz