Re: very large RAC database copy to another RAC
- From: dd yakkali <dd.yakkali@xxxxxxxxx>
- To: gparc@xxxxxxx
- Date: Thu, 20 Jan 2011 02:01:40 -0800
hmm interesting.. I wonder how can we tell the asmcmd of the remote asm? I
always thought asmcmd only works on the same host not across hosts/ASMs.
On Thu, Jan 20, 2011 at 1:26 AM, <gparc@xxxxxxx> wrote:
>
> Hi,
>
> in fact, REMOTELY, you can only copy from ASM to ASM.
> That's the answer I got from OWS some months ago :
> "In order to use the asmcmd cp command to copy files remotely you must have
> ASM
> running on both systems. The cp command must be able to establish
> communication
> with ASM on the remote server"
>
> Luckily, that is the case you described.
>
> HTH
>
> Regards
>
> Gilles
>
> Quoting dd yakkali <dd.yakkali@xxxxxxxxx>:
>
> Giles,
>
> thanks for your reply. Can that be used for copying from asm to another
> asm?
> I thought that is just to copy from asm to a filesystem.
>
> On Thu, Jan 20, 2011 at 12:29 AM, <gparc@xxxxxxx> wrote:
>
> > Hi,
> >
> > you could also use "asmcmd" copy command.
> > Never tried myself though.
> >
> > Hope this helps
> >
> > Regards
> >
> > Gilles
> >
> > Quoting dd yakkali <dd.yakkali@xxxxxxxxx>:
> >
> > Dear DB admin gurus,
> >
> > I need some thoughts on this. We have a very large NOArchivelog
> database
> > 11.1.0.7 RAC 20 node RHEL4, 300+T spread on about 50 tablespaces, we
> want
> > copy this to another RAC cluster RHEL5 30 nodes in a different data
> center
> > connected with pretty good network infrastructure between them. They
> both
> > use ASM of course.
> >
> > We are probably allowed to be down on the source for about 48 Hours
> max.
> >
> > So our aim is to parallelize(increase throughput by utilizing all the
> > nodes of both RAC systems ) the copy from one ASM to another ASM
> directly.
> > I want to know what techniques are available to do this. Few techniques
> > that
> > came up in the discussion are RMAN duplicate database,
> dbms_file_transfer
> > via dblink to copy datafiles using transportable tablespaces technique
> > etc.
> >
> > I want to know if any of you out there did dbms_file_transfer between
> > databases and if you did, can you please share your experiences.
> >
> > Any thoughts/pointers are greatly appreciated.
> >
> > thanks
> > Deen
> >
> >
> >
> >
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
Other related posts:
