Pular para o conteúdo

› Fóruns › Banco de dados Oracle › Problemas com expdp › Problemas com expdp

7 de janeiro de 2011 às 2:26 pm #97584
Anônimo

    [quote=”CleitonHanzen”:1yb7m3xm]Opá…

    Sobre a queda do servidor e o banco não abrir, nem sempre o recover database é o mais indicado…. Por exemplo, se tiver algum datafile em modo backup e o banco cair, durante o startup irá pedir pra fazer media recover naquele datafile, mas o procedimento correto é desabilitar o backup do mesmo que o banco já irar subir normalmente….

    De qualquer jeito, posta o conteudo das ultimas 100/150 linhas do alert.log…[/quote]

    Entendi. Bem assim que o servidor ligou, tentei startar o banco, segue o log logo que demonstrou o problema:


    Thu Jan 6 17:17:32 2011
    Oracle Data Guard is not available in this edition of Oracle.
    Thu Jan 6 17:17:33 2011
    ALTER DATABASE MOUNT
    Thu Jan 6 17:17:37 2011
    Setting recovery target incarnation to 1
    Thu Jan 6 17:17:37 2011
    Successful mount of redo thread 1, with mount id 61615533
    Thu Jan 6 17:17:37 2011
    Database mounted in Exclusive Mode
    Completed: ALTER DATABASE MOUNT
    Thu Jan 6 17:17:37 2011
    ALTER DATABASE OPEN
    Thu Jan 6 17:17:38 2011
    Beginning crash recovery of 1 threads
    Thu Jan 6 17:17:38 2011
    Started redo scan
    Thu Jan 6 17:17:38 2011
    Completed redo scan
    13016 redo blocks read, 2270 data blocks need recovery
    Thu Jan 6 17:17:47 2011
    Started redo application at
    Thread 1: logseq 965, block 75374
    Thu Jan 6 17:17:47 2011
    Recovery of Online Redo Log: Thread 1 Group 2 Seq 965 Reading mem 0
    Mem# 0 errs 0: /opt/oracle/oradata/recon/redo02a.log
    Mem# 1 errs 0: /u02/oracle/oradata/recon/redo02b.log
    RECOVERY OF THREAD 1 STUCK AT BLOCK 55426 OF FILE 10
    Thu Jan 6 17:17:48 2011
    Aborting crash recovery due to error 1172
    Thu Jan 6 17:17:48 2011
    Errors in file /opt/oracle/admin/recon/udump/recon_ora_6597.trc:
    ORA-01172: recovery of thread 1 stuck at block 55426 of file 10
    ORA-01151: use media recovery to recover block, restore backup if needed
    ORA-1172 signalled during: ALTER DATABASE OPEN...
    Thu Jan 6 17:21:15 2011
    Shutting down instance: further logons disabled
    Thu Jan 6 17:21:15 2011
    Stopping background process CJQ0
    Thu Jan 6 17:21:15 2011
    Stopping background process MMNL
    Thu Jan 6 17:21:16 2011
    Stopping background process MMON
    Thu Jan 6 17:21:17 2011
    Shutting down instance (immediate)
    License high water mark = 3
    Thu Jan 6 17:21:17 2011
    Stopping Job queue slave processes
    Thu Jan 6 17:21:17 2011
    Job queue slave processes stopped
    Thu Jan 6 17:21:17 2011
    ALTER DATABASE CLOSE NORMAL
    ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
    Thu Jan 6 17:21:17 2011
    ALTER DATABASE DISMOUNT
    Completed: ALTER DATABASE DISMOUNT
    ARCH: Archival disabled due to shutdown: 1089
    Shutting down archive processes
    Archiving is disabled
    Archive process shutdown avoided: 0 active
    ARCH: Archival disabled due to shutdown: 1089
    Shutting down archive processes
    Archiving is disabled
    Archive process shutdown avoided: 0 active