Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

About Database Restore in Oracle 10g

1 reply [Last post]
Sun, 2008-05-04 05:05
niles luo
User offline. Last seen 13 years 25 weeks ago. Offline
Joined: 25 Nov 2005
Posts: 46
Groups: None
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
Top

Replies

Sun, 2008-05-04 09:31
#1
DANG CORP
User offline. Last seen 9 years 7 weeks ago. Offline
Joined: 3 Oct 2004
Posts: 71
Groups: None
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
Top