Re: Questions on using RMAN to backup a RAC database with TSM
- From: "Peter Hitchman" <pjhoraclel@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 6 Mar 2008 10:03:44 +0000
Hi Krish,
Thanks for the advice, I have seen examples of channel settings for
different nodes, so I will check that out.
Regards
Pete
On Wed, Mar 5, 2008 at 5:40 PM, <krish.hariharan@xxxxxxxxxxxx> wrote:
> Peter
>
> I have dealt with RAC backups in all three configurations (with NetBackup
> which imposes the same constraint)
>
> 1. Dedicated node for all databases
>
> 2. Dedicated node for a given database
>
> 3. Free for all
>
>
>
> The crucial part of this is a way of knowing after the fact, where your
> backup took place or conversely be agnostic to it.
>
>
>
> a)
>
> With single node backup in a RAC configuration you have to ensure
>
> a) That node is capable of backing up all the databases
>
> b) Or if different databases get backed up from different nodes, then a
> document that captures that
>
> c) Prevent RMAN connection from failing over to a different node to
> execute the backup of a database via another instance
>
> d) The node of choice must have the capacity to execute all the data of
> a given database(s) consistent with your policy
>
>
>
> b)
>
> The same is true of NetBackup (which I am familiar with). You can set up
> multiple channels are configured to reference the nodes from which backup
> took place (alternate host restore mechanism) then RMAN will locate the
> backup piece from the correct channel to execute the recovery (channel fail
> down if you will). I have tested this and if memory serves me right I think
> this capability was available starting with 9.0.1
>
>
>
> Regards,
>
> -Krish
>
> Krish Hariharan
>
> President/Executive Architect, Quasar Database Technologies, LLC
>
> http://www.linkedin.com/in/quasardb
> ------------------------------
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Peter Hitchman
> *Sent:* Wednesday, March 05, 2008 4:39 AM
> *To:* oracle-l
> *Subject:* Questions on using RMAN to backup a RAC database with TSM
>
>
>
> Hi,
> I have a new 11G RAC set-up to play with!
>
> We use TSM to do our backups and RMAN. I know that TSM associates backups
> with the client node from which they came.
>
> So:
> a) Where is the best place to run rman from? One of the RAC nodes? Or a
> third-party "application" server.
>
> b) What sort of TSM issues would we face, if the machine we made the
> backups from failed, when it comes to restore and recovery?
> I assume that if we backed up using node1 and then tried a restore of an
> archivelog file from node2, we would need to make TSM think that node2 was
> node1 for it to find the backup.
>
> Thanks for any comments.
>
> --
> Regards
>
> Pete
>
--
Regards
Pete
Other related posts:
