Restore of an Oracle 11g database fails with the RMAN error "ORA-01589: must use RESETLOGS or NORESETLOGS option for database open"

  • Article ID:100019541
  • Modified Date:
  • Product(s):

Problem

Restore of an Oracle 11g database fails with the RMAN error "ORA-01589: must use RESETLOGS or NORESETLOGS option for database open"

Error Message

Final error: 0xe0000340 - The Database script returned an error. Refer to the Database script output section in job logs for more details.

Restore and recovery of an Oracle 11g database using online redo logs may fail with the above error. The RMAN Output section of the job log reports the following:
 

 
RMAN-00571: ===================================
 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =
 
RMAN-00571: ==============================================
 
RMAN-03002: failure of alter db command at 07/29/2008
 
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
 

Cause

Backup Exec fails to open the Oracle 11g database that is in NOARCHIVELOG mode during restore.
 

Solution

Workaround:
 
Run either of the following commands from the SQLPlus prompt:
 
1. If the redo logs were valid and the recovery using redo logs was successful, run the command:
 
alter database open noresetlogs;
 
2. If the recover database command using redo logs failed, run the command:
 
alter database open resetlogs;
 

 
Veritas Corporation has acknowledged that the above-mentioned issue is present in the current version(s) of the product(s) mentioned at the end of this article. Veritas Corporation is committed to product quality and satisfied customers.
 
There are currently no plans to address this issue by way of a patch or hotfix in the current or previous versions of the software at the present time. This issue may be resolved in a future major revision of the software at a later time. However, this particular issue is not currently scheduled for any release. If you feel this issue has a direct business impact for you and your continued use of the product, please contact your Veritas Sales representative or the Veritas Sales group to discuss these concerns. For information on how to contact Veritas Sales, please see  https://www.veritas.com
 
Please be sure to refer back to this document periodically as any changes to the status of the issue will be reflected here.
 

Related Articles

Oracle/DB2 Agent: How to troubleshoot Oracle/DB2 backup or restore jobs which fail with the error "The Database script returned an error. Refer to the Database script output section in job logs for more details"

Was this content helpful?

Get Support