About Database Restore in Oracle 10g
In the Open Standard
Niles LuoMember for 20 years 10 months
- Created
- 1
- 5
0
Hi:
I have used exp command backup the PMDB database. The database is oracle 10g. I have used imp command to restore the dmp file to database with any error or warnning. But when login the system with PM, the system indicate that: table or view do not exist. So I can not restore the the database.
Any help is appreciative.
Regards
niles
I have used exp command backup the PMDB database. The database is oracle 10g. I have used imp command to restore the dmp file to database with any error or warnning. But when login the system with PM, the system indicate that: table or view do not exist. So I can not restore the the database.
Any help is appreciative.
Regards
niles
1 reply
Oldest first- 0Dang Corp ·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
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?