Oracle - Errores y soluciones

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01002: database must be mounted for media recoverybases_datos_2

 


 

Cause: An attempt to perform media recovery was made but the database is not mounted.

 

Action: Mount the database.

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01108: file string is in backup or media recoverybases_datos_2

 


 

Cause: Either media recovery is actively being applied to the file, or it is being backed up while the database is in NOARCHIVELOG mode. It cannot be used for normal database access or crash recovery.

 

Action: Complete or cancel the media recovery session or backup.

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01109: database not openbases_datos_2

 


 

Cause: A command was attempted that requires the database to be open.

 

Action: Open the database and try the command again.

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01110: data file string: 'string'bases_datos_2

 


 

Cause: Reporting file name for details of another error. The reported name can be of the old file if a data file move operation is in progress.

 

Action: See associated error message.

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01111: name for data file string is unknown - rename to correct filebases_datos_2

 


 

Cause: The data file was missing from a CREATE CONTROLFILE command or backup control file recovery was done with a control file that was saved before the file was created.

 

Action: Rename the MISSING file to the name of the real file.

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01112: media recovery not startedbases_datos_2

 


 

Cause: An attempt to continue media recovery is being made but media recovery was not started.

 

Action: None.

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01113: file string needs media recoverybases_datos_2

 


 

Cause: An attempt was made to online or open a database with a file that is in need of media recovery.

 

Action: First apply media recovery to the file.