All posts by mpbod

ORA-00308: cannot open archived log ‘string’

ORA-00308: cannot open archived log ‘string’

ORA-00308: cannot open archived log ‘string’
Cause: The system cannot access a required archived redo log file.
Action: Check that the off line log exists, the storage device is online, and the archived file is in the correct location. Then attempt to continue recovery or restart the recovery session.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00307: requested INSTANCE_NUMBER out of range, maximum is string

ORA-00307: requested INSTANCE_NUMBER out of range, maximum is string

ORA-00307: requested INSTANCE_NUMBER out of range, maximum is string
Cause: The initialization parameter INSTANCE_NUMBER specified a number that was out of range.
Action: Change INSTANCE_NUMBER to a valid range and restart the instance. The minimum value is one and the maximum value is the lower of the operating system-specific maximum or the MAXINSTANCES option specified in the CREATE DATABASE statement. See also your operating system-specific Oracle documentation.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00306: limit of string instances in this database

ORA-00306: limit of string instances in this database

ORA-00306: limit of string instances in this database
Cause: Starting this instance would exceed the maximum number of instances allowed for this database. This message occurs only with STARTUP shared and multiple instances.
Action: You cannot start more than the lower of a) port-specific limit as to the number of instances b) the number of instances specified at create-database time

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00305: log string of thread string inconsistent; belongs to another database

ORA-00305: log string of thread string inconsistent; belongs to another database

ORA-00305: log string of thread string inconsistent; belongs to another database
Cause: The database ID in the redo log file does not match the database ID in the control file. This redo log file is not from the current database.
Action: Specify the correct redo log file, then retry the operation.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00304: requested INSTANCE_NUMBER is busy

ORA-00304: requested INSTANCE_NUMBER is busy

ORA-00304: requested INSTANCE_NUMBER is busy
Cause: An instance tried to start by using a value of the initialization parameter INSTANCE_NUMBER that is already in use.
Action: Either a) specify another INSTANCE_NUMBER, b) shut down the running instance with this number c) wait for instance recovery to complete on the instance with this number.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00303: cannot process Parallel Redo

ORA-00303: cannot process Parallel Redo

ORA-00303: cannot process Parallel Redo
Cause: A redo log containing Parallel Redo has been detected. The current Oracle release cannot process this format of redo.
Action: Use a later release that supports Parallel Redo. to process this log.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00302: limit of string logs exceeded

ORA-00302: limit of string logs exceeded

ORA-00302: limit of string logs exceeded
Cause: The maximum number of redo log files has been exceeded.
Action: Use the CREATE CONTROLFILE command with a larger value for MAXLOGFILES if the compatibility is lower than 10.2.0. Otherwise, allocate more storage space for the control file.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00301: error in adding log file ‘string’ – file cannot be created

ORA-00301: error in adding log file ‘string’ – file cannot be created

ORA-00301: error in adding log file ‘string’ – file cannot be created
Cause: The creation of the redo log file failed
Action: Check: 1) there is enough storage space on the device 2) the name of the file is valid 3) the device is online 4) an IO error occurred Also, it is possible REUSE was specified on the command line and a file of the incorrect size exists. Either do not specify REUSE or use a file of the correct size.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00300: illegal redo log block size string specified – exceeds limit of string

ORA-00300: illegal redo log block size string specified – exceeds limit of string

ORA-00300: illegal redo log block size string specified – exceeds limit of string
Cause: The specified block size of the redo log is greater than the maximum block size for the operating system.
Action: Create the redo log on a device with a smaller block size

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00299: must use file-level media recovery on data file string

ORA-00299: must use file-level media recovery on data file string

ORA-00299: must use file-level media recovery on data file string
Cause: The control file does not contain an entry for this file, so block media recovery cannot be done.
Action: Restore the data file and perform file-level media recovery.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/