topic Re: Problem on recovering Oracle Database with smo 3.2 on Windows 2008 R2 in Data Protection

Problem on recovering Oracle Database with smo 3.2 on Windows 2008 R2

sysadmin — Thu, 05 Jun 2025 06:11:43 GMT

Hi All

Here is our Platform:

OS: Windows 2008 R2

DB: Oracle 11.2.0.3.0 -> nls_territory:SWITZERLAND -> nls_language: GERMAN

SMO: 3.2

Storage: FAS 2040 Version 8.1.2 7Mode

We can take backups but the restore/recovery breaks up with errors (see extract of error log further down).

Can anybody help me?

Thank you.

--[ INFO] SM0-03081: Perform recovery using all connected backups F_H_20130117075838MEZ

--[ INFO] ORACLE-30023: Beginning batch recovery process for database FCS.

--[ INFO] ORACLE-30008: Beginning recovery process for database FCS.

--[ INFO] ORACLE-30010: Database recovery point objective: earliest consistent point

--[ERROR] EXE-00005: Cannot read input stream from spawned process for command [ RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL PARALLEL 1;]. Error: [Assertion failed] - this expression must be true

--[ERROR] EXE-00003: Killing spawned process for command: [ RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL PARALLEL 1;]

--[ INFO] SM0-03055: Disconnecting backup F_H_20130117075838MEZ.

--[ INFO] SD-00031: Beginning to disconnect filesystem(s) [C:\SnapManager_auto_mounts\S-20130117104856588_0].

--[ INFO] SD-00032: Finished disconnecting filesystem(s) [C:\SnapManager_auto_mounts\S-20130117104856588_0].

--[ERROR] SMO-13032: Cannot perform operation: Backup Restore. Root cause: com.netapp.oracle.platform.SQLPlusOracleException: ORACLE-00001: Error executing SQL: [ RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL PARALLEL 1;]. The command returned:

SQL*Plus: Release 11.2.0.3.0 Production on Do Jan 17 10:49:15 2013

SQL> Connect durchgeführt.

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> ORA-00279: Änderung 97177493934, erstellt von 01/17/2013 07:58:44. Erforderlich für Thread 1

--[ INFO] SMO-07131: Unlocked database for SnapManager operations - removed lock file "C:\oracle\product\11.2.0\dbhome_3\database\.sm_lock_FCS_TEST.TOGEWA.COM" on host CSVDB011.

--[ INFO] SMO-07433: Returning the database to its initial state: Database[FCS(OPEN)], Service[RUNNING].

--[ INFO] ORACLE-20000: Changing state for database instance FCS from MOUNTED to OPEN.

--[ WARN] SMO-07434: Could not return database to its original state. Error: ORACLE-20001: Error trying to change state to OPEN for database instance FCS: ORACLE-20004: Expecting to be able to open the database without the RESETLOGS option, but oracle is reporting that the database needs to be opened with the RESETLOGS option. To keep from unexpectedly resetting the logs, the process will not continue. Please ensure that the database can be opened without the RESETLOGS option and try again.

--[ INFO] SMO-13039: Successfully aborted operation: Backup Restore

--[ERROR] SMO-13048: Backup Restore Operation Status: FAILED

--[ INFO] SMO-22002: Successfully recorded the Backup Restore operation in history.

--[ INFO] SMO-14557: Sending E-Mail notification...

--[ INFO] SMO-14558: E-Mail notification sent successfully.

--[ INFO] SMO-13049: Elapsed Time: 2:41:22.683

Re: Problem on recovering Oracle Database with smo 3.2 on Windows 2008 R2

himanshp — Wed, 23 Jan 2013 09:43:19 GMT

Hello,

SnapManager for Oracle is not supported in non-English language environments. You must set the language of Oracle database to English.

Add the following commands under the initial comments in /etc/init.d/smo_server file:

NLS_LANG=American_America

export NLS_LANG

NLS_TERRITORY=America

export NLS_TERRITORY

Restart the SnapManager server using the following command:

/etc/init.d/smo_server restart

Please note if the login scripts such as .bash_profile, .bashrc, and .cshrc for the Oracle user is set to NLS_LANG, you must edit the script to not overwrite NLS_LANG.

Regards,

Himanshu

Re: Problem on recovering Oracle Database with smo 3.2 on Windows 2008 R2

himanshp — Wed, 23 Jan 2013 09:46:33 GMT

Sorry i missed to notice that it is a windows environment. You must do the following in windows environment:

Add the following commands under the initial comments in "C:\program files\Netapp\smo\smo_server" file:

NLS_LANG=American_America

export NLS_LANG

NLS_TERRITORY=America

export NLS_TERRITORY

Restart the SnapManager server using the following command:

C:\program files\Netapp\smo\smo_server restart

If system environment variables is set to NLS_LANG, you must edit the script to not overwrite NLS_LANG.

Thanks,

Himanshu

Re: Problem on recovering Oracle Database with smo 3.2 on Windows 2008 R2

sysadmin — Wed, 23 Jan 2013 09:52:58 GMT

Hi Himanshu

Thank you for your feedback but I can't find such a file as "smo_server".

Cheers,

Murat

Re: Problem on recovering Oracle Database with smo 3.2 on Windows 2008 R2

himanshp — Wed, 23 Jan 2013 12:09:50 GMT

Murat,

Can you please set the parameters NLS_LANGUAGE and NLS_TERRITORY in Oracle database and attempt the SMO operations again.

Regards,

Himanshu

Re: Problem on recovering Oracle Database with smo 3.2 on Windows 2008 R2

sysadmin — Wed, 23 Jan 2013 14:26:56 GMT

I'm not allowed to change any parameters in the DB.

Would it also work if I set these parameters in the SMO wrapper as I still can't find the smo_server file on the WIN 2008 R2 machine?

Re: Problem on recovering Oracle Database with smo 3.2 on Windows 2008 R2

sysadmin — Tue, 16 Apr 2013 08:41:51 GMT

Hi All

I have solved this problem myself.

You need to add the file string "wrapper.env=NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1" in to the file "wrapper.conf" and restart the service.

Re: Problem on recovering Oracle Database with smo 3.2 on Windows 2008 R2

ldenegri — Mon, 13 Oct 2014 13:00:41 GMT

to set the language to English on windows SMO add the follwowing line to 'wrapper.conf':

set.NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252

and restart the Netapp SMO service

Luca