About Database Restore in Oracle 10g

N
niles luo 👤 Member for 20 years 6 months
D
DANG CORP 👤 Member for 21 years 8 months

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

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts