Após executar o comando abaixo
UPDATE TEST_RANDOM SET FAIXA = 'media' WHERE SAL > 3000 AND SAL <=7000
Máquina ficou por mais de 1 hora executando e não terminou, abri uma sessão no SQLPLUS e executei o shutdown abort, após isso não conecto nem com o SYSDBA
Segue alert log:
Errors in file C:\APP\ORACLE\diag\rdbms\orcl1\orcl1\trace\orcl1_tt00_3416.trc: ORA-19809: limite excedido para arquivos de recupera├º├úo ORA-19804: n├úo ├® poss├¡vel reivindicar 209715200 bytes de espa├ºo em disco do limite de 1073741824 bytes Errors in file C:\APP\ORACLE\diag\rdbms\orcl1\orcl1\trace\orcl1_ora_9364.trc: ORA-19815: ADVERT├èNCIA: db_recovery_file_dest_size de 1073741824 bytes ├® 99.79% usado e tem 2204672 bytes restantes dispon├¡veis.
You have following choices to free up space from recovery area:
- Consider changing RMAN RETENTION POLICY. If you are using Data Guard, then consider changing RMAN ARCHIVELOG DELETION POLICY.
- Back up files to tertiary device such as tape using RMAN BACKUP RECOVERY AREA command.
- Add disk space and increase db_recovery_file_dest_size parameter to reflect the new space.
- Delete unnecessary files using RMAN DELETE command. If an operating system command was used to delete files, then use RMAN CROSSCHECK and DELETE EXPIRED commands.
