Re: RMAN dup issue

  Mark,      

Have you ruled out any stability issues(storage/   

memory or filesystem related) where db spfile   

 is stored?      

Rajeev         

>
> On Nov 15, 2023 at 10:40 AM, <Mark Davidson (mailto:wdavidsmc_at_gmail.com)> wrote:
>
>
>
> Hi Pierre,
>
> Thank you for the MOS link.
> This might be a work-around but my issue is I was able to do a normal RMAN dup with spfile in the command file several hundred times before on this same box and now I get this error:
>
> .
>
> .
>
> .
>
> duplicate target database for standby from active database using backupset
> dorecover
> spfile
>
> .
>
> .
>
> .
>
>
>
> I need to understand what causes this.
>
>
>
> Thank you,
>
> Mark
>
>
>
>
>
> On Wed, Nov 15, 2023 at 3:26 AM Pierre Labrousse <Pierre.Labrousse_at_digora.com (mailto:Pierre.Labrousse_at_digora.com)> wrote:
>
> >
> >
> >
> > Hey,
> >
> >
> >
> > Have a look to note MOS 2800669.1. You have to create a pfile and transform into spfile and not used the spfile clause of rman duplicate command.
> >
> >
> >
> > Pierre
> >
> >
> >
> >
> >
> >
> >
> >
> > Pierre LABROUSSE
> > Consultant DBA ORACLE (OCM 10g/11g/12c)
> > Mobile +33 (0)7 56 05 27 38
> >
> > pierre.labrousse (https://owa.digora.com/owa/redir.aspx?C=6cU4SWG0HEauWwQa74AWhWf917AeKdIIQ087knyB2eMPFQyUFrMl2EZ1Rw0CEMwBfg1hQ0wI9Zc.&URL=mailto%3apierre.labrousse%40digora.com%2520%250d)_at_ (https://owa.digora.com/owa/redir.aspx?C=6cU4SWG0HEauWwQa74AWhWf917AeKdIIQ087knyB2eMPFQyUFrMl2EZ1Rw0CEMwBfg1hQ0wI9Zc.&URL=mailto%3apierre.labrousse%40digora.com%2520%250d)digora.co (https://owa.digora.com/owa/redir.aspx?C=6cU4SWG0HEauWwQa74AWhWf917AeKdIIQ087knyB2eMPFQyUFrMl2EZ1Rw0CEMwBfg1hQ0wI9Zc.&URL=mailto%3apierre.labrousse%40digora.com%2520%250d)m (https://owa.digora.com/owa/redir.aspx?C=6cU4SWG0HEauWwQa74AWhWf917AeKdIIQ087knyB2eMPFQyUFrMl2EZ1Rw0CEMwBfg1hQ0wI9Zc.&URL=mailto%3apierre.labrousse%40digora.com)
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > De : oracle-l-bounce_at_freelists.org (mailto:oracle-l-bounce_at_freelists.org) <oracle-l-bounce_at_freelists.org (mailto:oracle-l-bounce_at_freelists.org)> de la part de Mark Davidson <wdavidsmc_at_gmail.com (mailto:wdavidsmc_at_gmail.com)>
> > Envoyé : mardi 14 novembre 2023 21:14
> > À : oracle-l_at_freelists.org (mailto:oracle-l_at_freelists.org) <oracle-l_at_freelists.org (mailto:oracle-l_at_freelists.org)>
> > Objet : RMAN dup issue
> >
> >
> >
> >
> >
> > Hello,
> >
> >
> >
> > I'm running on a ODA8-2 bare-metal, Linux 7, RAC, EE 12.1.0.2 (will be upgrading soon).
> >
> > Over this past summer I migrated +100 DR databases onto this box using RMAN dup.
> >
> > Now when I run the same process, RMAN hangs:
> >
> >
> >
> > channel s1: starting datafile backup set restore
> > channel s1: using network backup set from service //titan0:1521/fowldrt
> > channel s1: restoring SPFILE
> > output file name=/u01/app/odaorahome/oracle/product/12.1.0.2/dbhome_1/dbs/spfilefowltst.ora (http://12.1.0.2/dbhome_1/dbs/spfilefowltst.ora)
> >
> >
> > When I look at the auxiliary database alert.log, I see this:
> >
> >
> >
> > WARNING: unknown state for DB spfile location resource, Return Value: 3
> >
> >
> >
> > Has anyone ever seen this behavior before? I'm surprise to suddenly see this issue since I've done this multiple times before using the same process.
> >
> >
> >
> > Any help would be appreciated.
> >
> >
> >
> > Cheers,
> >
> > Mark
> >

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