Who is responsible? [message #337724] |
Thu, 31 July 2008 19:58 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
florida
Messages: 82 Registered: April 2006
|
Member |
|
|
I build alot of Web applications working with Oracle 9i.
Recently I lost some information in one of my tables and asked the DBA to recover it.
The DBA advised I was responsible for backing up my Database tables and for recovering my data from my own backup. I always thought the DBA was responsible for backing up and recovering any data I needed from the database. I dont even know the commands or how to recover data.
Please advise who should be doing the backup and recovery of data?
|
|
|
|
|
|
Re: Who is responsible? [message #337740 is a reply to message #337727] |
Fri, 01 August 2008 00:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sunil_v_mishra
Messages: 506 Registered: March 2005
|
Senior Member |
|
|
DBA is surely responsible for backing up your data and restoring it back if it is a production environment.
Unless and until developer don't have full access to manipulates that table In production environment developer can't drop, in good organization developer don't have drop table privs on production table of its own schema which he/she made during development[/B]
As you are working with 9i, DBA can only do incomplete recovery of your dropped table
In Development environment developer is responsible for droping his/her table. DBA can only restore it from its logical backup if present or DBA can give export dmp from production to developer or on his behalf DBA can import it in development.
|
|
|
|
|
|
Re: Who is responsible? [message #337998 is a reply to message #337996] |
Sat, 02 August 2008 02:54 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
But generally speaking it means against hardware, OS, or Oracle failure not customer one.
Oncen again it all depends on the contract between IT/DBA and customers and what exactly wants the custumer. In this case, I bet it is not just putting back the database at the point when the data was deleted.
Regards
Michel
|
|
|