topic Re: rman error under OpenVMS in Operating System - OpenVMS

rman error under OpenVMS

openvms_2 — Fri, 12 Feb 2010 02:30:20 GMT

Problem with use rman under OpenVMS 8.2

ORACLE9I> rman target / nocatalog

Recovery Manager: Release 9.2.0.8.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: ARMS (DBID=479895618)
using target database controlfile instead of recovery catalog

RMAN> backup database;
Starting backup at 12-FEB-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=17 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00002 name=APP:[ORACLE9I.ORADATA.ARMS]UNDOTBS01.DBF
input datafile fno=00001 name=APP:[ORACLE9I.ORADATA.ARMS]SYSTEM01.DBF
input datafile fno=00009 name=DATA:[ORACLE9I.ORADATA.ARMS]SPACE01.DBF
input datafile fno=00021 name=ARCH:[ORACLE9I.ORADATA.ARMS]SPACE_ARCH.DBF
input datafile fno=00010 name=DATAIDX:[ORACLE9I.ORADATA.ARMS]SPACE_INDX01.DBF
input datafile fno=00004 name=APP:[ORACLE9I.ORADATA.ARMS]EXAMPLE01.DBF
input datafile fno=00023 name=DATA:[ORACLE9I.ORADATA.ARMS]BACKUP_ASM201.DBF
input datafile fno=00011 name=DATA:[ORACLE9I.ORADATA.ARMS]MAPS01.DBF
input datafile fno=00022 name=DATA:[ORACLE9I.ORADATA.ARMS]MAPS02.DBF
input datafile fno=00024 name=DATAIDX:[ORACLE9I.ORADATA.ARMS]BACKUP_ASM2_INDX01.DBF
input datafile fno=00025 name=DATA:[ORACLE9I.ORADATA.ARMS]QUEUE.DBF
input datafile fno=00026 name=DATA:[ORACLE9I.ORADATA.ARMS]CATSYS.DBF
input datafile fno=00005 name=DATAIDX:[ORACLE9I.ORADATA.ARMS]INDX01.DBF
input datafile fno=00007 name=APP:[ORACLE9I.ORADATA.ARMS]USERS01.DBF
input datafile fno=00012 name=DATAIDX:[ORACLE9I.ORADATA.ARMS]MAPS_INDX01.DBF
input datafile fno=00013 name=DATA:[ORACLE9I.ORADATA.ARMS]GDOSYS01.DBF
input datafile fno=00003 name=APP:[ORACLE9I.ORADATA.ARMS]DRSYS01.DBF
input datafile fno=00008 name=APP:[ORACLE9I.ORADATA.ARMS]XDB01.DBF
input datafile fno=00006 name=APP:[ORACLE9I.ORADATA.ARMS]TOOLS01.DBF
channel ORA_DISK_1: starting piece 1 at 12-FEB-10
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
RMAN-10039: error encountered while polling for RPC completion on channel ORA_DISK_1
RMAN-10006: error running SQL statement: select act from x$ksusex where sid=:1 and serial=:2
RMAN-10002: ORACLE error: ORA-03123: operation would block
ORACLE9I>

Re: rman error under OpenVMS

John Gillings — Fri, 12 Feb 2010 03:45:11 GMT

Not knowing anything about "rman" (never even heard of if), but looking at the text of the error messages:

"operation would block" suggests maybe it's expecting exclusive access to something (a database?), but hasn't got it?

"fatal error in recovery manager" sounds like something that needs to be reported to Oracle.

Other than that, standard support questions...

Did it ever work?
If so when did it stop working?
What changed?
If not, why do you think it should work?

Re: rman error under OpenVMS

Karl Rohwedder — Fri, 12 Feb 2010 05:59:06 GMT

Here is the error text for 3123:

ORA-03123:
operation would block
Cause: This is a status code that indicates that the operation cannot complete now.
Action: None; this is not an error. The operation should be retried again for completion.

regards Kalle

Re: rman error under OpenVMS

Patrick Aspinall — Fri, 12 Feb 2010 08:21:08 GMT

How are you connecting to the database when you perform this operation?

Metalink note # 223396.1 notes that

In Oracle9i on VMS, when you use OS Authentication, to connect to the target
database using RMAN, you would receive error ORA-03123 while executing
any RMAN command.

Which is consistent with what you are seeing.

The solution is to

As the connection has to be TCP/IP, setup a SQL*Net configuration
and configure the Password File Authentication as it needs to be
set for remote SYSDBA connections.

Hope this helps

Patrick

Re: rman error under OpenVMS

openvms_2 — Sun, 14 Feb 2010 11:52:04 GMT

SQL*Net configuration is TCP/IP,Password File Authentication is configured and remote SYSDBA connections is set correct.

According "Oracle9i Recovery Manager User's Guide Release 2 (9.2)"
for Oracle Net authentication:

# example of Oracle Net authentication
% rman TARGET SYS/oracle@trgt

in OpenVMS this still not working:

ORACLE9I> pipe @oracle_home:orauser arms ; rman target "sys" nocatalog
%DCL-I-SUPERSEDE, previous value of ORA_DATA has been superseded

Recovery Manager: Release 9.2.0.8.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

target database Password:
connected to target database: ARMS (DBID=479895618)
using target database controlfile instead of recovery catalog

RMAN> backup spfile;
Starting backup at 14-FEB-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=18 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
RMAN-10039: error encountered while polling for RPC completion on channel ORA_DISK_1
RMAN-10006: error running SQL statement: select act from x$ksusex where sid=:1 and serial=:2
RMAN-10002: ORACLE error: ORA-03123: operation would block
ORACLE9I>