Oracle database startup failes with ORA-48317: ADR Relation [SWEEPERR] (Doc ID 1436933.1)

Last updated on JANUARY 30, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to startup the database, the startup fails with error message like below:

SQL> startup
ORACLE instance started.

Total System Global Area 534462464 bytes
Fixed Size 2215064 bytes
Variable Size 406848360 bytes
Database Buffers 117440512 bytes
Redo Buffers 7958528 bytes
ORA-48317: ADR Relation [SWEEPERR] of version=0 is obsolete


In the alert log, messages are visible like below:

MMON started with pid=15, OS id=4070
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Mar 14 10:13:23 2012
MMNL started with pid=16, OS id=4072
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /home/oracle/app
Wed Mar 14 10:13:23 2012
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 1305639619
Database mounted in Exclusive Mode
Lost write protection disabled
ORA-48317 signalled during: ALTER DATABASE MOUNT...


If you try to open the database in the sqlplus session, you would get:

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01507: database not mounted

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms