Server initiated restore of Oracle database fail with an error "ORA-01033: ORACLE initialization or shutdown in progress"
| Article:TECH202099 | | | Created: 2013-01-28 | | | Updated: 2013-01-28 | | | Article URL http://www.symantec.com/docs/TECH202099 |
| NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made. |
Problem
Server initiated restore of Oracle database fail with an error "ORA-01033: ORACLE initialization or shutdown in progress"
The RMAN output will also show the following.
SQL*Plus: Release 11.2.0.3.0 Production on Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORA-03113: end-of-file on communication channel
Error
ORA-03113: end-of-file on communication channel
ORA-01033: ORACLE initialization or shutdown in progress
Environment
Backup Exec 2012
Oracle 11.2.0.3.0
RHEL 5.7 or 5.8
Solution
This issue is seen only with the Oracle Version 11.2.0.3.0.
Workaround:
The target database needs to manually put in Nomount state before running the restore job from Backup Exec. Please follow the following steps
- Connect to SQLPLUS and type the following commands
- Shutdown immediate
- Startup nomount
- SET DBID <Database ID>
- Run the restore job from Backup Exec.
Symantec 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. Symantec Corporation is committed to product quality and satisfied customers.
This issue is currently under investigation by Symantec Corporation. Pending the outcome of the investigation, this issue may be resolved by way of a patch or hotfix in current or future revisions of the software. 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 Symantec Sales representative or the Symantec Sales group to discuss these concerns. For information on how to contact Symantec Sales, please see http://www.symantec.com Please be sure to refer back to this document periodically as any changes to the status of the issue will be reflected here.
|
|
| Source | ETrack |
| Value | 3060777 |
| Description | Oracle version (11.2.0.3)server initiated restore is failing while brining the database in nomount state. |
Article URL http://www.symantec.com/docs/TECH202099
Terms of use for this information are found in Legal Notices
Thank you.