| balaji |
Posted: Jul 08, 2008 04:48:03 AM |
Total Post: 148
Joined: May, 2008
|
| How to determine datafile is corrupted or missing and how to recover the missing datafile using RMAN?? |
|
|
Avnish |
| Posted: Jul 09, 2008 12:25:19 AM | |
|
Total Post: 154
Joined: Dec, 2007
|
Hi,
you got errors wherever your database's datafile currupted or missing. Even your database might be not open.i.e. you will get en specific ORA error whereever your datafile is currupted or missed. if you have to verify that either your data file is currupt or not you have to use DBV (DB VERIFY) Utility.
Thanks & Regards
Avnish Yadav
|
|
|
|
|
Avnish |
| Posted: Jul 09, 2008 12:27:09 AM | |
|
Total Post: 154
Joined: Dec, 2007
|
Hi
For Second Question Follow this link : this will guide you RMAN Recovery for a datafile
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmrecov006.htm
Thanks & Regards
Avnish Yadav
|
|
|
|
|
Avnish |
| Posted: Jul 09, 2008 12:28:50 AM | |
|
Total Post: 154
Joined: Dec, 2007
|
Hi
For the DBV Utility follow this link : This will Guide you how to use DBV
http://www.oracleutilities.com/OSUtil/dbv.html
Thanks & Regards
Avnish Yadav
|
|
|
|
|
balaji |
| Posted: Jul 09, 2008 02:11:01 AM | |
|
Total Post: 148
Joined: May, 2008
|
Thanks Avnish Yadav for sending me some important documents about datafile .I havnt read it fully .will review it and get back to you if i have any clarification on that docu.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |