Re: RMAN dup issue

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 15 Nov 2023 19:15:47 -0500

On 11/14/23 15:14, Mark Davidson wrote:

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

Mark, how many archive logs did you back up? Backup doesn't backup just data files. Can you post your RMAN script? Did you use "backup as compressed backupset"?

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

Other related posts: