RE: RMAN dup issue
Date: Wed, 15 Nov 2023 08:26:10 +0000
Message-ID: <PR1P264MB1824DCF20897D5ECD71EA24AF6B1A_at_PR1P264MB1824.FRAP264.PROD.OUTLOOK.COM>
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
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:
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 <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
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-lReceived on Wed Nov 15 2023 - 09:26:10 CET