Unable to open the database in read only mode after restore/recovery
(Doc ID 316154.1)
Last updated on FEBRUARY 02, 2022
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A and laterOracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.2.0.2 [Release 8.1.7 to 11.2]
Information in this document applies to any platform.
Purpose
This article address the reasons behind failure of opening the database in read only mode. It discuss the ways to open the database in read only mode.
Scope
This is intended for DBA and Oracle Support personnel.
Details
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
| Purpose |
| Scope |
| Details |
| Case 1: When database is mounted using current controlfile , datafiles are restored from cold backup |
| Case 2: When controlfile is recreated and datafiles are restored from cold backup. |
| Case 3: When controlfile is from earlier cold backup than datafiles. |
| Case 4: READ ONLY tablespaces, which never have switched to READ WRITE after a RESETLOGS |