Home » RDBMS Server » Backup & Recovery » Who is responsible?
Who is responsible? [message #337724] Thu, 31 July 2008 19:58 Go to next message
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 #337725 is a reply to message #337724] Thu, 31 July 2008 20:01 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>Please advise who should be doing the backup and recovery of data?
What does your contract say about backups?
Re: Who is responsible? [message #337726 is a reply to message #337725] Thu, 31 July 2008 20:12 Go to previous messageGo to next message
florida
Messages: 82
Registered: April 2006
Member
I dont know of any contract. I will ask and find out.
Re: Who is responsible? [message #337727 is a reply to message #337724] Thu, 31 July 2008 20:40 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/m/166725/74940/#msg_166725

What happened with daily exports as in the thread above?
Re: Who is responsible? [message #337740 is a reply to message #337727] Fri, 01 August 2008 00:15 Go to previous messageGo to next message
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 #337760 is a reply to message #337740] Fri, 01 August 2008 01:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is just YOUR opinion.

Regards
Michel
Re: Who is responsible? [message #337906 is a reply to message #337725] Fri, 01 August 2008 09:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Paraphrasing Anacedent,
It depends on contract or SLA.
Nothing is hard rule, be it production or dev environment.

Re: Who is responsible? [message #337996 is a reply to message #337906] Sat, 02 August 2008 02:34 Go to previous messageGo to next message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

Yes,

But generally, Backup and restore/recovery of database comes under the responsibility of Database administrator, and not the developer.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/dba.htm#i1006205

Regards,
Dipali..
Re: Who is responsible? [message #337998 is a reply to message #337996] Sat, 02 August 2008 02:54 Go to previous message
Michel Cadot
Messages: 64103
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
Previous Topic: restore issue
Next Topic: smon and instance recovery
Goto Forum:
  


Current Time: Sun Dec 04 12:42:12 CST 2016

Total time taken to generate the page: 0.13036 seconds