SITUAÇÃO ATUAL

RMAN> LIST INCARNATION OF DATABASE;

BASE DE DESENVOLVIMENTO (ONDE FOI RESTAURADO O RMAN)

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time

58308 58316 PROD 3134296087 PARENT 1 22-OCT-05
58308 58309 PROD 3134296087 PARENT 525876 15-AUG-11
58308 60881 PROD 3134296087 ORPHAN 2506203016 29-AUG-11
58308 60841 PROD 3134296087 CURRENT 2881391922 25-APR-12

BASE DE PRODUÇÃO

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time

61333 61341 PROD 3134296087 PARENT 1 22-OCT-05
61333 61334 PROD 3134296087 CURRENT 525876 15-AUG-11

SELECT * FROM v$log_history; (Ultimas linhas)

 RECID      STAMP    THREAD#  SEQUENCE# FIRST_CHANGE# FIRST_TIM NEXT_CHANGE#

RESETLOGS_CHANGE# RESETLOGS

  4368  781578537          1       4368    2884137850 26-APR-12   2884193086
       525876 15-AUG-11

  4369  781583456          1       4369    2884193086 26-APR-12   2884214358
       525876 15-AUG-11

  4370  781589253          1       4370    2884214358 26-APR-12   2884219663
       525876 15-AUG-11