Wednesday, October 29, 2014

ORA-00273 Media recovery of direct load data that was not logged

Error Code
ORA-00273

Description
Media recovery of direct load data that was not logged.

Cause
Possible cause of this error is, a media recovery session encountered a table that was loaded by the direct loader without logging any redo information. Some or all of the blocks in this table are now marked as corrupt.

Action
To fix this issue, the table must be dropped or truncated so that the corrupted blocks can be reused. If a more recent backup of the file is available, try to recover this file to eliminate this error.

reference

ORA-00272 Error writing archive log string

Error Code
ORA-00272

Description
Error writing archive log string.

Cause
Possible cause of this error is, an I/O error occurred while archiving a redo log file.

Action
To fix this issue, check that the output device is still available and correct any device errors that may have occurred. Also, make certain that sufficient space for archiving is available on the output device.

reference

ORA-00271 There are no logs that need archiving

Error Code
ORA-00271

Description
There are no logs that need archiving.

Cause
Possible cause of this error is, an attempt was made to archive the unarchived redo log files manually, but there are no files that need to be archived.

Action
No action required.

reference

ORA-00270 Error creating archive log string

Error Code
ORA-00270

Description
Error creating archive log string.

Cause
Possible cause of this error is, an error was encountered when either creating or opening the destination file for archiving.

Action
To fix this issue, check that the archive destination is valid and that there is sufficient space on the destination device.

reference

Monday, October 27, 2014

ORA-00269 Specified log file is part of thread string not string

Error Code
ORA-00269

Description
Specified log file is part of thread string not string.

Cause
Possible cause of this error is, the given redo log file is not part of the given thread.

Action
To fix this issue, check that the thread of the redo log file matches the thread on the command line. If not, use a redo log file from the appropriate thread. Retry the command after correcting the error.

reference

ORA-00268 Specified log file does not exist string

Error Code
ORA-00268

Description
Specified log file does not exist 'string'.

Cause
Possible cause of this error is, the given redo log file does not exist.

Action
To fix this issue, check the spelling and capitalization of the filename and retry the command.

reference

ORA-00267 Name of archived log file not needed

Error Code
ORA-00267

Description
Name of archived log file not needed.

Cause
Possible cause of this error is, during media recovery, the name of an archived redo log file was entered, but no name was requested.

Action
To fix this issue, continue media recovery, but do not enter a new log name.

reference

ORA-00266 Name of archived log file needed

Error Code
ORA-00266

Description
Name of archived log file needed.

Cause
Possible cause of this error is, during media recovery, the name of an archived redo log file was requested, but no name was entered.

Action
To fix this issue, mount the correct redo log file and enter its name when it is requested.

reference

ORA-00265 Instance recovery required, cannot set ARCHIVELOG mode

Error Code
ORA-00265

Description
Instance recovery required, cannot set ARCHIVELOG mode.

Cause
Possible cause of this error is, the database either crashed or was shutdown with the ABORT option. Media recovery cannot be enabled because the online logs may not be sufficient to recover the current datafiles.

Action
To fix this issue, open the database and then enter the SHUTDOWN command with the NORMAL or IMMEDIATE option.

reference

ORA-00264 No recovery required

Error Code
ORA-00264

Description
No recovery required.

Cause
Possible cause of this error is, an attempt was made to perform media recovery on files that do not // need any type of recovery.

Action
To fix this issue, do not attempt to perform media recovery on the selected files. Check to see that the filenames were entered properly. If not, retry the command with the proper filenames.

reference

ORA-00263 there are no logs that need archiving for thread string

Error Code
ORA-00263

Description
There are no logs that need archiving for thread string.

Cause
Possible cause of this error is, an attempt was made to manually archive the unarchived logs in this thread but no logs needed archiving.

Action
No action required.

reference

ORA-00262 Current log string of closed thread string cannot switch

Error Code
ORA-00262

Description
Current log string of closed thread string cannot switch.

Cause
Possible cause of this error is, the log cannot be cleared or manually archived because it is the current log of a closed thread, and it is not possible to switch logs so another log is current. All other logs for the thread need to be archived, or cleared, and cannot be reused.

Action
To fix this issue, archive another log in the same thread first, or complete the clearing. See attached errors for the reason the switch cannot be completed.

reference

ORA-00261 Log string of thread string is being archived or modified

Error Code
ORA-00261

Description
Log string of thread string is being archived or modified.

