Senhores, estou tentando restaurar um backup de 1 ano atrás em um novo host.
OE 11gR2
- Depois de realizar as configurações padrões de diretório, entre outras
coisas, configurei o CATALOGO e a minha dúvida é na realização do restore do
controlfile, database e do recover.
RMAN> list backup of controlfile;
BS Key Type LV Size Device Type Elapsed Time Completion Time
--- -- -- --- ---
1423631 Full 85.50M SBT_TAPE 00:00:07 28-DEC-14
BP Key: 1423633 Status: AVAILABLE Compressed: NO Tag:
BACKUP_HOT_ANUAL
Handle: full_XUXA_anual_20587_867457903_3bpr8mrf_1 Media: 54152
Keep: BACKUP_LOGS Until: 17-DEC-16
Control File Included: Ckp SCN: 754085311743 Ckp time: 28-DEC-14
BS Key Type LV Size Device Type Elapsed Time Completion Time
--- -- -- --- ---
1423651 Full 85.50M SBT_TAPE 00:00:09 28-DEC-14
BP Key: 1423653 Status: AVAILABLE Compressed: NO Tag:
BACKUP_ANUAL_XUXA_CF
Handle: XUXA_867457928_20588_1 Media: 54153
Keep: NOLOGS Until: 17-DEC-16
Control File Included: Ckp SCN: 754085311825 Ckp time: 28-DEC-14
RMAN> backup of database;
BS Key Type LV Size Device Type Elapsed Time Completion Time
--- -- -- --- ---
1423563 Full 9.16G SBT_TAPE 00:12:01 28-DEC-14
BP Key: 1423567 Status: AVAILABLE Compressed: NO Tag:
BACKUP_HOT_ANUAL
Handle: full_XUXA_anual_20583_867456663_37pr8lkn_1 Media: 54158
Keep: BACKUP_LOGS Until: 17-DEC-16
List of Datafiles in backup set 1423563
File LV Type Ckp SCN Ckp Time Name
-- -- -
4 Full 754085258214 28-DEC-14 /u02/XUXA/datafile/.dbf
5 Full 754085258214 28-DEC-14 /u02/XUXA/datafile/.dbf
.
BS Key Type LV Size Device Type Elapsed Time Completion Time
--- -- -- --- ---
1423564 Full 19.60G SBT_TAPE 00:20:18 28-DEC-14
BP Key: 1423568 Status: AVAILABLE Compressed: NO Tag:
BACKUP_HOT_ANUAL
Handle: full_XUXA_anual_20584_867456663_38pr8lkn_1 Media: 54159
Keep: BACKUP_LOGS Until: 17-DEC-16
List of Datafiles in backup set 1423564
File LV Type Ckp SCN Ckp Time Name
-- -- -
1 Full 754085258215 28-DEC-14 /u02/XUXA/datafile/.dbf
2 Full 754085258215 28-DEC-14 /u02/XUXA/datafile/.dbf
3 Full 754085258215 28-DEC-14 /u02/XUXA/datafile/.dbf..
Tentei realizar o seguinte comando para restaurar o controlfile:
RMAN> run {
ALLOCATE CHANNEL C1 TYPE 'SBT_TAPE' PARMS 'ENV=(TDPO_OPTFILE=xxx.opt)';
set until time to_date('dd/mm/', '28/12/2014');restore controlfile from
autobackup;
}
O RMAN sai procurando, mas não acha.channel C1: looking for AUTOBACKUP on day:
20141214
channel C1: looking for AUTOBACKUP on day: 20141213
channel C1: looking for AUTOBACKUP on day: 20141212
channel C1: looking for AUTOBACKUP on day: 20141211
channel C1: looking for AUTOBACKUP on day: 20141210
channel C1: looking for AUTOBACKUP on day: 20141209
channel C1: looking for AUTOBACKUP on day: 20141208
Alguém pode ajudar a disponibilizar o comando correto, para restaurar esse
controlfile, os datafiles e o recover?
** Obs: Os formats entre outras observações em relação há ambientes
heterogêneos pode ser ignorado, irei adaptar o script.