Una buena práctica cuando tomamos un BACKUP HOT es hacer un RESTORE VALIDATE DATABASE, que chequea la integridad y consistencia de las piezas de backup generadas por RMAN, contra los datafiles, archivelogs que se encuentran en la base de datos y nos asegura que el restore correra sin problemas al momento de recrear el ambiente.
La sintaxis de ejecución es la siguiente:
run { restore validate database; }
Bien, ahora vamos a mostrar un ejemplo, que luego de tomar un BACKUP HOT, valido las piezas.
[oracle@efestionlx rman_database_backup]$ rman target / catalog=rman@catrman Recovery Manager: Release 10.2.0.4.0 - Production on Mon Mar 1 10:27:33 2010 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: MANUDB (DBID=1737311985) recovery catalog database Password: connected to recovery catalog database RMAN> restore validate database; Starting restore at 01-MAR-10 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=144 devtype=DISK channel ORA_DISK_1: starting validation of datafile backupset channel ORA_DISK_1: reading from backup piece /u03/rman_database_backup/20100301_MANUDB_DBID1737311985_s11067_p1_dbf channel ORA_DISK_1: restored backup piece 1 piece handle=/u03/rman_database_backup/20100301_MANUDB_DBID1737311985_s11067_p1_dbf tag=MANUDB_20100301.0715 channel ORA_DISK_1: validation complete, elapsed time: 00:20:37 channel ORA_DISK_1: starting validation of datafile backupset channel ORA_DISK_1: reading from backup piece /u03/rman_database_backup/20100301_MANUDB_DBID1737311985_s11066_p1_dbf channel ORA_DISK_1: restored backup piece 1 piece handle=/u03/rman_database_backup/20100301_MANUDB_DBID1737311985_s11066_p1_dbf tag=MANUDB_20100301.0715 channel ORA_DISK_1: validation complete, elapsed time: 00:26:46 Finished restore at 01-MAR-10 RMAN> quit Recovery Manager complete.
POSIBLES INCOVENIENTES
Puede ser que por políticas de backup o un script de mantenimiento, las piezas se muevan del path de origen, donde el RMAN registra sus piezas, el que definifimos por defecto en los scripts o en el catalogo mismo.
Entonces arrojara el error ORA-19870.
Este error aparecera cada vez que querramos validar una pieza que no este en su path de origen. Para ello debemos registrar las piezas nuevamente en el nuevo lugar de destino, o volver a ponerlas en su lugar.
En el caso que expongo no estan el path donde se catalogaron y vuelvo a mover las piezas al path de origen
RMAN> restore validate database; Starting restore at 01-MAR-10 starting full resync of recovery catalog full resync complete allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=142 devtype=DISK channel ORA_DISK_1: starting validation of datafile backupset channel ORA_DISK_1: reading from backup piece /u03/rman_database_backup/20100301_MANUDB_DBID1737311985_s11067_p1_dbf ORA-19870: error reading backup piece /u03/rman_database_backup/20100301_MANUDB_DBID1737311985_s11067_p1_dbf ORA-19505: failed to identify file "/u03/rman_database_backup/20100301_MANUDB_DBID1737311985_s11067_p1_dbf" ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 channel ORA_DISK_1: starting validation of datafile backupset channel ORA_DISK_1: reading from backup piece /u03/rman_database_backup/20100301_MANUDB_DBID1737311985_s11066_p1_dbf ORA-19870: error reading backup piece /u03/rman_database_backup/20100301_MANUDB_DBID1737311985_s11066_p1_dbf ORA-19505: failed to identify file "/u03/rman_database_backup/20100301_MANUDB_DBID1737311985_s11066_p1_dbf" ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 failover to previous backup RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 03/01/2010 10:26:19 RMAN-06026: some targets not found - aborting restore RMAN-06023: no backup or copy of datafile 10 found to restore RMAN-06023: no backup or copy of datafile 9 found to restore RMAN-06023: no backup or copy of datafile 8 found to restore RMAN-06023: no backup or copy of datafile 7 found to restore RMAN-06023: no backup or copy of datafile 6 found to restore RMAN-06023: no backup or copy of datafile 5 found to restore RMAN-06023: no backup or copy of datafile 4 found to restore RMAN-06023: no backup or copy of datafile 3 found to restore RMAN-06023: no backup or copy of datafile 2 found to restore RMAN-06023: no backup or copy of datafile 1 found to restore Recovery Manager complete.
En el caso que represento, es el escenario en el que estamos ajustados con el storage de la base y esto nos obliga immediatamente a comprimir las piezas que serán subidas a TSM. Asi mismo verifico que las piezas creadas no existen.
Las muevo y ejecuto exitosamente la operación.
[oracle@efestionlx bin]$ cd /u03/rman_database_backup/ [oracle@efestionlx rman_database_backup]$ ls -lth total 135G -rw-r--r-- 1 oracle oinstall 8.6G Mar 1 08:59 20100301.0845.TECPRO.sdat2104lx.tar.gz -rw-r--r-- 1 oracle oinstall 6.8K Mar 1 08:13 MANUDB_20100301.0715.log -rw-r--r-- 1 oracle oinstall 15G Mar 1 08:06 20100301.0745.MANUDB.sdat2104lx.tar.gz -rw-r--r-- 1 oracle oinstall 2.6K Mar 1 07:13 MANUDB_20100301.0712.log -rw-r----- 1 oracle oinstall 5.8K Mar 1 01:48 TECPRO_20100301.0100.log -rw-r----- 1 oracle oinstall 2.6K Mar 1 01:01 MANUDB_20100301.0100.log -rw-r----- 1 oracle oinstall 5.8K Feb 25 01:49 TECPRO_20100225.0100.log -rw-r----- 1 oracle oinstall 2.6K Feb 25 01:01 MANUDB_20100225.0100.log -rw-r--r-- 1 oracle oinstall 12G Feb 22 08:00 20100222.0745.MANUDB.sdat2104lx.tar.gz -rw-r----- 1 oracle oinstall 5.8K Feb 22 02:06 MANUDB_20100222.0100.log -rw-r----- 1 oracle oinstall 5.8K Feb 22 01:52 TECPRO_20100222.0100.log
Efectivamente las piezas del backup que tome no se encuentran ! Las busco en el path de respaldo y la encuentro.
[oracle@efestionlx rman_database_backup]$ cd resguardo/ [oracle@efestionlx resguardo]$ ls 20100301_MANUDB_DBID1737311985_s11066_p1_dbf 20100301_MANUDB_DBID1737311985_s11068_p1_dbf 20100301_MANUDB_DBID1737311985_s11070_p1_ctl 20100301_MANUDB_DBID1737311985_s11067_p1_dbf 20100301_MANUDB_DBID1737311985_s11069_p1_dbf
Con un simple mv alcanzara.
[oracle@efestionlx resguardo]$ mv * ../resguardo [oracle@efestionlx rman_database_backup]$ ls 20100222.0745.MANUDB.sdat2104lx.tar.gz 20100301.0745.MANUDB.sdat2104lx.tar.gz 20100301_MANUDB_DBID1737311985_s11068_p1_dbf 20100301_MANUDB_DBID1737311985_s11069_p1_dbf 20100301_MANUDB_DBID1737311985_s11070_p1_ctl 20100301_MANUDB_DBID1737311985_s11067_p1_dbf 20100301_MANUDB_DBID1737311985_s11066_p1_dbf MANUDB_20100225.0100.log MANUDB_20100301.0715.log 20100301.0845.TECPRO.sdat2104lx.tar.gz TECPRO_20100222.0100.log MANUDB_20100301.0100.log TECPRO_20100225.0100.log MANUDB_20100301.0712.log TECPRO_20100301.0100.log MANUDB_20100222.0100.log
Ejecuto nuevamente y la validacion finaliza correctamente, no solo por que haya movido las piezas, si no también a que la integridad de datos es correcta.
Nos vemos pronto.
Hola Juan,
Disculpa mi atrevimiento, pero quisiera ver si tu me puedes ayudar, mira tengo la siguiente situación quiero realizar un duplicate de una BD de produccion a otro server, con la finalidad de probar si funcionan los respaldos que tengo en cinta sin embargo, me está enviando un error similar al que dices solo k en este caso es de cinta,
Alguna idea…? El servidor de cinta es un Veritas Netbackup 6.5
Recovery Manager: Release 10.2.0.4.0 – Production on Wed Jun 30 11:49:34 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: GWMTEST (DBID=2441012372)
auxiliary database Password:
connected to auxiliary database: GWMTEST (not mounted)
RMAN> RUN {
allocate auxiliary CHANNEL ch00 TYPE ‘SBT_TAPE’;
SEND ‘NB_ORA_CLIENT=mxtom9kh1200dzc’;
DUPLICATE TARGET DATABASE TO gwmtest;
RELEASE CHANNEL ch00;
}2> 3> 4> 5> 6>
using target database control file instead of recovery catalog
allocated channel: ch00
channel ch00: sid=153 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle – Release 6.5 (2007072323)
sent command to channel: ch00
Starting Duplicate Db at 30-JUN-10
contents of Memory Script:
{
set newname for datafile 1 to
“/u01/sq/ora_1/admin/gwmtest/df/system01.dbf”;
set newname for datafile 2 to
“/u01/sq/ora_1/admin/gwmtest/df/undotbs01.dbf”;
set newname for datafile 3 to
“/u01/sq/ora_1/admin/gwmtest/df/sysaux01.dbf”;
set newname for datafile 4 to
“/u01/sq/ora_1/admin/gwmtest/df/users01.dbf”;
restore
check readonly
clone database
;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 30-JUN-10
channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/sq/ora_1/admin/gwmtest/df/system01.dbf
restoring datafile 00004 to /u01/sq/ora_1/admin/gwmtest/df/users01.dbf
channel ch00: reading from backup piece bk_u0flhha38_s15_p1_t723036264
ORA-19870: error reading backup piece bk_u0flhha38_s15_p1_t723036264
ORA-19507: failed to retrieve sequential file, handle=”bk_u0flhha38_s15_p1_t723036264″, parms=””
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Failed to process backup file
channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /u01/sq/ora_1/admin/gwmtest/df/undotbs01.dbf
restoring datafile 00003 to /u01/sq/ora_1/admin/gwmtest/df/sysaux01.dbf
channel ch00: reading from backup piece bk_u0glhha38_s16_p1_t723036264
ORA-19870: error reading backup piece bk_u0glhha38_s16_p1_t723036264
ORA-19507: failed to retrieve sequential file, handle=”bk_u0glhha38_s16_p1_t723036264″, parms=””
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Failed to process backup file
failover to previous backup
channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /u01/sq/ora_1/admin/gwmtest/df/undotbs01.dbf
restoring datafile 00003 to /u01/sq/ora_1/admin/gwmtest/df/sysaux01.dbf
channel ch00: reading from backup piece bk_u09lgahep_s9_p1_t721765849
ORA-19870: error reading backup piece bk_u09lgahep_s9_p1_t721765849
ORA-19507: failed to retrieve sequential file, handle=”bk_u09lgahep_s9_p1_t721765849″, parms=””
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Failed to process backup file
channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/sq/ora_1/admin/gwmtest/df/system01.dbf
restoring datafile 00004 to /u01/sq/ora_1/admin/gwmtest/df/users01.dbf
channel ch00: reading from backup piece bk_u08lgahep_s8_p1_t721765849
ORA-19870: error reading backup piece bk_u08lgahep_s8_p1_t721765849
ORA-19507: failed to retrieve sequential file, handle=”bk_u08lgahep_s8_p1_t721765849″, parms=””
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Failed to process backup file
failover to previous backup
channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/sq/ora_1/admin/gwmtest/df/system01.dbf
restoring datafile 00004 to /u01/sq/ora_1/admin/gwmtest/df/users01.dbf
channel ch00: reading from backup piece bk_u03lg7u3p_s3_p1_t721680505
ORA-19870: error reading backup piece bk_u03lg7u3p_s3_p1_t721680505
ORA-19507: failed to retrieve sequential file, handle=”bk_u03lg7u3p_s3_p1_t721680505″, parms=””
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Failed to process backup file
channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /u01/sq/ora_1/admin/gwmtest/df/undotbs01.dbf
restoring datafile 00003 to /u01/sq/ora_1/admin/gwmtest/df/sysaux01.dbf
channel ch00: reading from backup piece bk_u04lg7u3p_s4_p1_t721680505
ORA-19870: error reading backup piece bk_u04lg7u3p_s4_p1_t721680505
ORA-19507: failed to retrieve sequential file, handle=”bk_u04lg7u3p_s4_p1_t721680505″, parms=””
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Failed to process backup file
failover to previous backup
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/30/2010 12:03:08
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found – aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
Cualquier ayuda, de antemano gracias.
LikeLike
Liliana,
Buenas Tardes, te comento que el error se muestra puede ser por los sigueinetes motivos:
1) Cuando vosa tomas un backup, el registro se guarda en el control file, por hecho si por ejemplo lo tomas en el /u03/backup del otro lado del server tenes que tener los mismos paths.
Ahora bien, que pasa cuando no existen esos paths y no se pueden crear. Hay que catalogar la piezas en el rman, antes de lanzar el script de duplicate.
2) Otro problema pueden ser permisos. pasame el log que se encuentra en el path /netbackup/logs/user_ops cuando te devuelve el error ORA-27029: skgfrtrv: sbtrestore returned error asi puedo ver, si la falla no esta por ese lado. Por que el problema puede ser tambien que el usuario oracle no tenga permisos para leer el archivo libobk de veritas.
Cordiales saludos !
LikeLike
Hola Buen dia , perdon si te molesta pero quiero ver si me podrias ayudar, estoy intentando instalar oracle 11g release 2 en un servidor con windows server 2008 y quiero instalar la base de datos en un dispositivo NAS con un RAID 1+0 pero al momento de crear la base me muetra los siguientes errores:
ORA-19624: fallo de la operacion; reintento permitido
ORA-19870: error al restaurar parte de la copia de seguridad C:\APP\ORACLESBD1_INSTALL\PRODUCT\11.2.0\DBHOME_1\ASSISTANTS\DBCA\TEMPLATES\SEED_DATABASE.DFB
ORA-19504: fallo al crear el archivo “\\10.8.7.100\E$\INB\SYSTEM01.DBF”
ORA-27040: error de creacion de archivo, no se ha podido crear
OSD-04002: no se ha podido abrir el archivo
Espero me puedas ayudar, muchas gracias
Saludos!
LikeLike
podrias buscar en el log de asm o mostrarme algun log de discos ???
Los comando de asm te muestran montados los discos ??
Los discos los usas montados en file system bajo que nombre de unidad ??
Un saludo.
Juan Andres
LikeLike
Antes que nada agradecerte por responder, estoy tratando de instalar el software de Oracle en una unidad C de un servidor bajo windows server 2008 R2, y la base de datos la quiero instalar en una unidad de red como File System, no como ASM, ya agregue la unidad de red de la NAS en el servidor y en el explorador la visualizo como unidad E, puedo escribir sobre la unidad sin ningun problema con el usuario que trato de instalar el software, no se si me falte algun permiso especial para instalar Oracle o alguna configuracion de la NAS, te adjunto los logs de oracle espero sean de utilidad, muchas gracias:
ARCHIVO CloneRmanRestore.txt:
Instancia ORACLE iniciada.
Total System Global Area 1,3696E+10 bytes
Fixed Size 2188768 bytes
Variable Size 6878661152 bytes
Database Buffers 6777995264 bytes
Redo Buffers 37044224 bytes
20130226 07:03:12
Allocating device….
Specifying datafiles…
Specifing datafiles…
Restoring …
declare
*
ERROR en línea 1:
ORA-19624: fallo de la operacion; reintento permitido
ORA-19870: error al restaurar parte de la copia de seguridad C:\APP\ORACLESBD1_INSTALL\PRODUCT\11.2.0\DBHOME_1\ASSISTANTS\DBCA\TEMPLATES\SEED_DATABASE.DFB
ORA-19504: fallo al crear el archivo “\\10.8.7.100\E$\INB\SYSTEM01.DBF”
ORA-27040: error de creacion de archivo, no se ha podido crear
OSD-04002: no se ha podido abrir el archivo
O/S-Error: (OS 5) Acceso denegado.
ORA-06512: en “SYS.X$DBMS_BACKUP_RESTORE”, linea 5816
ORA-06512: en linea 16
ARCHIVO trace.txt
[Thread-39] [ 2013-02-26 19:06:59.582 CST ] [CloneDBCreationStep.executeImpl:381] a.createCtlFileSql = Create controlfile reuse set database “inb”
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
‘//10.8.7.100/e$\{DB_UNIQUE_NAME}\SYSTEM01.DBF’,
‘//10.8.7.100/e$\{DB_UNIQUE_NAME}\SYSAUX01.DBF’,
[Thread-39] [ 2013-02-26 19:06:59.582 CST ] [CloneDBCreationStep.executeImpl:385] b.createCtlFileSql = Create controlfile reuse set database “inb”
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
‘//10.8.7.100/e$\{DB_UNIQUE_NAME}\SYSTEM01.DBF’,
‘//10.8.7.100/e$\{DB_UNIQUE_NAME}\SYSAUX01.DBF’,
‘//10.8.7.100/e$\{DB_UNIQUE_NAME}\UNDOTBS01.DBF’,
[Thread-39] [ 2013-02-26 19:06:59.582 CST ] [CloneDBCreationStep.executeImpl:397] createCtl=Create controlfile reuse set database “inb”
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
‘//10.8.7.100/e$\{DB_UNIQUE_NAME}\SYSTEM01.DBF’,
‘//10.8.7.100/e$\{DB_UNIQUE_NAME}\SYSAUX01.DBF’,
‘//10.8.7.100/e$\{DB_UNIQUE_NAME}\UNDOTBS01.DBF’,
‘//10.8.7.100/e$\{DB_UNIQUE_NAME}\USERS01.DBF’,
[Thread-39] [ 2013-02-26 19:06:59.582 CST ] [CloneDBCreationStep.executeImpl:404] crtCtl=Create controlfile reuse set database “inb”
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
‘//10.8.7.100/e$\{DB_UNIQUE_NAME}\SYSTEM01.DBF’,
‘//10.8.7.100/e$\{DB_UNIQUE_NAME}\SYSAUX01.DBF’,
‘//10.8.7.100/e$\{DB_UNIQUE_NAME}\UNDOTBS01.DBF’,
‘//10.8.7.100/e$\{DB_UNIQUE_NAME}\USERS01.DBF’
[Thread-39] [ 2013-02-26 19:06:59.582 CST ] [CloneDBCreationStep.executeImpl:419] Length of OriginalRedoLogsGrNames=3
[Thread-39] [ 2013-02-26 19:06:59.582 CST ] [CloneDBCreationStep.executeImpl:427] 0th redoLogText = GROUP 1 (‘//10.8.7.100/e$\{DB_UNIQUE_NAME}\redo01.log’) SIZE 51200K
[Thread-39] [ 2013-02-26 19:06:59.582 CST ] [CloneDBCreationStep.executeImpl:427] 1th redoLogText = GROUP 2 (‘//10.8.7.100/e$\{DB_UNIQUE_NAME}\redo02.log’) SIZE 51200K
[Thread-39] [ 2013-02-26 19:06:59.582 CST ] [CloneDBCreationStep.executeImpl:427] 2th redoLogText = GROUP 3 (‘//10.8.7.100/e$\{DB_UNIQUE_NAME}\redo03.log’) SIZE 51200K
[Thread-39] [ 2013-02-26 19:06:59.582 CST ] [CloneDBCreationStep.executeImpl:448] createCTLSql=Create controlfile reuse set database “inb”
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
‘//10.8.7.100/e$\inb\SYSTEM01.DBF’,
‘//10.8.7.100/e$\inb\SYSAUX01.DBF’,
‘//10.8.7.100/e$\inb\UNDOTBS01.DBF’,
‘//10.8.7.100/e$\inb\USERS01.DBF’
LOGFILE GROUP 1 (‘//10.8.7.100/e$\inb\redo01.log’) SIZE 51200K,
GROUP 2 (‘//10.8.7.100/e$\inb\redo02.log’) SIZE 51200K,
GROUP 3 (‘//10.8.7.100/e$\inb\redo03.log’) SIZE 51200K RESETLOGS;
[Thread-39] [ 2013-02-26 19:07:00.253 CST ] [SQLEngine.done:2167] Done called
[Thread-39] [ 2013-02-26 19:07:00.253 CST ] [SQLEngine.spoolOff:2013] Setting spool off = C:\app\OracleSBD1_install\cfgtoollogs\dbca\inb\cloneDBCreation.log
[Thread-39] [ 2013-02-26 19:07:00.253 CST ] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@cf546f8
oracle.sysman.assistants.util.step.StepExecutionException: ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file ‘//10.8.7.100/e$\inb\SYSTEM01.DBF’
ORA-27041: unable to open file
at oracle.sysman.assistants.dbca.backend.CloneDBCreationStep.executeImpl(CloneDBCreationStep.java:949)
at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)
at java.lang.Thread.run(Thread.java:595)
[Thread-39] [ 2013-02-26 19:07:00.971 CST ] [SQLEngine.done:2167] Done called
[Thread-39] [ 2013-02-26 19:07:00.971 CST ] [Host.createStepSQLInterface:7124] sid =inb
[Thread-39] [ 2013-02-26 19:07:00.971 CST ] [Host.createStepSQLInterface:7125] sidOrConnectString inb
[Thread-39] [ 2013-02-26 19:07:00.971 CST ] [OracleHome.getVersion:880] OracleHome.getVersion called. Current Version: null
[Thread-39] [ 2013-02-26 19:07:00.971 CST ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
[Thread-39] [ 2013-02-26 19:07:00.971 CST ] [OracleHome.getVersion:899] Homeinfo C:\app\OracleSBD1_install\product\11.2.0\dbhome_1,5
[Thread-39] [ 2013-02-26 19:07:01.220 CST ] [OracleHome.getVersion:925] OracleHome.server.getVersion Version: 11.2.0.1.0
[Thread-39] [ 2013-02-26 19:07:01.220 CST ] [OracleHome.getVersion:946] Current Version From Inventory: 11.2.0.1.0
[Thread-39] [ 2013-02-26 19:07:01.220 CST ] [OracleHome.getVersion:951] using sqlplus: C:\app\OracleSBD1_install\product\11.2.0\dbhome_1\bin\sqlplus.exe
[Thread-39] [ 2013-02-26 19:07:01.220 CST ] [OracleHome.getVersion:880] OracleHome.getVersion called. Current Version: 11.2.0.1.0
[Thread-39] [ 2013-02-26 19:07:01.220 CST ] [OracleHome.getVersion:946] Current Version From Inventory: 11.2.0.1.0
[Thread-39] [ 2013-02-26 19:07:01.220 CST ] [OracleHome.getVersion:951] using sqlplus: C:\app\OracleSBD1_install\product\11.2.0\dbhome_1\bin\sqlplus.exe
[Thread-39] [ 2013-02-26 19:07:01.220 CST ] [OracleHome.getVersion:880] OracleHome.getVersion called. Current Version: 11.2.0.1.0
[Thread-39] [ 2013-02-26 19:07:01.220 CST ] [OracleHome.getVersion:946] Current Version From Inventory: 11.2.0.1.0
[Thread-39] [ 2013-02-26 19:07:01.220 CST ] [OracleHome.getVersion:951] using sqlplus: C:\app\OracleSBD1_install\product\11.2.0\dbhome_1\bin\sqlplus.exe
[Thread-39] [ 2013-02-26 19:07:01.220 CST ] [SQLPlusEngine.getCmmdParams:222] m_home 11.2.0.1.0
[Thread-39] [ 2013-02-26 19:07:01.220 CST ] [SQLPlusEngine.getCmmdParams:223] version > 112 true
[Thread-39] [ 2013-02-26 19:07:01.220 CST ] [OsUtilsBase.getBaseFromOrabase:602] oraBaseUtility C:\app\OracleSBD1_install\product\11.2.0\dbhome_1\bin\orabase.exe
[Thread-39] [ 2013-02-26 19:07:01.220 CST ] [OsUtilsBase.getBaseFromOrabase:611] cmds: C:\app\OracleSBD1_install\product\11.2.0\dbhome_1\bin\orabase.exe
[Thread-39] [ 2013-02-26 19:07:01.252 CST ] [OsUtilsBase.getBaseFromOrabase:616] baseLocation from orabase
Oracle home environment variable not set
[Thread-39] [ 2013-02-26 19:07:01.252 CST ] [OsUtilsBase.getBaseFromOrabase:641] orabaseLocation= null
[Thread-39] [ 2013-02-26 19:07:01.267 CST ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
[Thread-39] [ 2013-02-26 19:07:01.267 CST ] [InventoryUtil.getHomeName:111] homeName = OraDb11g_home5
[Thread-39] [ 2013-02-26 19:07:01.267 CST ] [OsUtilsBase.getOracleHomeKeyImpl:979] getting home key for home name: OraDb11g_home5
[Thread-39] [ 2013-02-26 19:07:01.267 CST ] [OsUtilsBase.getRegistryEntry:1021] hklmKey while getting registry entryHKEY_LOCAL_MACHINE
[Thread-39] [ 2013-02-26 19:07:01.267 CST ] [OsUtilsBase.getRegistryEntry:1022] keyToSet while getting registry entrySOFTWARE\ORACLE\KEY_OraDb11g_home5
[Thread-39] [ 2013-02-26 19:07:01.267 CST ] [SQLEngine.getEnvParams:562] NLS_LANG: AMERICAN_AMERICA.AL32UTF8
[Thread-39] [ 2013-02-26 19:07:01.267 CST ] [SQLEngine.initialize:322] Execing SQLPLUS/SVRMGR process…
[Thread-39] [ 2013-02-26 19:07:01.267 CST ] [SQLEngine.initialize:359] m_bReaderStarted: false
[Thread-39] [ 2013-02-26 19:07:01.267 CST ] [SQLEngine.initialize:363] Starting Reader Thread…
[Thread-39] [ 2013-02-26 19:07:01.314 CST ] [CloneRmanRestoreStep.cancel:617] Cleaning up partially extracted files failed
[Thread-39] [ 2013-02-26 19:07:01.408 CST ] [SQLEngine.done:2167] Done called
[Thread-39] [ 2013-02-26 19:07:01.408 CST ] [CloneRmanRestoreStep.cancel:632] RMAN cleanup failed
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01507: database not mounted
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeQuery(SQLEngine.java:828)
at oracle.sysman.assistants.dbca.backend.CloneRmanRestoreStep.generateCancelScript(CloneRmanRestoreStep.java:839)
at oracle.sysman.assistants.dbca.backend.CloneRmanRestoreStep.cancel(CloneRmanRestoreStep.java:627)
at oracle.sysman.assistants.util.step.StepContext$ModeRunner.cancel(StepContext.java:2760)
at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2722)
at java.lang.Thread.run(Thread.java:595)
[Thread-39] [ 2013-02-26 19:07:01.408 CST ] [OsUtilsBase.deleteFile:1797] OsUtilsBase.deleteFile: //10.8.7.100/e$\inb\SYSTEM01.DBF
[Thread-39] [ 2013-02-26 19:07:01.423 CST ] [OsUtilsBase.deleteFile:1797] OsUtilsBase.deleteFile: //10.8.7.100/e$\inb\SYSAUX01.DBF
[Thread-39] [ 2013-02-26 19:07:01.423 CST ] [OsUtilsBase.deleteFile:1797] OsUtilsBase.deleteFile: //10.8.7.100/e$\inb\UNDOTBS01.DBF
[Thread-39] [ 2013-02-26 19:07:01.423 CST ] [OsUtilsBase.deleteFile:1797] OsUtilsBase.deleteFile: //10.8.7.100/e$\inb\USERS01.DBF
[Thread-39] [ 2013-02-26 19:07:01.423 CST ] [CloneDBCreationStep.cancel:1003] CloneDBCreationStep.cancel(): nodeList= null
[Thread-39] [ 2013-02-26 19:07:01.423 CST ] [SQLEngine.reInitialize:735] Reinitializing SQLEngine…
[Thread-39] [ 2013-02-26 19:07:01.423 CST ] [OracleHome.getVersion:880] OracleHome.getVersion called. Current Version: 11.2.0.1.0
[Thread-39] [ 2013-02-26 19:07:01.423 CST ] [OracleHome.getVersion:946] Current Version From Inventory: 11.2.0.1.0
[Thread-39] [ 2013-02-26 19:07:01.423 CST ] [OracleHome.getVersion:951] using sqlplus: C:\app\OracleSBD1_install\product\11.2.0\dbhome_1\bin\sqlplus.exe
[Thread-39] [ 2013-02-26 19:07:01.423 CST ] [OracleHome.getVersion:880] OracleHome.getVersion called. Current Version: 11.2.0.1.0
[Thread-39] [ 2013-02-26 19:07:01.423 CST ] [OracleHome.getVersion:946] Current Version From Inventory: 11.2.0.1.0
[Thread-39] [ 2013-02-26 19:07:01.423 CST ] [OracleHome.getVersion:951] using sqlplus: C:\app\OracleSBD1_install\product\11.2.0\dbhome_1\bin\sqlplus.exe
[Thread-39] [ 2013-02-26 19:07:01.423 CST ] [OracleHome.getVersion:880] OracleHome.getVersion called. Current Version: 11.2.0.1.0
[Thread-39] [ 2013-02-26 19:07:01.423 CST ] [OracleHome.getVersion:946] Current Version From Inventory: 11.2.0.1.0
[Thread-39] [ 2013-02-26 19:07:01.423 CST ] [OracleHome.getVersion:951] using sqlplus: C:\app\OracleSBD1_install\product\11.2.0\dbhome_1\bin\sqlplus.exe
[Thread-39] [ 2013-02-26 19:07:01.423 CST ] [SQLPlusEngine.getCmmdParams:222] m_home 11.2.0.1.0
[Thread-39] [ 2013-02-26 19:07:01.423 CST ] [SQLPlusEngine.getCmmdParams:223] version > 112 true
[Thread-39] [ 2013-02-26 19:07:01.423 CST ] [OsUtilsBase.getBaseFromOrabase:602] oraBaseUtility C:\app\OracleSBD1_install\product\11.2.0\dbhome_1\bin\orabase.exe
[Thread-39] [ 2013-02-26 19:07:01.423 CST ] [OsUtilsBase.getBaseFromOrabase:611] cmds: C:\app\OracleSBD1_install\product\11.2.0\dbhome_1\bin\orabase.exe
[Thread-39] [ 2013-02-26 19:07:01.470 CST ] [OsUtilsBase.getBaseFromOrabase:616] baseLocation from orabase
Oracle home environment variable not set
[Thread-39] [ 2013-02-26 19:07:01.470 CST ] [OsUtilsBase.getBaseFromOrabase:641] orabaseLocation= null
[Thread-39] [ 2013-02-26 19:07:01.470 CST ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
[Thread-39] [ 2013-02-26 19:07:01.470 CST ] [InventoryUtil.getHomeName:111] homeName = OraDb11g_home5
[Thread-39] [ 2013-02-26 19:07:01.470 CST ] [OsUtilsBase.getOracleHomeKeyImpl:979] getting home key for home name: OraDb11g_home5
[Thread-39] [ 2013-02-26 19:07:01.470 CST ] [OsUtilsBase.getRegistryEntry:1021] hklmKey while getting registry entryHKEY_LOCAL_MACHINE
[Thread-39] [ 2013-02-26 19:07:01.470 CST ] [OsUtilsBase.getRegistryEntry:1022] keyToSet while getting registry entrySOFTWARE\ORACLE\KEY_OraDb11g_home5
[Thread-39] [ 2013-02-26 19:07:01.470 CST ] [SQLEngine.getEnvParams:562] NLS_LANG: AMERICAN_AMERICA.AL32UTF8
[Thread-39] [ 2013-02-26 19:07:01.470 CST ] [SQLEngine.initialize:322] Execing SQLPLUS/SVRMGR process…
[Thread-39] [ 2013-02-26 19:07:01.470 CST ] [SQLEngine.initialize:359] m_bReaderStarted: false
[Thread-39] [ 2013-02-26 19:07:01.470 CST ] [SQLEngine.initialize:363] Starting Reader Thread…
[Thread-39] [ 2013-02-26 19:07:01.486 CST ] [SQLEngine.initialize:412] Waiting for m_bReaderStarted to be true
[Thread-39] [ 2013-02-26 19:07:02.515 CST ] [Oradim.getRemoveEntryCommand:481] Execing C:\app\OracleSBD1_install\product\11.2.0\dbhome_1\bin\oradim.exe -delete -sid INB
[Thread-39] [ 2013-02-26 19:07:04.652 CST ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
[Thread-39] [ 2013-02-26 19:07:04.652 CST ] [InventoryUtil.getHomeName:111] homeName = OraDb11g_home5
[Thread-39] [ 2013-02-26 19:07:04.668 CST ] [OsUtilsBase.getOracleHomeKeyImpl:979] getting home key for home name: OraDb11g_home5
[Thread-39] [ 2013-02-26 19:07:04.668 CST ] [OsUtilsBase.getRegistryEntry:1021] hklmKey while getting registry entryHKEY_LOCAL_MACHINE
[Thread-39] [ 2013-02-26 19:07:04.668 CST ] [OsUtilsBase.getRegistryEntry:1022] keyToSet while getting registry entrySOFTWARE\ORACLE\KEY_OraDb11g_home5
[Thread-39] [ 2013-02-26 19:07:04.668 CST ] [OsUtilsBase.removeRegistryEntry:1065] Exeption while adding registry value oracle.sysman.oii.oiil.OiilNativeException: InvalidKey
[Thread-39] [ 2013-02-26 19:07:04.668 CST ] [OsUtilsBase.deleteFile:1797] OsUtilsBase.deleteFile: C:\app\OracleSBD1_install\product\11.2.0\dbhome_1\database\PWDinb.ora
[Thread-39] [ 2013-02-26 19:07:04.668 CST ] [OsUtilsBase.deleteFile:1797] OsUtilsBase.deleteFile: C:\app\OracleSBD1_install\product\11.2.0\dbhome_1\database\initinb.ora
[Thread-39] [ 2013-02-26 19:07:04.668 CST ] [OsUtilsBase.deleteFile:1797] OsUtilsBase.deleteFile: C:\app\OracleSBD1_install\admin\inb\pfile\init.ora
[Thread-39] [ 2013-02-26 19:07:04.668 CST ] [CloneDBCreationStep.cancel:1044] CloneDBCreationStep.cancel(): bRaw=false
[Thread-39] [ 2013-02-26 19:07:04.668 CST ] [OsUtilsBase.deleteFile:1797] OsUtilsBase.deleteFile: //10.8.7.100/e$\inb\SYSTEM01.DBF
[Thread-39] [ 2013-02-26 19:07:04.668 CST ] [OsUtilsBase.deleteFile:1797] OsUtilsBase.deleteFile: //10.8.7.100/e$\inb\SYSAUX01.DBF
[Thread-39] [ 2013-02-26 19:07:04.668 CST ] [OsUtilsBase.deleteFile:1797] OsUtilsBase.deleteFile: //10.8.7.100/e$\inb\UNDOTBS01.DBF
[Thread-39] [ 2013-02-26 19:07:04.668 CST ] [OsUtilsBase.deleteFile:1797] OsUtilsBase.deleteFile: //10.8.7.100/e$\inb\USERS01.DBF
[Thread-39] [ 2013-02-26 19:07:04.668 CST ] [OsUtilsBase.deleteFile:1797] OsUtilsBase.deleteFile: //10.8.7.100/e$\inb\redo01.log
[Thread-39] [ 2013-02-26 19:07:04.668 CST ] [OsUtilsBase.deleteFile:1797] OsUtilsBase.deleteFile: //10.8.7.100/e$\inb\redo02.log
[Thread-39] [ 2013-02-26 19:07:04.668 CST ] [OsUtilsBase.deleteFile:1797] OsUtilsBase.deleteFile: //10.8.7.100/e$\inb\redo03.log
[Thread-39] [ 2013-02-26 19:07:04.668 CST ] [OsUtilsBase.deleteFile:1797] OsUtilsBase.deleteFile: //10.8.7.100/e$\inb\control01.ctl
[Thread-39] [ 2013-02-26 19:07:04.668 CST ] [OsUtilsBase.deleteFile:1797] OsUtilsBase.deleteFile: C:\app\OracleSBD1_install\flash_recovery_area\inb\control02.ctl
[Thread-39] [ 2013-02-26 19:07:04.699 CST ] [SQLEngine.done:2167] Done called
LikeLike