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 4:33 pm #100477
mpvargas
Participante

    Fala Felipe,
    Alguns testes…

    Exclui do control file a tablespace de UNDO
    deu o seguinte erro

    SQL> @/u01/app/oracle/admin/asoec10/udump/cfile_asoec10.sql
    CREATE CONTROLFILE REUSE DATABASE “ASOEC10” NORESETLOGS ARCHIVELOG
    *
    ERROR at line 1:
    ORA-01503: CREATE CONTROLFILE failed
    ORA-01565: error in identifying file ‘/logs2/tbsasoec10/dados01/tbs01.dbf’
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3

    Apaguei todos os datafiles, deixei somente a tablespace que quero recuperar e dei o seguinte erro

    SQL> @/u01/app/oracle/admin/asoec10/udump/cfile2.sql
    CREATE CONTROLFILE REUSE DATABASE “ASOEC10” NORESETLOGS ARCHIVELOG
    *
    ERROR at line 1:
    ORA-01503: CREATE CONTROLFILE failed
    ORA-01189: file is from a different RESETLOGS than previous files
    ORA-01110: data file 28: ‘/logs2/tbsasoec10/uribeiro/urib.dbf’