Re: RMAN duplicate can't find backup piece with ORA-15012

From: Yong Huang <yong321_at_yahoo.com>
Date: Mon, 13 Dec 2010 14:54:07 -0800 (PST)
Message-ID: <174283.76913.qm_at_web80603.mail.mud.yahoo.com>

It's not easy for me to explain. As I said, this form throws ORA-15012 (ASM file does not exist):

. oraenv
targetdb
rman target / catalog rman_at_catdb auxiliary sys/xxx_at_davidh

even though in the same rman session, "validate backupset", "crosscheck backup", "list backup", find the backup piece.

This form, as Oracle analyst suggested to "avoid listener interference", works:

. oraenv
davidh
rman target sys/xxxx_at_targetdb catalog rman_at_catdb auxiliary /

I thought it must be due to misconfigured listener. But lsnrctl service (or status) | grep davidh shows the service fine. sqlplus sys/xxx_at_davidh as sysdba also works. listener.ora is modified the same as on the server I previously did duplicate.

There's no change in "environment" setting, nor change in initdavidh.ora. ASM v$asm_client starts to show davidh as a client (as I keep checking it) after the auxliary channels are created in the second form above, i.e.:

Starting restore at 20101213 15:53:47
using channel ORA_AUX_SBT_TAPE_1
using channel ORA_AUX_DISK_1
...

So consider its appearance in v$asm_client as effect, not cause.

I got a lengthy rman debug log for the failed session. But I can't find the *cause* of the problem by reading it.

Yong Huang

• On Mon, 12/13/10, Leyi Zhang (Kamus) <kamusis_at_gmail.com> wrote:

> It make sense. Basically duplicate database in Oracle10g need complete
> backupsets exists in auxiliary server not in target server.
> Since you are doing duplicate on the same machine with target
> database, you don't need to do copy. but auxiliary instance
> should has proper environment settings.
>
> BTW: Which environment you missed in auxiliary instance? and after
> you set , is davidh instance display in V$ASM_CLIENT?
>
> --
> Kamus <kamusis_at_gmail.com>
>
> Visit my blog for more : http://www.dbform.com
> Join ACOUG: http://www.acoug.org
>
>
>
> On Mon, Dec 13, 2010 at 1:12 PM, Yong Huang <yong321_at_yahoo.com>
> wrote:
> > A quick update. Oracle support called me and asked me
> > to try setting the environment to the auxiliary instance
> > instead of target. And voila, the error is gone!
> >
> > rman target sys/xxxx_at_mytarget catalog rman_at_mycatalog auxiliary /
      

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

Received on Mon Dec 13 2010 - 16:54:07 CST