Pular para o conteúdo

Fóruns Banco de dados Oracle Restore database Restore database

#96112
Sousa04
Participante

    alguém tem alguma idéia do que fazer??

    o banco é noarchivelog

    RMAN> alter database open
    2> ;

    RMAN-03002: failure of alter db command at 09/16/2010 17:14:03
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: ‘/sistema/oradata/DWDEFESA/datafile/o1_mf_system_4gq1sfyq_.dbf’

    RMAN> recover datafile 1;

    Starting recover at 16/09/2010
    using channel ORA_DISK_1

    starting media recovery

    unable to find archive log
    archive log thread=1 sequence=28909
    RMAN-00571:
    RMAN-03002: failure of recover command at 09/16/2010 17:14:56
    RMAN-06054: media recovery requesting unknown log: thread 1 seq 28909 lowscn 21266592822

    help!!!!