Re: RMAN dup issue

Yes, plenty of memory, cpu and disk space.

On Wed, Nov 15, 2023 at 11:42 AM Rajeev Prabhakar <rprabha01_at_gmail.com> wrote:

> 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 <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> 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