Menu de navegação

[Edgar Rombesso RisolaParticipante]

Boa tarde galera….como faço para restaurar um backup full do rman de uma data específica? por exemplo…ao listar os backups tenho segmento abaixo…e queria restaurar o backup do dia 06 de fevereiro.

RMAN> list backup;

using target database control file instead of recovery catalog

List of Backup Sets
===================

BS Key Size Device Type Elapsed Time Completion Time
——- ———- ———– ———— —————
1 6.27G DISK 00:09:38 21-FEB-14
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20140221T132737
Piece Name: /usr/app/oracle/product/10g/dbs/01p169ea_1_1

List of Archived Logs in backup set 1
Thrd Seq Low SCN Low Time Next SCN Next Time
—- ——- ———- ——— ———- ———
1 1 1 29-JAN-14 106294 29-JAN-14
1 2 106294 29-JAN-14 173322 29-JAN-14
1 3 173322 29-JAN-14 223689 29-JAN-14
1 4 223689 29-JAN-14 273993 29-JAN-14
1 5 273993 29-JAN-14 317606 29-JAN-14
1 6 317606 29-JAN-14 326343 29-JAN-14
1 7 326343 29-JAN-14 616064 29-JAN-14
1 8 616064 29-JAN-14 1060717 29-JAN-14
1 9 1060717 29-JAN-14 1509140 29-JAN-14
1 10 1509140 29-JAN-14 1856601 29-JAN-14
1 11 1856601 29-JAN-14 2091362 29-JAN-14
1 12 2091362 29-JAN-14 2352761 29-JAN-14
1 13 2352761 29-JAN-14 2626525 29-JAN-14
1 14 2626525 29-JAN-14 3228520 29-JAN-14
1 15 3228520 29-JAN-14 3571483 29-JAN-14
1 16 3571483 29-JAN-14 4058920 29-JAN-14
1 17 4058920 29-JAN-14 4274020 29-JAN-14
1 18 4274020 29-JAN-14 4576090 30-JAN-14
1 19 4576090 30-JAN-14 4650587 30-JAN-14
1 20 4650587 30-JAN-14 4656372 30-JAN-14
1 21 4656372 30-JAN-14 4661396 30-JAN-14
1 22 4661396 30-JAN-14 4799059 01-FEB-14
1 23 4799059 01-FEB-14 5046623 06-FEB-14
1 24 5046623 06-FEB-14 5228416 10-FEB-14
1 25 5228416 10-FEB-14 5396324 13-FEB-14
1 26 5396324 13-FEB-14 5574947 17-FEB-14
1 27 5574947 17-FEB-14 5740787 21-FEB-14
1 28 5740787 21-FEB-14 5741843 21-FEB-14

[Regis AraujoParticipante]

@Edgar

Bom dia!

Basta adicionar a linha UNTIL TIME ou UNTIL SCN no seu restore…

UNTIL SCN ;

Ou

UNTIL TIME “TO_DATE(’06/02/2014 23:59:59′,’DD/MM/YYYY HH24:MI:SS’)”;

Abraços..!

Regis Araujo

[Autor]

Posts