OraFAQ Forum: Backup & Recovery » backup policy help needed

Home » RDBMS Server » Backup & Recovery » backup policy help needed

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

backup policy help needed [message #151984]

Tue, 20 December 2005 05:55

msuluhan
Messages: 4
Registered: October 2005

Junior Member

Hi

I am trying to plan a backup policy for customer's 18TB Oracle instance.

The backup device is EML 245E (6 LTO3 drives and 245 slots). The device is connected to the SAN fabric. Oracle instance running on EVA 8000 hw. I will use HP Dataprotector software.

My customer wants cost effective, 3 months protected backup policy and also they wants to need minute by minute recovery guarantee.

Any recommendation would be appreciated.

Regards
Murat

Report message to a moderator

Re: backup policy help needed [message #151994 is a reply to message #151984]

Tue, 20 December 2005 07:09

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Look into RMAN.
The last time we bench-marked, we were able to restore and recover within a minute.
RMAN is free (along with oracle distribution).
RMAN in 9i can write only to disk ( There are numerous Improvement / features request we have placed to Oracle to facilitate RMAN media manager API free of cost. I do not know its current status in 10g).
You want to backup to tape directly (using RMAN) you need some MML API (from your vendor) which is usually pricey.
I have not worked with HPdataprotector.
Does it support RMAN?

Report message to a moderator

Re: backup policy help needed [message #152013 is a reply to message #151984]

Tue, 20 December 2005 09:01

msuluhan
Messages: 4
Registered: October 2005

Junior Member

Hi Mahesh

I will use RMAN and I used RMAN lots of time (since 2001).

DataProtector uses RMAN like Veritas NetBackup, Tivoli and like any other 3rd party Oracle online backup tools.
http://h18006.www1.hp.com/products/quickspecs/11671_div/11671_div.html

My concern is how can I decrease the number of tape cartridges depends on the recovery time. I'm in pursuit of a solution that'll merge number of cartridges and recovery time in a good manner

regards
Murat

Report message to a moderator

Re: backup policy help needed [message #153400 is a reply to message #151984]

Mon, 02 January 2006 02:04

waseem_aijaz
Messages: 16
Registered: December 2005
Location: Kingdom of Saudi Arabia

Junior Member

Hai,

Your database size is big. As guided by others, use RMAN. Don't directly backup on the tape. Take backup first to the Hard drive. from Hard drive copy to tape. What I experienced is , "Backing to the tape is very slow". Ofcourse others can correct me if I am wrong.

Report message to a moderator

Re: backup policy help needed [message #153437 is a reply to message #153400]

Mon, 02 January 2006 06:09

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> What I experienced is , "Backing to the tape is very slow
Depends on your configuration.
In your case Is it slower than the (time taken to backup to disk + backup disk to tape)?

Report message to a moderator

Re: backup policy help needed [message #153440 is a reply to message #151984]

Mon, 02 January 2006 06:34

waseem_aijaz
Messages: 16
Registered: December 2005
Location: Kingdom of Saudi Arabia

Junior Member

Hai,

Sorry my statement was not clear. The hard disk should be on a computer box( say X) other than production box. Later from X we can backup to tape according to flexible schedule.

Report message to a moderator

Previous Topic:	Cannot connect to Oracle Database
Next Topic:	Backup Scripts

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 15:25:49 CST 2024