EBS database refresh

[satish]

Hi Erman,

Just 7 days back we have refreshed test from prod but now we have an emergency request to refresh the test instance.We didnt apply any patches or any changes to prod since the last refresh but we have applied psu patch to test database 3 days back.

In this case,can we just refresh the data or do we need to clone the oracle home also?We are updated by management to just clone the data.

what if we miss the oracle home clone and just go with data refresh?

Please suggest

Thank you

[ErmanArslansOracleBlog]

You can clone the database (without Oracle Home), but afterwards you need to execute the database side of the PSU patch into that cloned database.
Read the Readme of the PSU patch, determine the db side operations instructed in that Readme(data load, sql executions and etc..), and then execute those operations on the newly cloned database.

[ErmanArslansOracleBlog]

"what if we miss the oracle home clone and just go with data refresh?" -> you may end up with INVALID items listed in the dba_registry table..
For instance Your JVM(inside the database) may not work.. Your java classes(inside db) may not work.. You may encounter other errors as well.
I think you get the idea.