Pular para o conteúdo

› Fóruns › Banco de dados Oracle › Erro rman – created file already exists › Erro rman – created file already exists

24 de agosto de 2011 às 5:44 pm #100483
mpvargas
Participante

    SQL> ALTER DATABASE RENAME FILE ‘/backup/tbsasoec10/uribeiro/uribeiro.dbf’ TO ‘/logs2/tbsasoec10/uribeiro/uribeiro.dbf’;
    ALTER DATABASE RENAME FILE ‘/backup/tbsasoec10/uribeiro/uribeiro.dbf’ TO ‘/logs2/tbsasoec10/uribeiro/uribeiro.dbf’
    *
    ERROR at line 1:
    ORA-01511: error in renaming log/data files
    ORA-01141: error renaming data file 28 – new file
    ‘/logs2/tbsasoec10/uribeiro/uribeiro.dbf’ not found
    ORA-01110: data file 28: ‘/backup/tbsasoec10/uribeiro/uribeiro.dbf’
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3

    Pensei o seguinte
    E se eu dropar essa base e criar uma nova e tentar restaurar o RMAN novamente…
    Ou copiar esse datafile que estou querendo recuperar para o local descrito no controlfile