I am Upgrading Database Schema that i have created using RCU as part of the SOA Suit upgrade Activityl.
.
I have upgraded weblogic and SOA Suit but now I have to upgrade the Database sachemas that created through RCU. But I need to take database backup before that and if fails I need to revert it back also.
I am planning to take full backup using below command so while reverting back it should not miss any user and schema.
exp username/password full =y file ="/oracle/path"
Oracle docs are confusing , sometime saying do using this and sometime saying do it using some other approaches.
Please can someone let me know what is best way to take the backup of database that includes all the sachems and users and how to revert it back if sachems up gradation is failed
Thanks in advance for you time and help.