| simoh |
Posted: May 15, 2008 06:51:02 PM |
Total Post: 4
Joined: May, 2008
|
Hi,
i am new into this..so please help
here is the situation:
we have a 9i RAC env (production we dont have a dev env.). that holds alot of applications...today morning, one of the application with in 15 min lost a portion of the data (i dont really know how)...the database was running fine and no errors where generated....all other applications are running fine with no problem and nothing was lost(except for that one)...
i need to know how i can restore that portion...please note that i tried to use logmnr but i couldnt as to set the UTL_FILE_DIR parameter i need to bounce the database which is not acceptable(as it will affect the other application)...
so is there any other way???
i have a backup which i am tried to validate....if i need to use the recovery is there any suggested strategies...
please help
thank u in advance |
|
|
 Gitesh |
| Posted: May 15, 2008 11:23:35 PM |  |
|
Total Post: 322
Joined: May, 2005
|
For log minor you should use another database(version and platform must be same). Transfer your archive log there and make dictionary from production and transfer it to test database server. You can configure log minor in test database server.
|
|
|
|
|
| Gitesh |
| Posted: May 15, 2008 11:36:31 PM | |
|
Total Post: 322
Joined: May, 2005
|
If data lost in only one segment and if you have export then import data in a segment.if you don't have export then restore backup in the development server and recover it up to certain time, take export of same table and import into production.
|
|
|
|
|
| GOPU |
| Posted: May 15, 2008 11:37:22 PM | |
|
Total Post: 340
Joined: Apr, 2008
|
you specified that you have backup.But what type of backup do you have ?
|
|
|
|
|
| simoh |
| Posted: May 16, 2008 09:47:12 AM | |
|
Total Post: 4
Joined: May, 2008
|
i have an rman backup located at a disk....
i guess the only choice i have is to build a temp instance and recover the that tablespace on that temp db...then i'll insert the missing data into the production db....
if you have any refrence to do this approach, please post it....
or if you have any idea i'd be glad to see it..
thank you
|
|
|
|
|
| Gitesh |
| Posted: May 16, 2008 11:34:08 PM | |
|
Total Post: 322
Joined: May, 2005
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
