How to start Oracle database ignore missing datafile(s)

Some of database datafiles are damaged or corrupted or moved to another position without modifying datafile name or datafiles are missing, … and now we need to startup the Oracle database ignoring missing datafiles.

Situation

In this case, assume that we miss

'/u01/oracle/oradata/oraerr.com/data01.dbf'

We’ll got … Read the rest “How to start Oracle database ignore missing datafile(s)”

How to start & stop Oracle databases (startup & shutdown)

In this post, I will show you all commands to start and stop Oracle databases. This is the basics but essentials while working with Oracle.

startup:

Login into database server, switch to oracle user and start sqlplus tool

su - oracle
sqlplus / as sysdba
Read the rest “How to start & stop Oracle databases (startup & shutdown)”