When Oracle Going Down

So what? when you at the night found your Oracle was dead. Trying start Oracle but occuring the error messages:

Thu Aug 30 21:43:16 2007
Errors in file /data/oracle/home/admin/pep/bdump/pep_arc0_31074.trc:
ORA-16014: log 1 sequence# 56 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/data/oracle/data/pep/redo01.log'

Thu Aug 30 21:44:16 2007
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 56 (4)

Thu Aug 30 21:48:17 2007
Errors in file /data/oracle/home/admin/pep/bdump/pep_arc1_31076.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.

Thu Aug 30 21:48:17 2007

************************************************************************

You have following choices to free up space from flash 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.

************************************************************************

Thu Aug 30 21:48:17 2007

Errors in file /data/oracle/home/admin/pep/bdump/pep_arc1_31076.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 48500736 bytes disk space from 2147483648 limit

ARC1: Error 19809 Creating archive log file to '/data/oracle/home/flash_recovery_area/PEP/archivelog/2007_08_30/o1_mf_1_56_1_.arc'

ARC1: Failed to archive thread 1 sequence 56 (19809)

ARCH: Archival stopped, error occurred. Will continue retrying

DONT WORRY

You just make Oracle can be startup and then rebuild your configuration by RESIZE your Archive Log file. The steps are :

[oracle@black]# sqlplus /nolog
SQL> conn / as sysdba
SQL> shutdown abort
ORACLE instance shut down.

SQL> startup nomount pfile="/data/oracle/home/admin/pep/pfile/init.ora.618200774625"
ORACLE instance started.

Total System Global Area 1002438656 bytes
Fixed Size 1223080 bytes
Variable Size 247465560 bytes
Database Buffers 746586112 bytes
Redo Buffers 7163904 bytes

SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.

SQL> select * from tab;

Browse : http://your.oracle.web:1158/em/
Please resize your Archive log file and or the other configuraions.