ORA-19815, ORA-16038, ORA-19809, ORA-00312

Found these above errors in alert log..?

ORA-19815, ORA-16038, ORA-19809, ORA-00312

Database hung..?

Database crashes immediately after startup..?




### Check your alert log for this parameter:


log_archive_dest_1         = "LOCATION=USE_DB_RECOVERY_FILE_DEST"
db_recovery_file_dest      = "D:\ARCHIVELOG"

db_recovery_file_dest_size = 16201108K


### pfile : Increase the value by atleast 1GB.

db_recovery_file_dest_size = 17201108K


SQL> startup

Done.

==========================================================

Further like to delete old archivelogs, proceed below

==========================================================

C:\Users\userIT>rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Sun Jan 13 12:58:17 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ROSE (DBID=575541292)

RMAN> delete archivelog all completed before "sysdate-1"; 

### decide upto which archivelog to delete.

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=13 device type=DISK
List of Archived Log Copies for database with db_unique_name ROSE
==============================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
307     1    657     A 11-JAN-13
Name: D:\ARCHIVELOG\2013_01_11\O1_MF_1_657_8H0R9QG0_.ARC

308     1    658     A 11-JAN-13
Name: D:\ARCHIVELOG\2013_01_12\O1_MF_1_658_8H0ZCK66_.ARC

309     1    659     A 12-JAN-13
Name: D:\ARCHIVELOG\2013_01_12\O1_MF_1_659_8H1F745J_.ARC


Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=D:\ARCHIVELOG\2013_01_11\O1_MF_1_657_8H0R9QG0_.ARC RECID=307 STAMP=804463209
deleted archived log
archived log file name=D:\ARCHIVELOG\2013_01_12\O1_MF_1_658_8H0ZCK66_.ARC RECID=308 STAMP=804470434
deleted archived log
archived log file name=D:\ARCHIVELOG\2013_01_12\O1_MF_1_659_8H1F745J_.ARC RECID=309 STAMP=804484629
Deleted 3 objects


#### If you already deleted archivelogs manually using OS command, proceed with crosscheck...


RMAN> crosscheck archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=13 device type=DISK
validation failed for archived log
archived log file name=D:\ARCHIVELOG\2013_01_12\O1_MF_1_660_8H32D135_.ARC RECID=310 STAMP=804539058
validation failed for archived log
archived log file name=D:\ARCHIVELOG\2013_01_13\O1_MF_1_661_8H50RVPF_.ARC RECID=311 STAMP=804602956
validation failed for archived log
archived log file name=D:\ARCHIVELOG\2013_01_13\O1_MF_1_662_8H50S035_.ARC RECID=312 STAMP=804602961
validation failed for archived log
archived log file name=D:\ARCHIVELOG\2013_01_13\O1_MF_1_663_8H50S2B9_.ARC RECID=313 STAMP=804602964
Crosschecked 4 objects


RMAN> delete expired archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=13 device type=DISK
List of Archived Log Copies for database with db_unique_name ROSE
==============================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
310     1    660     X 12-JAN-13
Name: D:\ARCHIVELOG\2013_01_12\O1_MF_1_660_8H32D135_.ARC

311     1    661     X 12-JAN-13
Name: D:\ARCHIVELOG\2013_01_13\O1_MF_1_661_8H50RVPF_.ARC

312     1    662     X 12-JAN-13
Name: D:\ARCHIVELOG\2013_01_13\O1_MF_1_662_8H50S035_.ARC

313     1    663     X 12-JAN-13
Name: D:\ARCHIVELOG\2013_01_13\O1_MF_1_663_8H50S2B9_.ARC


Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=D:\ARCHIVELOG\2013_01_12\O1_MF_1_660_8H32D135_.ARC RECID=310 STAMP=804539058
deleted archived log
archived log file name=D:\ARCHIVELOG\2013_01_13\O1_MF_1_661_8H50RVPF_.ARC RECID=311 STAMP=804602956
deleted archived log
archived log file name=D:\ARCHIVELOG\2013_01_13\O1_MF_1_662_8H50S035_.ARC RECID=312 STAMP=804602961
deleted archived log
archived log file name=D:\ARCHIVELOG\2013_01_13\O1_MF_1_663_8H50S2B9_.ARC RECID=313 STAMP=804602964
Deleted 4 EXPIRED objects



Done.