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@xxxxxxxxx)>
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@xxxxxxxxxx (mailto:Pierre.Labrousse@xxxxxxxxxx)> 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)@
(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@xxxxxxxxxxxxx (mailto:oracle-l-bounce@xxxxxxxxxxxxx)
<oracle-l-bounce@xxxxxxxxxxxxx (mailto:oracle-l-bounce@xxxxxxxxxxxxx)>
de la part de Mark Davidson <wdavidsmc@xxxxxxxxx
(mailto:wdavidsmc@xxxxxxxxx)>
Envoyé : mardi 14 novembre 2023 21:14
À : oracle-l@xxxxxxxxxxxxx (mailto:oracle-l@xxxxxxxxxxxxx)
<oracle-l@xxxxxxxxxxxxx (mailto:oracle-l@xxxxxxxxxxxxx)>
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