My Oracle Support Banner

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

Last updated on NOVEMBER 25, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


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))'...
MMNL started with pid=16, OS id=4072
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /<DIR>
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



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

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