Category Archives: RMAN Database Error Messages

RMAN-06097: text of failing SQL statement: string

oracle

RMAN-06097: text of failing SQL statement: string 
Cause: This is an informational message to accompany message 6003 or 6004. 
Action: No action required. 

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

RMAN-06096: SWITCH required for newname of datafile string to take effect

oracle

RMAN-06096: SWITCH required for newname of datafile string to take effect
Cause: A SET NEWNAME was issued for this datafile, but no SWITCH command was issued before the RECOVER command.
Action: Issue a SWITCH command to make the new name take effect before doing RECOVER.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

RMAN-06095: a backup controlfile must be restored to recover datafile string

oracle

RMAN-06095: a backup controlfile must be restored to recover datafile string
Cause: The control file currently mounted by the target database contains a newer incarnation of the datafile than the recovery catalog indicates is appropriate for the point-in-time being recovered to.
Action: Restore the control file, using the same UNTIL clause specified on the failing RECOVER command, then reissue the command. If no control file can be restored, then you should issue a CREATE CONTROLFILE command.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

RMAN-06094: datafile string must be restored

oracle

RMAN-06094: datafile string must be restored
Cause: A RECOVER command was issued, and the recovery catalog indicates the specified datafile should be part of the recovery, but this datafile is not listed in the control file, and cannot be found on disk.
Action: Issue a RESTORE command for this datafile, using the same UNTIL clause specified to the RECOVER command (if any), then reissue the RECOVER.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

RMAN-06093: recovery catalog contains obsolete version of datafile string

oracle

RMAN-06093: recovery catalog contains obsolete version of datafile string
Cause: The specified datafile number was dropped and then reused. The control file mounted by the target database contains the newer version of the datafile, but the recovery catalog contains information about only the older version.
Action: Issue a RESYNC command to update the recovery catalog, then reissue the failing command. If the error persists, contact Oracle Support Services.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

RMAN-06092: error while looking up backup piece

oracle

RMAN-06092: error while looking up backup piece
Cause: An error occurred while looking up the specified backup piece in the recovery catalog or target database control file.
Action: This error is accompanied by other errors describing the reason for the failure. Ensure that the name or key is entered correctly. If the backup piece was created when the recovery catalog was not available, then a RESYNC CATALOG must be done to update the recovery catalog.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

RMAN-06091: no channel allocated for maintenance (of an appropriate type)

oracle

RMAN-06091: no channel allocated for maintenance (of an appropriate type)
Cause: A command was entered that requires a maintenance channel, and no maintenance channel is allocated, or none of the appropriate type.
Action: Use ALLOCATE CHANNEL FOR MAINTENANCE before deleting backup pieces, or using the CROSSCHECK or DELETE EXPIRED commands. Proxy copies require a non-DISK channel.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

RMAN-06090: error while looking up controlfile copy: string

oracle

RMAN-06090: error while looking up controlfile copy: string
Cause: An error occurred while looking up the specified control file copy in the recovery catalog or target database control file.
Action: This error is accompanied by other errors describing the reason for the failure. Ensure that the file name is entered correctly. If the control file copy was created when the recovery catalog was not available, then a RESYNC CATALOG must be done to update the recovery catalog.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

RMAN-06089: archived log string not found or out of sync with catalog

oracle

RMAN-06089: archived log string not found or out of sync with catalog
Cause: The indicated file is not found, or is found but is not the same file that the recovery catalog thinks it is. It is likely that some operation outside of Recovery Manager has altered the file, or that Recovery Manager has not resynchronized with the target database.
Action: Re-catalog the file and retry the operation.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

RMAN-06088: datafile copy string not found or out of sync with catalog

oracle

RMAN-06088: datafile copy string not found or out of sync with catalog
Cause: The indicated file is not found, or is found but is not the same file that the recovery catalog thinks it is. It is likely that some operation outside of Recovery Manager has altered the file, or that Recovery Manager has not resynchronized with the target database.
Action: Re-catalog the file and retry the operation.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/