• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

The Geek Diary

CONCEPTS | BASICS | HOWTO

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • Linux Services
    • VCS
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
    • Data Guard
  • DevOps
    • Docker
    • Shell Scripting
  • Interview Questions
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

ORA-30012 Database Does Not Start With UNDO_MANAGEMENT=AUTO – Oracle Database 11gr2

By admin

The Problem

You have set undo_management=AUTO. You have set undo_tablespace = and either this tablespace does not exist or it is not created with ‘undo’ keyword. This may be because you either dropped and did not recreate the undo tablespace or recreated it without specifying ‘undo’ keyword. With this configuration the database will not start and throws an error:

ORA-30012: undo tablespace 'UNDOTBS' does not exist or of wrong type

The Solution

The parameter UNDO_MANAGEMENT is set to AUTO but the undo_tablespace does not exist or is not of type undo (i.e. the contents column of dba_tablespaces does not show ‘undo’ for this tablespace). Do the following steps to open the database:

1. set undo_management=MANUAL in your init file.

2. connect “/ as sysdba” and startup the database using this init file (if not it will use the SPFILE by default), e.g.:

SQL> startup pfile=[specify]

3. drop the (‘undo’) tablespace if you wrongly created one without actually specifying “undo”.

4. create a new undo tablespace, e.g.:

SQL> create UNDO tablespace undotbs datafile '/DB1/undotbs01.dbf' size 1M reuse;

5. shutdown the database

6. change UNDO_MANAGEMENT=AUTO in your init file and set UNDO_TABLESPACE=UNDOTBS (or whatever name you specified during the undo tablespace creation).

7. connect “/ as sysdba” and startup the database using this init file (as in step 2).

Now the database will open using the new undo tablespace and it would have created new undo segments in this tablespace.

Filed Under: oracle, Oracle 11g

Some more articles you might also be interested in …

  1. How to start up the ASM instance when the spfile is misconstrued or lost
  2. How to backup and delete archivelogs older than # number of days
  3. Oracle Database 12.2 RMAN Cross Platform Tablespace Transport Over Network
  4. ASMLib-Managed Disks on Multipathed iSCSI Targets are not Discovered after Server Reboot in CentOS/RHEL 7
  5. Example of PDB Level Duplication in Oracle Database 18c
  6. How to monitor Undo Tablespace Usage and the Free Space in Oracle Database
  7. Oracle Database : What Is The Search Order For The LDAP.ORA File
  8. How To Resize An ACFS Filesystem/ASM Volume (ADVM)
  9. RMAN-06059 During RMAN Backup of archivelogs ( How to backup archivelogs moved to a different location)
  10. Unable to export realm protected table using data pump

You May Also Like

Primary Sidebar

Recent Posts

  • How to disable ICMP redirects on CentOS/RHEL
  • What are Oracle Key Vault Roles
  • What Is Oracle Key Vault
  • Auditing with Oracle Database Vault Reports
  • Archives
  • Contact Us
  • Copyright

© 2021 · The Geek Diary