RMAN: Simular backup em fita
Sabe quando o Backup / Restore para fita está dando erro da MML, e o cara do TSM está falando que o erro é do RMAN?
O Oracle Database fornece uma API para simulação de uso da MML (Media Management Library), a oracle.disksbt, fazendo com que um diretório do servidor seja tratado como uma unidade de fita.
Ou seja, se na sua “fita” funcionar, e em outra não, a localização do problema está reduzida.
C:\Users\Portilho>md C:\temp\rman
C:\Users\Portilho>rman TARGET SYS/Nerv2013
Recovery Manager: Release 11.2.0.3.0 - Production on Tue Jul 30 10:19:44 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1340880489)
RMAN> RUN {
2> ALLOCATE CHANNEL CH01 DEVICE TYPE 'SBT_TAPE' PARMS="SBT_LIBRARY=oracle.disksb t, ENV=(BACKUP_DIR=C:\temp\rman)";
3> BACKUP DATABASE;
4> }
using target database control file instead of recovery catalog
allocated channel: CH01
channel CH01: SID=131 device type=SBT_TAPE
channel CH01: WARNING: Oracle Test Disk API
Starting backup at 30-JUL-13
channel CH01: starting full datafile backup set
channel CH01: specifying datafile(s) in backup set
input datafile file number=00006 name=C:\ORACLE\ORADATA\ORCL\DATAFILE\SOE01.DBF
input datafile file number=00001 name=C:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_SYSTEM_8Q125OKY_.DBF
input datafile file number=00002 name=C:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_SYSAUX_8Q125ORR_.DBF
input datafile file number=00005 name=C:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_EXAMPLE_8Q12J8QF_.DBF
input datafile file number=00003 name=C:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_UNDOTBS1_8Q125OXN_.DBF
input datafile file number=00004 name=C:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_USERS_8Q125P47_.DBF
channel CH01: starting piece 1 at 30-JUL-13
channel CH01: finished piece 1 at 30-JUL-13
piece handle=01og1ggs_1_1 tag=TAG20130730T102115 comment=API Version 2.0,MMS Version 8.1.3.0
channel CH01: backup set complete, elapsed time: 00:06:56
channel CH01: starting full datafile backup set
channel CH01: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel CH01: starting piece 1 at 30-JUL-13
channel CH01: finished piece 1 at 30-JUL-13
piece handle=02og1gtt_1_1 tag=TAG20130730T102115 comment=API Version 2.0,MMS Version 8.1.3.0
channel CH01: backup set complete, elapsed time: 00:00:04
Finished backup at 30-JUL-13
released channel: CH01
RMAN> EXIT;
Recovery Manager complete.
C:\Users\Portilho>dir C:\temp\rman
O volume na unidade C não tem nome.
O Número de Série do Volume é C070-B35F
Pasta de C:\temp\rman
30/07/2013 10:28 4.626.317.320 01og1ggs_1_1
30/07/2013 10:28 16.777.224 02 og1gtt_1_1
30/07/2013 10:28 3.264 Oracle_Disk_SBT_Catalog
3 arquivo(s) 4.643.097.808 bytes
2 pasta(s) 129.709.293.568 bytes disponíveis
C:\Users\Portilho>