Home » RDBMS Server » Backup & Recovery » Backup strategy (oracle 10g,linux)
Backup strategy [message #325269] Thu, 05 June 2008 08:29 Go to next message
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 Go to previous messageGo to next message
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 #325275 is a reply to message #325269] Thu, 05 June 2008 08:46 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>HOW WOULD YOU APPLY BACKUP STRATEGY ?...
as documented
Re: Backup strategy [message #325276 is a reply to message #325274] Thu, 05 June 2008 08:53 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #325294 is a reply to message #325287] Thu, 05 June 2008 10:15 Go to previous messageGo to next message
hemss007
Messages: 21
Registered: June 2008
Location: LONDON
Junior Member
oracle version ENTERPRISE edition
Re: Backup strategy [message #325295 is a reply to message #325269] Thu, 05 June 2008 10:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>oracle version ENTERPRISE edition
You don't know what, you don't know!

select * from v$version
-- use CUT & PASTE to post results back here
Re: Backup strategy [message #325298 is a reply to message #325295] Thu, 05 June 2008 10:28 Go to previous messageGo to next message
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 Go to previous message
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!
Previous Topic: ORA-19504: failed to create file "+MY_DG2"
Next Topic: UserManaged HOT Backup
Goto Forum:
  


Current Time: Fri Nov 29 09:19:31 CST 2024