Backup strategy [message #325269] |
Thu, 05 June 2008 08:29 |
hemss007
Messages: 21 Registered: June 2008 Location: LONDON
|
Junior Member |
|
|
HI everybody,
yester i was face one interview
in that interview the quiestion was asked
HOW WOULD YOU APPLY BACKUP STRATEGY ?...
what would be expected answer.
can any body help me ?
|
|
|
Re: Backup strategy [message #325274 is a reply to message #325269] |
Thu, 05 June 2008 08:45 |
Dipali Vithalani
Messages: 278 Registered: March 2007 Location: India
|
Senior Member |
|
|
Depends on various matters
Like,
> How crucial the data is for the company, how much availability the company require, How much it can afford, Hardware availability etc..
Regards..
|
|
|
|
Re: Backup strategy [message #325276 is a reply to message #325274] |
Thu, 05 June 2008 08:53 |
hemss007
Messages: 21 Registered: June 2008 Location: LONDON
|
Junior Member |
|
|
data is cruitial like credit card compony,
compony want High avaibility 24X7 and it ready to spend best quality hardware on SAN.
|
|
|
Re: Backup strategy [message #325287 is a reply to message #325269] |
Thu, 05 June 2008 09:46 |
MattSummerbell
Messages: 8 Registered: June 2008 Location: London
|
Junior Member |
|
|
what version of oracle?
Enterprise edition- datagaurd/active datagaurd no loss of data servers in speerate locations.
standard edition - use code to replicate and send small archive logs - probable loss 20 minutes or so.
|
|
|
|
|
Re: Backup strategy [message #325298 is a reply to message #325295] |
Thu, 05 June 2008 10:28 |
hemss007
Messages: 21 Registered: June 2008 Location: LONDON
|
Junior Member |
|
|
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
|
|
|
Re: Backup strategy [message #325483 is a reply to message #325269] |
Fri, 06 June 2008 06:00 |
asangapradeep
Messages: 128 Registered: October 2005 Location: UK
|
Senior Member |
|
|
Hi
There are no ready made answers for this. It depends on requirements of the client or company you work for. There are articles on MAA on OTN which will give you and idea of what the company expect when they say MAA.
As for strategy you have to come up with something on your own using your knowledge of various backup features provided by oracle and you experience.
this might help
Good luck!
|
|
|