RE: Tivoli Storage Manager Implementation

Brian,

>>My co-dba thinks the systems people will
>>take care of it all but I have my doubts.
Your doubts are correct!

• SA will/should install and set up the (master) Tivoli-TSM server...the scheduler and metadata and I guess main tape lib software.
• SA will/should install ONLY the Tivoli-TDPO on each Oracle server.
• DBA will/should configure Tivoli-TDPO files on each Oracle server (with some information from SA about the Tivoli-TSM server)
• DBA will/should configure Oracle-RMAN (links) to write to tape (well documented and the same for all MML).

>>I see there is a need for RMAN scripts and
Oh yes...long ago I got the rude awakening that all MML Agent For Oracle do NO scripting unless they have a GUI and/or *basic* provided set of RMAN scripts. But this is minimal and you will have needs to write or modify these scripts Also, RESTORE and RECOVER can not be scripted unless it is "all or nothing". How can I say this, because one can not script (RESTORE and RECOVER) what they do not know has been lost. ;o)

>>of course some testing to prove it really does backup & restore.
Yes , test ,test, test you backups!
"Backup is easy....it Recovery (Restore) that is hard"

good luck...Tivoli is hard, but good.

Chris Marquez
Oracle DBA

-----Original Message-----
From: oracle-l-bounce_at_freelists.org on behalf of BP Sent: Tue 10/11/2005 9:25 PM
To: Oracle-L
Subject: Re: Tivoli Storage Manager Implementation  

Hi Chris,

Thanks. I found some manuals on IBM's site that are bit dated (2003) for 8i/9i. We're using 10g so I'm going to ask the IBM rep if they have it written yet. My co-dba thinks the systems people will take care of it all but I have my doubts. I see there is a need for RMAN scripts and of course some testing to prove it really does backup & restore.

Brian

On 10/11/05, Marquez, Chris <cmarquez_at_collegeboard.org> wrote:
> Brian,
>
> I don't know if there is a archive search for this list but this exact
> subject; "Using Tivoli TSM-TDPO", just came up about a week ago.
> I will look for my old post.
>
> Short answer...
> Tivoli TSM-TDPO;
> Works well, hard (rather "painful") to configure, docs not good.
>
> Chris Marquez
> Oracle DBA
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of BP
> Sent: Tuesday, October 11, 2005 2:15 PM
> To: Oracle-L
> Subject: Tivoli Storage Manager Implementation
>
> [Oracle 10g Enterprise Edition for AIX 5L]
>
> Hi Everyone,
>
> Our company is considering a purchase of Tivoli Storage Manager for all
> its enterprise backup needs. Currently our dev and testing db's are
> coming online. Production db's are not to online for another six months
> - and are not going to run 24/7. So it looks like it will be
> 'consistent backups' via Tivoli.
>
> It all sounds so rosy from the vendors presentations, but as a neophyte
> DBA is there anything I should aware of or brush up on? I originally
> thought 'Great no pager!' but I guess RMAN or some aspect of this setup
> could stop working one night at 3am. Your thoughts?
>
> Best Regards,
> Brian Peasey
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l