1. do a full cold backup (if you have the power to log everyone off? OR i usually set a daemon to run at 11pm.
2. use rman to do a full object backup. (not just the tables that you see)
3. use rman to restore it back too.
3.5, make sure the privuser and pubuser is granted right permission to these newly restore objects etc....
4. if you are not sure of what rman is, then search for it on yahoo... (you were thinking i was about to say google it right?) well me not a big fan of google.
5. another easier way is to compare ur object listing and see which is missing and then sync them etc...
Member for
21 years 1 monthRE: About Database Restore in Oracle 10g
HI mate,
you are missing a few objects the p3e ora needs.
suggestions
============
1. do a full cold backup (if you have the power to log everyone off? OR i usually set a daemon to run at 11pm.
2. use rman to do a full object backup. (not just the tables that you see)
3. use rman to restore it back too.
3.5, make sure the privuser and pubuser is granted right permission to these newly restore objects etc....
4. if you are not sure of what rman is, then search for it on yahoo... (you were thinking i was about to say google it right?) well me not a big fan of google.
5. another easier way is to compare ur object listing and see which is missing and then sync them etc...
Vu Dang
dangcorp.com