Re: RMAN dup issue

From: Mark Davidson <wdavidsmc_at_gmail.com>
Date: Wed, 15 Nov 2023 10:38:04 -0500
Message-ID: <CAD8HnKEqm760WNm5oXkTrpmye0dhvQUKzvFsgP5kWM_DpMLK4A_at_mail.gmail.com>



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> 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)*
> *M*obile +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 <oracle-l-bounce_at_freelists.org> de
> la part de Mark Davidson <wdavidsmc_at_gmail.com>
> *Envoyé :* mardi 14 novembre 2023 21:14
> *À :* oracle-l_at_freelists.org <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
>
> 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
Received on Wed Nov 15 2023 - 16:38:04 CET

Original text of this message