Always maintain a backup of your database and test to be sure your database can be restored from backup files.
If your Oracle database contains user-schema geodatabases, be sure to back up the entire database, not just the user's schema, as there are tables in the master sde geodatabase upon which the user-schema geodatabase depends.
For options and instructions for creating backups, see the Oracle documentation for the Oracle release you are using.