Pular para o conteúdo

› Fóruns › Banco de dados Oracle › CREATE CONTROLFILE failed › CREATE CONTROLFILE failed

6 de setembro de 2010 às 11:04 pm #95950
ortiz
Participante

    oi,
    acontece que a base esta com erro e estou tratando de carregar ela
    no linux usando controlfile set. mas ela agora esta amostrando o seguinte erro.

    eu coloco o listado de datafiles no controlfile como e normal, mas esta com erro na leitura do SYSTEM.

    ORA-01565: error in identifying file ‘/usr/ORACLE/data/system01.dbf’
    ORA-27047: unable to read the header block of file
    Additional information: 2

    processo:

    STARTUP NOMOUNT PFILE=/software/app/admin/bdcarga/pfile/init.ora.85201024130
    CREATE CONTROLFILE SET DATABASE AHARCHI RESETLOGS NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 29
    LOGFILE
    GROUP 1 ‘/usr/ORACLE/data/redo01.log’ SIZE 100M,
    GROUP 2 ‘/usr/ORACLE/data/redo02.log’ SIZE 100M
    — STANDBY LOGFILE
    DATAFILE
    ‘/usr/ORACLE/data/system01.dbf’,
    ‘/usr/ORACLE/data/tools01.dbf’,
    ‘/usr/ORACLE/data/temp01.dbf’,
    ‘/usr/ORACLE/data/temp02.dbf’,
    ‘/usr/ORACLE/data/temp03.dbf’,
    ‘/usr/ORACLE/data/users01.dbf’,
    ‘/usr/ORACLE/data/users02.dbf’,
    ‘/usr/ORACLE/data/rbs01.dbf’,
    ‘/usr/ORACLE/data/rbs02.dbf’,
    ‘/usr/ORACLE/data/rbs03.dbf’,
    CHARACTER SET US7ASCII
    ;

    a maquina era HP-UX e agora e Linuc RH5
    obrigado.