RE: RMAN dup issue

From: Pierre Labrousse <Pierre.Labrousse_at_digora.com>
Date: Wed, 15 Nov 2023 16:10:53 +0000
Message-ID: <PR1P264MB18242F78C5CA9528C750F699F6B1A_at_PR1P264MB1824.FRAP264.PROD.OUTLOOK.COM>

Strange, if it was working a hundred times and not this time, something would have changed !

You could try to relaunch your duplicate with debug mode of rman :       rman target / debug trace=/tmp/rmanDebug.trc log=/tmp/rmanLog.txt       ==> duplicate target database for standby from active database using backupset ....

Maybe you could find the reason of this error.

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 : Mark Davidson <wdavidsmc_at_gmail.com> Envoyé : mercredi 15 novembre 2023 16:38 À : Pierre Labrousse <Pierre.Labrousse_at_digora.com> Cc : oracle-l_at_freelists.org <oracle-l_at_freelists.org> Objet : Re: RMAN dup issue

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

Received on Wed Nov 15 2023 - 17:10:53 CET