Oracle - Errores y soluciones

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01150: cannot prevent writes - file string has online backup setbases_datos_2

 


 

Cause: An attempt to make a tablespace read only or offline normal found that an online backup is still in progress. It will be necessary to write the file header to end the backup, but that would not be allowed if this command succeeded.

 

Action: End the backup of the offending tablespace and retry this command.

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01143: cannot disable media recovery - file string needs media recoverybases_datos_2

 


 

Cause: An attempt to disable media recovery found a file that needs media recovery, thus media recovery cannot be disabled.

 

Action: Recover the offending file or drop the tablespace it belongs to and retry this command.

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01144: File size (string blocks) exceeds maximum of string blocks

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01155: the database is being opened, closed, mounted or dismountedbases_datos_2

 


 

Cause: The requested operation needs the instance to be in a particular state but the state is being changed.

 

Action: Wait for the open, close, mount, or dismount to complete then retry the operation. If necessary, a SHUTDOWN ABORT will always work.

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01145: offline immediate disallowed unless media recovery enabledbases_datos_2

 


 

Cause: ALTER TABLESPACE ... OFFLINE IMMEDIATE or ALTER DATABASE DATAFILE ... OFFLINE is only allowed if database is in ARCHIVELOG mode.

 

Action: Take tablespace offline normally or shutdown abort. Reconsider your backup strategy. You could do this if you were archiving your logs.

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01146: cannot start online backup - file string is already in backupbases_datos_2

 


 

Cause: When starting an online backup it was noticed that an online backup was already started for one of the data files.

 

Action: End the first backup before beginning another.

Ratio: 4 / 5

Inicio activadoInicio activadoInicio activadoInicio activadoInicio desactivado

ORA-01147: SYSTEM tablespace file string is offlinebases_datos_2

 


 

Cause: A file belonging to the SYSTEM tablespace has been marked offline by the DBA. The database cannot be started until all SYSTEM tablespace files are online and openable.

 

Action: Bring the file online.