Cenário: EE 12.1.0.2.0OEL 6.5 standloneInstance em shutdown Me deparei com um cenário que o cliente não tem backup (físico, lógico, hot, cold, full, incremental, anything), também não possui nenhum plano de contigência... Pois bem, tentei realizar o seguinte procedimento:
1- Criei um pfile a partir do spfile 2 - alterei o paramentro undo_management para manual 3 - startup mount usando o pfile criado e alterado 4 - coloquei o datafile de UNDO em modo offline drop 5 - Quando tento abrir a base, para depois dropar a tablespace e criar outra, me gera o seguinte erro: ERROR at line 1:ORA-01092: ORACLE instance terminated. Disconnection forcedORA-00604: error occurred at recursive SQL level 2ORA-00376: file 4 cannot be read at this timeORA-01110: data file 4:'/u01/app/oracle/oradata/<INTANCE_NAME>/datafile/o1_mf_undotbs1_d2kfszv2_.dbf'Process ID: 5030Session ID: 237 Serial number: 55395 Também já realizei o procedimento antes de tentar abrir o database, mandei um shutdown immediate para baixar a instancia de forma sincronizada, e repeti os passos, porém também sem sucesso. O mesmo erro é gerado. Alert.log Errors in file /u01/app/oracle/diag/rdbms/instance_name/instance_name/trace/cdb1_ora_5264.trc:ORA-00604: error occurred at recursive SQL level 2ORA-00376: file 4 cannot be read at this timeORA-01110: data file 4: '/u01/app/oracle/oradata/instance_name/datafile/o1_mf_undotbs1_d2kfszv2_.dbf'Sun Nov 13 16:19:14 2016Errors in file /u01/app/oracle/diag/rdbms/instance_name/instance_name/trace/cdb1_ora_5264.trc:ORA-00604: error occurred at recursive SQL level 2ORA-00376: file 4 cannot be read at this timeORA-01110: data file 4: '/u01/app/oracle/oradata/instance_name/datafile/o1_mf_undotbs1_d2kfszv2_.dbf'Error 604 happened during db open, shutting down databaseUSER (ospid: 5264): terminating the instance due to error 604Sun Nov 13 16:19:15 2016Instance terminated by USER, pid = 5264ORA-1092 signalled during: alter database open...opiodr aborting process unknown ospid (5264) as a result of ORA-1092Sun Nov 13 16:19:16 2016ORA-1092 : opitsk aborting process trace *** 2016-11-13 16:19:14.442DDE rules only execution for: ORA 1110----- START Event Driven Actions Dump -------- END Event Driven Actions Dump --------- START DDE Actions Dump -----Executing SYNC actions----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----Successfully dispatched----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) -----Executing ASYNC actions----- END DDE Actions Dump (total 0 csec) -----ORA-00604: error occurred at recursive SQL level 2ORA-00376: file 4 cannot be read at this timeORA-01110: data file 4: '/u01/app/oracle/oradata/CDB1/datafile/o1_mf_undotbs1_d2kfszv2_.dbf'ORA-00604: error occurred at recursive SQL level 2ORA-00376: file 4 cannot be read at this timeORA-01110: data file 4: '/u01/app/oracle/oradata/CDB1/datafile/o1_mf_undotbs1_d2kfszv2_.dbf' Se alguém tiver alguma idéia de como ainda tentar resolver esse problma eu agradeceria