Current test database is 18c SE2, with Oracle Restart 18c. ON oracle Linux 6.
Now I have a need to restore it from the backup of the prod db, which is still at 12.1.0.2 SE2. I have a weekly scheduled cron job to perform an rman 'duplicate database', but since I am taking the database back a level, am not sure what needs to be done to the registration in Oracle Restart. I know that there is a property for ORACLE_HOME that will need to be changed, but can't seem to find the docs on which srvctl or crsctl command to do that. Also don't know if anything else will be impacted.
Here is my overall plan:
- shut down the database
- modify its entry in /etc/oratab, specifying the 12.1 home
- run the 'refresh' script. This will:
3a) determine the scn of the latest rman backup of the prod db
3b) copy the backup files from the prod server
3c) use asmcmd to delete the data files associated with the test db
3d) execute the rman 'duplicate database'
- execute ??? to tell oracle restart that the database is now 12.1, running from the 12.1 home
Step 4 is where I am uncertain