ORA-01109: database not open

Error:

ORA-01109: database not open

Solutions:

  1. Start the database in mount state:
startup mount

2. Recover the database with controlfile backup:

alter database recover using backup controlfile;

3. Open the database in resetlogs:

alter database open resetlogs;

4. Shutdown and open the database in normal state:

shutdown immediate;
Startup
This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply