Subscribe

Clone Database Fails

Hi,

i would Clone a RAC Database 10.2.0.3 with SnapManager 2.2. I get folowing Error during Clone process!

--SMO-13032 FATAL: Cannot perform operation: Clone Create. Root cause: SMO-12201: Error executing SQL command: RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;, /tmp/SMO_DUMMY, CANCEL. The command returned: ORA-00279: Anderung 4302107571760, erstellt von 01/12/2009 00:44:23. Erforderlich fur Thread 1

ORA-00289: Vorschlag: +DATA_CLTOKDB/archive_logs/1_6090_654774054.dbf

ORA-00280: Anderung 4302107571760 fur Thread 1 in Sequenz #6090

ORA-00308: Archiviertes Log '/tmp/SMO_DUMMY' kann nicht geoffnet werden

ORA-27037: Dateistatus nicht abrufbar

ORA-01547: Warnung: RECOVER erfolgreich, doch OPEN RESETLOGS wurde folgenden Fehler ergeben

ORA-01195: Online-Backup der Datei 1 erfordert weiteres Recovery fur Konsistenz

ORA-01110: Datendatei 1: '+DATA_CLTOKDB/tokdb/datafile/system.286.654774071'

ORA-01112: Media Recovery nicht gestartet

Any Idea what happens?

Is it necessery that the Backup which is used for Clone are made in FULL OFFLINE mode not in FULL ONLINE Mode?

Our Backups are made in FULL ONLINE mode!

Thank you,

Bernhard Radl

Re: Clone Database Fails

SnapManager 2.2 for Oracle does not support localized environments completely.

Can you try this to force SQL*Plus to execute in the English locale when run by SMO?

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

NLS_LANG=American_America

export NLS_LANG

And then restart the SMO server:

  1. /etc/init.d/smo_server restart

If the login script (.bash_profile, .bashrc, .cshrc, or similar) for the Oracle user explicitly set NLS_LANG, you may need to edit them as well to not set NLS_LANG if it was already set.

Then try the clone operation again.

Re: Clone Database Fails

Thanks,

i have change the NLS_LANG in /etc/init.d/smo_server!

Now the Clone operation run successfull!

Best Regards

Re: Clone Database Fails

Thanks for the update.

Re: Clone Database Fails

Hi,

I have Snap Manager 3.0.1 on Sun Solaris 5.10.

I have change NLS_LANG but this don't resolve my problem

When I try to clone a DB from a backup I get this message:

--[ INFO] SMO-13046: Operation GUID 2c98a8f1232da31d01232da32f550001 starting on Profile SYUSTG0_LOLITA_SMO
--[ INFO] SMO-04030: Validating uniqueness of new SID "SMOT4".
--[ INFO] SMO-04040: Using ORACLE_HOME of "/opt/SMO_lolita/fs01/product/10.2.0" from clonespec for clone.
--[ INFO] SMO-04041: Using Oracle OS account "syustg0" from backup for clone.
--[ INFO] SMO-04043: Using Oracle OS group "dba" from backup for clone.
--[ INFO] SMO-07127: Locked database for SnapManager operations - created lock file "/opt/SMO_lolita/fs01/product/10.2.0/dbs/.sm_lock_SMOT4" on host patsy.
--[ INFO] SD-00025: Beginning to connect filesystem(s) [/opt/SMO_lolita/data01] from snapshot smo_syustg0_lolita_smo_smo_f_h_1_2c98a8f1232d8c5501232d8c74760001_0.
--[ INFO] SD-00016: Discovering storage resources for /opt/SMO_lolita/data01/SMOT4.
--[ INFO] SD-00017: Finished storage discovery for /opt/SMO_lolita/data01/SMOT4.
--[ INFO] SD-00026: Finished connecting filesystem(s) [/opt/SMO_lolita/data01] from snapshot smo_syustg0_lolita_smo_smo_f_h_1_2c98a8f1232d8c5501232d8c74760001_0.
--[ INFO] SD-00025: Beginning to connect filesystem(s) [/opt/SMO_lolita/data01] from snapshot smo_syustg0_lolita_smo_smo_f_h_2_2c98a8f1232d8c5501232d8c74760001_0.
--[ INFO] SD-00016: Discovering storage resources for /opt/NTAPsmo/mnt/-opt-SMO_lolita-data01-20090818151335333_0.
--[ INFO] SD-00017: Finished storage discovery for /opt/NTAPsmo/mnt/-opt-SMO_lolita-data01-20090818151335333_0.
--[ INFO] SD-00026: Finished connecting filesystem(s) [/opt/SMO_lolita/data01] from snapshot smo_syustg0_lolita_smo_smo_f_h_2_2c98a8f1232d8c5501232d8c74760001_0.
--[ INFO] ORACLE-00502: Adding entry for database SMOT4 in /var/opt/oracle/oratab.
--[ INFO] SMO-07300: Beginning clone of database "SMO" to SID "SMOT4" on host "patsy.unix.t-systems.it".
--[ INFO] SMO-07302: Generating parameter file for "SMOT4" at "/opt/SMO_lolita/fs01/product/10.2.0/dbs/initSMOT4.ora".
--[ INFO] SMO-07303: Generating password file for "SMOT4" at "/opt/SMO_lolita/fs01/product/10.2.0/dbs/orapwSMOT4".
--[ INFO] SMO-07304: Starting up database "SMOT4" in NOMOUNT mode.
--[ INFO] SMO-07305: Generating control files for database "SMOT4".
--[ INFO] SMO-07312: Create Control File - Database: SMOT4.
--[ INFO] SMO-07313: Create Control File - Redolog: /opt/SMO_lolita/data01_SMOT4/redo_3.log.
--[ INFO] SMO-07313: Create Control File - Redolog: /opt/SMO_lolita/data01_SMOT4/redo_2.log.
--[ INFO] SMO-07313: Create Control File - Redolog: /opt/SMO_lolita/data01_SMOT4/redo_1.log.
--[ INFO] SMO-07314: Create Control File - Datafile: /opt/SMO_lolita/data01/SMOT4/SMO/users01.dbf.
--[ INFO] SMO-07314: Create Control File - Datafile: /opt/SMO_lolita/data01/SMOT4/SMO/ts_smo_idx_01.dbf.
--[ INFO] SMO-07314: Create Control File - Datafile: /opt/SMO_lolita/data01/SMOT4/SMO/ts_smo_dat_01.dbf.
--[ INFO] SMO-07314: Create Control File - Datafile: /opt/SMO_lolita/data01/SMOT4/SMO/system01.dbf.
--[ INFO] SMO-07314: Create Control File - Datafile: /opt/SMO_lolita/data01/SMOT4/SMO/sysaux01.dbf.
--[ INFO] SMO-07314: Create Control File - Datafile: /opt/SMO_lolita/data01/SMOT4/SMO/undotbs01.dbf.
--[ INFO] SMO-07337: Recovering database clone "SMOT4" to a consistent point using archived logs from the backup.
--[ERROR] SMO-13032: Cannot perform operation: Clone Create.  Root cause: Could not lazily autowire field: private com.netapp.common.remote.RemoteObjectFactoryFactory com.netapp.oracle.jdbc.OracleConnectionFactory.remoteObjectFactoryFactory; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'remoteObjectFactoryFactory' defined in class path resource [operation-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: java.rmi.ConnectIOException: error during JRMP connection establishment; nested exception is:
    java.net.SocketTimeoutException: Read timed out
--[ INFO] SMO-07316: Shutting down database "SMOT4".
--[ INFO] SMO-07317: Deleting file "/opt/SMO_lolita/fs01/product/10.2.0/dbs/initSMOT4.ora".
--[ INFO] SMO-07317: Deleting file "/opt/SMOT4_lolita/fs01/product/10.2.0/admin/SMOT4/udump".
--[ INFO] SMO-07317: Deleting file "/opt/SMOT4_lolita/fs01/product/10.2.0/admin/SMOT4/bdump".
--[ INFO] SMO-07317: Deleting file "/opt/SMO_lolita/data01_SMOT4".
--[ INFO] SMO-07317: Deleting file "/opt/SMOT4_lolita/fs01/product/10.2.0/admin/SMOT4/cdump".
--[ INFO] SMO-07317: Deleting file "/opt/SMO_lolita/fs01/product/10.2.0/dbs/lkSMOT4".
--[ INFO] SMO-07317: Deleting file "/opt/SMO_lolita/fs01/product/10.2.0/dbs/hc_SMOT4.dat".
--[ INFO] SMO-07317: Deleting file "/opt/SMO_lolita/data01/SMOT4/control01.ctl".
--[ INFO] SMO-04038: Deleting now empty directory "/opt/SMOT4_lolita/fs01/product/10.2.0/admin/SMOT4"
--[ INFO] ORACLE-00503: Removing entry for database SMOT4 from /var/opt/oracle/oratab.
--[ INFO] SD-00031: Beginning to disconnect filesystem(s) [/opt/NTAPsmo/mnt/-opt-SMO_lolita-data01-20090818151335333_0].
--[ INFO] SD-00032: Finished disconnecting filesystem(s) [/opt/NTAPsmo/mnt/-opt-SMO_lolita-data01-20090818151335333_0].
--[ INFO] SD-00031: Beginning to disconnect filesystem(s) [/opt/SMO_lolita/data01/SMOT4].
--[ INFO] SD-00032: Finished disconnecting filesystem(s) [/opt/SMO_lolita/data01/SMOT4].
--[ INFO] SMO-07131: Unlocked database for SnapManager operations - removed lock file "/opt/SMO_lolita/fs01/product/10.2.0/dbs/.sm_lock_SMOT4" on host patsy.
--[ INFO] SMO-13039: Successfully aborted operation: Clone Create
--[ERROR] SMO-13048: Clone Create Operation Status: FAILED
--[ INFO] SMO-13049: Elapsed Time: 0:07:35.423

Re: Clone Database Fails

Hi,

There is an error message here stating you are having SMO-13032 as error code. I found the following for you.

https://now.netapp.com/Knowledgebase/solutionarea.asp?id=kb36606

Let us know how it went.

Ciao,

Eric