Issue and Cause:
---------------------------
After installing Oracle Service Registry (OSR) on SOA Suite; I found that it created a tablespace (if not renamed, it picks uddiuser by default) and put the data file under $ORACLE_HOME/dbs which I was not aware until I try to restore one of my backup taken at a later stage i.e after installing AIA on OSR. As the location for other SOA database datafiles was different; I never thought of taking backup of $ORACLE_HOME/dbs which made this data file out of sync and made my database backups INVALID / useless.
Fix:
----
As soon as OSR is installed, rename the datafile which is under $ORACLE_HOME/dbs and move it with other datafiles. This will make sure that this datafile is getting backed up every time with other datafile and backup is VALID and can be restored if needed.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment