Bases de Datos

Oracle

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.

Oracle

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.

Oracle

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.

Oracle

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.

Oracle

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.

Subcategorías