Title: Oracle RAC restore fails with ORA-03123 and ORA-03127
Date: Apr 2009
Product & Version: NVBU 8.21
OS Version: Any
Module & Version: Oracle APM 6.x
Application version: Oracle RAC
Symptoms:
When running an Oracle database restore in a RAC environment, the restore fails with:
Information 2009/03/31 09:23:03 407 Data Plugin homs RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
Information 2009/03/31 09:23:03 407 Data Plugin homs RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
Information 2009/03/31 09:23:03 407 Data Plugin homs ORACLE error from target database:
Information 2009/03/31 09:23:03 407 Data Plugin homs ORA-03123: operation would block
Information 2009/03/31 09:23:03 407 Data Plugin homs RMAN-00571: ===========================================================
Information 2009/03/31 09:23:03 407 Data Plugin homs RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
Information 2009/03/31 09:23:03 407 Data Plugin homs RMAN-00571: ===========================================================
Information 2009/03/31 09:23:03 407 Data Plugin homs RMAN-03008: error while performing automatic resync of recovery catalog
Information 2009/03/31 09:23:03 407 Data Plugin homs ORA-03127: no new operations allowed until the active operation ends
Information 2009/03/31 09:23:03 407 Data Plugin homs ORA-03127: no new operations allowed until the active operation ends
Information 2009/03/31 09:23:03 407 Data Plugin homs Recovery Manager complete.
Warning 2009/03/31 09:23:04 407 Data Plugin homs Failed with exit code 1
Do not select "open database" as part of the restore options when using RAC.
The database open should be performed in a SQLPLUS session after resetting the CLUSTER_DATABASE parameter.
For example:
sqlplus SYS AS SYSDBA
ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=SPFILE SID='RACTEST2';
SHUTDOWN ABORT;
exit;
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center