2 Replies Latest reply: Jul 6, 2012 10:11 AM by 947888 RSS

    Unable to start DB, log file full?

    947888
      All,

      I am familiar with SQL Server, but Oracle is quite different, and I am a newbie. I have a test database running on a Windows VM, and I logged on yesterday to find the Database was "Open but unavailable." One of my coworkers rebooted the VM, and now it is shutdown. When I attempt to startup the database, it fails with a 3113: End of file communication error. When I look at the alert log, it seems to indicate that my recovery file destination is full. I have read on how to clean up those archives, or even extend the size, however none of those commands will execute because the database is not started. Seems like I am in a catch 22. I can't startup my DB because the log files are full, but can't delete the log files because the DB isn't started.

      Below is the alert.log file. What am I missing here? How can I get clear out my log files or at least increase the size?

      Errors in file c:\app\administrator\diag\rdbms\ora01brs\ora01brs\trace\ora01brs_ora_2460.trc:
      ORA-19815: WARNING: db_recovery_file_dest_size of 4102029312 bytes is 100.00% used, and has 0 remaining bytes available.
      ************************************************************************
      You have following choices to free up space from recovery area:
      1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
      then consider changing RMAN ARCHIVELOG DELETION POLICY.
      2. Back up files to tertiary device such as tape using RMAN
      BACKUP RECOVERY AREA command.
      3. Add disk space and increase db_recovery_file_dest_size parameter to
      reflect the new space.
      4. 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.
      ************************************************************************
      Errors in file c:\app\administrator\diag\rdbms\ora01brs\ora01brs\trace\ora01brs_ora_2460.trc:
      ORA-19809: limit exceeded for recovery files
      ORA-19804: cannot reclaim 44483072 bytes disk space from 4102029312 limit
      ARCH: Error 19809 Creating archive log file to 'C:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORA01BRS\ARCHIVELOG\2012_07_06\O1_MF_1_148_%U_.ARC'
      Errors in file c:\app\administrator\diag\rdbms\ora01brs\ora01brs\trace\ora01brs_ora_2460.trc:
      ORA-16038: log 1 sequence# 148 cannot be archived
      ORA-19809: limit exceeded for recovery files
      ORA-00312: online log 1 thread 1: 'O:\ORADATA\ORA01BRS\REDO01.LOG'
      USER (ospid: 2460): terminating the instance due to error 16038