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
$ sqlplus / as sysdba
SQL> create pfile from spfile;
$ cat initORCL ora | grep db_recovery_file_dest=
* db_recovery_file_dest='/u01/app/oracle/fast_recovery_area/ORCL'
$ cd /u01/app/oracle/fast_recovery_area/ORCL/backupset/
$ ls -la
total 0
-- NAO TEMOS BACKUP RMAN SERÁ NECESSÁRIO RECRIAR O CONTROLFILE
Recriando Controlfile
$ sqlplus / as sysdba
SQL> startup nomount;
SQL>
CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 2073
LOGFILE
GROUP 1 ('/u01/app/oracle/oradata/ORCL/redo01 log') SIZE 50M,
GROUP 2 ('/u01/app/oracle/oradata/ORCL/redo02 log') SIZE 50M,
GROUP 3 ('/u01/app/oracle/oradata/ORCL/redo03 log') SIZE 50M
DATAFILE
...
Leia Mais