Cause
Possible cause of this error is, the log is either being archived by another process or an administrative command is modifying the log. Operations that modify the log include clearing, adding a member, dropping a member, renaming a member, and dropping the log.

Action
To fix this issue, wait for the current operation to complete and try again.

reference

ORA-00260 Cannot find online log sequence string for thread string

Error Code
ORA-00260

Description
Cannot find online log sequence string for thread string.

Cause
Possible cause of this error is, the log sequence number supplied to the archival command does not match any of the online logs for the thread. The log might have been reused for another sequence number, it might have been dropped, the sequence number might be greater than the current log sequence number, or the thread might not have any logs.

Action
To fix this issue, check the ARCHIVE statement, then specify a valid log sequence number. Specify a valid log sequence number.

reference

ORA-00259 Log string of open instance string is the current log, cannot archive

Error Code
ORA-00259

Description
Log string of open instance string (thread string) is the current log, cannot archive.

Cause
Possible cause of this error is, an attempt was made to archive the current log of an open thread. This is not allowed because the redo log file may still be in use for the generation of redo entries.

Action
To fix this issue, force a log switch in the instance where the thread is open. If no instances are open, open the database so that instance recovery can recover the thread.

reference

ORA-00258 Manual archiving in NOARCHIVELOG mode must identify log

Error Code
ORA-00258

Description
Manual archiving in NOARCHIVELOG mode must identify log.

Cause
Possible cause of this error is, the database is in NOARCHIVELOG mode and a command to manually archive a log did not specify the log explicitly by sequence number, group number or filename.

Action
To fix this issue, Specify log by filename, by group number or by thread and sequence number.

reference

ORA-00257 Archiver error. Connect internal only, until freed.

Error Code
ORA-00257

Description
Archiver error. Connect internal only, until freed.

Cause
Possible cause of this error is, the archiver process received an error while trying to archive a redo log. If the problem is not resolved soon, the database will stop executing transactions. The most likely cause of this message is the destination device is out of space to store the redo log file.

Action
To fix this issue, check archiver trace file for a detailed description of the problem. Also verify that the device specified in the initialization parameter ARCHIVE_LOG_DEST is set up properly for archiving.

reference

ORA-00256 cannot translate archive destination string

Error Code
ORA-00256

Description
cannot translate archive destination string string.

Cause
Possible cause of this error is, the destination specified by an ALTER SYSTEM ARCHIVE LOG START TO command could not be translated.

Action
To fix this issue, check the accompanying message stack for more detailed information. Then, retry the ALTER SYSTEM command using a different string.

reference

Wednesday, October 22, 2014

ORA-00255 Error archiving log string of thread string

Error Code
ORA-00255

Description

Error archiving log string of thread string, sequence # string

Cause

Possible cause of this error is, an error occurred during archiving.

Action

To fix this issue, check the accompanying message stack for more detailed information. If the online log is corrupted, then the log can be cleared using the UNARCHIVED option. This will make any existing backups useless for recovery to any time after the log was created, but will allow the database to generate redo.

reference

Do events have return type?

What is a namespace?

What is a delegate?

What is difference between procedural and object oriented programming?

What is a hash table?

How do we achieve encapsulation in C#?

What is meant by static binding?

What is meant by dynamic binding?

What is Modularity?

What is meant by persistence?

What is collaboration?

What is an event?

What is Stack?

What is Queue?

What are different types of castings?

What is the use of mutable keyword?

What is the function of this operator?

What is static variable and static function?

What is extreme programming?

What is agile methodology?

What is exception?

What is serialization?

What are access modifiers?

What are inner classes?

What is difference between static and Non-static fields?

What are persistent and non-persistent objects?

What are sealed modifiers?

What is composition?

What is aggregation?

What are limitations and restrictions of interfaces?

What is the advantage of interface over inheritance in OOP?

What’s the difference between abstract class and interface?

What is interface?

What is difference and similarities between class and structure?

What is Structure?

How can you prevent class to be inherited further?

What is virtual class?

What is abstract class?

How to prevent function from being overridden in C#?

What is abstract function?

What is pure virtual function?

What is virtual function?

What is function overloading and function overriding?

What is function?

Why destructor is not over loaded?

What is destructor?

What is static constructor?

What is copy constructor?

What is constructor?

What are different types of polymorphism?

What is multilevel inheritance?

What are different types of inheritance?

What are the 4 important principles in OOP?

What is difference between abstraction and encapsulation?

What is Polymorphism?

What is inheritance?

What is Abstraction?