19
ago
Cenário Corrupção de ControFile sem Backup (Rman / Rman Controlfile Autobackup) e sem Snapshot Controlfile. $ vim alertORCL log Sweep [inc2][105822]: completed Sweep [inc2][105805]: completed Wed Jul 31 14:13:23 2019 alter database mount Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_ckpt_5372 trc (incident=108158): ORA-00227: bloco danificado detectado no arquivo de controle: (bloco 1, num blocos 1) <<<<——– ORA-00202: arquivo de controle: ‘/u01/app/oracle/oradata/ORCL/control01 ctl’ <<<<——– Incident details in: /u01/app/oracle/diag/rdbms/orcl/ORCL/incident/incdir_108158/ORCL_ckpt_5372_i108158 trc Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_m000_5445 trc (incident=108303): ORA-00227: bloco danificado detectado no arquivo de controle: (bloco 1, n▒m blocos 1) <<<<——– ORA-00202: arquivo de controle: ‘/u01/app/oracle/fast_recovery_area/ORCL/control02 ctl’ <<<<——– — VAMOS VERIFICAR SE TEMOS UM SNAPSHOT DO CONTROLFILE NO ORACLE_HOME $ cd $ORACLE_HOME/dbs $ ls -la snap* total 0 — NAO TEMOS SNAPSHOT VAMOS VERIFICAR TEMOS O CONTROLFILE NO BACKUP DO RMAN […]
Leia Mais