Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

RMAN duplicate warning

markdba123Nov 22 2023

Hello,

Running 12.1.0.2 on ODAX8-2 baremetal, linux 7, RAC.

I've been able to create over 100+ physical standby databases (DR) on our DR machine over the past couple of months.

I now get a warning message in the alert.log:

WARNING: unknown state for DB spfile location resource, Return Value: 3

The RMAN duplicate just sits there during/after the spfile from production has been restored.

Below is a snippet of my RMAN command file:

run {
allocate channel p1 type disk;
allocate channel p2 type disk;
allocate channel p3 type disk;
allocate channel p4 type disk;
allocate channel p5 type disk;
allocate channel p6 type disk;
allocate auxiliary channel s1 type disk;
allocate auxiliary channel s2 type disk;
allocate auxiliary channel s3 type disk;
allocate auxiliary channel s4 type disk;
allocate auxiliary channel s5 type disk;
allocate auxiliary channel s6 type disk;
duplicate target database for standby from active database using backupset
dorecover
spfile
.

.

.

nofilenamecheck;
}
exit;

Has anyone else run into this issue/warning? Nothing has been changed or updated on either server since installation of the ODA. Very strange behaviour since it was just working.

Could it be networking or firewall related?

Thank you,
Mark

Comments
Post Details
Added on Nov 22 2023
2 comments
462 views