My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

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.