ORA-01184: logfile group string already exists

ORA-01184: logfile group string already exists

Cause: An ALTER DATABASE ADD LOGFILE command specified a log number for the new log which is already in use.

Action: Specify a different logfile number, or let the database choose an unused value.

ORA-01183: cannot mount database in SHARED mode

ORA-01183: cannot mount database in SHARED mode

Cause: Some other instance has the database mounted exclusive.

Action: Shutdown other instance then mount shared.

ORA-01182: cannot create database file string - file is in use or recovery

ORA-01182: cannot create database file string - file is in use or recovery

Cause: Attempted to use ALTER DATABASE CREATE DATAFILE to recreate a datafile that is online in an open instance or is being recovered.

Action: Close database in all instances and end all recovery sessions

ORA-01181: file string created before last known RESETLOGS, cannot recreate

ORA-01181: file string created before last known RESETLOGS, cannot recreate

Cause: Attempted to use ALTER DATABASE CREATE DATAFILE to recreate a datafile that existed before the last known RESETLOGS.

Action: Find a backup of the file, and recover it. Do incomplete recovery to time before file was originally created.

ORA-01180: can not create datafile 1

ORA-01180: can not create datafile 1

Cause: Attempting to create datafile 1 using ALTER DATABASE CREATE DATAFILE.

Action: Recover file from a backup or recreate database.

ORA-01179: file string does not exist

ORA-01179: file string does not exist

Cause: During datafile recovery, a file was listed which was not part for the database.

Action: Recheck the datafile name. Remember to use double quotes at the SQLDBA command line and remember that the file name is translated in the environment of the SQLDBA.

ORA-01178: file string created before last CREATE CONTROLFILE, cannot recreate

ORA-01178: file string created before last CREATE CONTROLFILE, cannot recreate

Cause: Attempted to use ALTER DATABASE CREATE DATAFILE to recreate a datafile that existed at the last CREATE CONTROLFILE command. The information needed to recreate the file was lost with the control file that existed when the file was added to the database.

Action: Find a backup of the file, and recover it. Do incomplete recovery to time before file was originally created.