My Oracle Support Banner

After Upgrading Database Error ORA-16433 including RMAN DUPLICATE / RESTORE (Doc ID 1074855.1)

Last updated on NOVEMBER 29, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 27-NOV-2015 ***

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the
Oracle sample schema(s), 
Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual
environments, actual persons, living or dead, is 
purely coincidental and not intended in any manner.

For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:

Database Name: PROD,V11P
Disk Group Names: +BACKUP
Directory Names: C:\ORA11G, C:\APP and all sub-directories
Catalog Schema:  RMAN


**********

Possible Symptoms:

o  Database was upgraded to 11.1.0.7.2

   The database shows its in read write mode. ( open )
   RMAN Resync catalog failing with errors:


o This problem can be caused by a recreate of the controlfile with resetlogs,
  and subsequent failure during the open resetlogs.
  That is, if recreating a controlfile with resetlogs option, but if there are any issues
  during the open resetlogs, leaving the database in this state reporting
  .
   ORA-16433: The database has not been opened in read-write mode
  .

$ rman catalog rman/<password>@<catalog service> target sys/<password>@<target service>

Recovery Manager: Release 11.1.0.7.0 - Production on Mon Mar 15 10:58:49 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: PROD (DBID=1078444404)
connected to recovery catalog database

RMAN> resync catalog;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of resync command on default channel at 03/15/2010 10:58:56
ORA-16433: The database has not been opened in read-write mode



-Tried to open the database in read only then change it to read write. Same error

-Tried sql> 'alter database backup controlfile to trace' from sqlplus failed with the same error

SQL> alter database backup controlfile to trace;
alter database backup controlfile to trace
*
ERROR at line 1:
ORA-16433: The database has not been opened in read-write mode

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.