| Database hang due to ArchiveLog full [message #586184] |
Tue, 04 June 2013 06:04  |
 |
wegadnie
Messages: 2
Registered: June 2013
Location: Ho Chi Minh
|
Junior Member |
|
|
Hi all,
I am new to forum so please bear with me.
Just now my database is hang due to the archivelog full. I try to use RMAN to delete the expired one and free space but encounter the error:
RMAN>crosscheck archivelog all;
archive log filename=/geodata/oraclelog/archive_log/ORAGF45/archivelog/2013_06_04/o1_mf_1_1444_8tsxvwc2_.arc recid=1350 stamp=817182450
validation succeeded for archived log
archive log filename=/geodata/oraclelog/archive_log/ORAGF45/archivelog/2013_06_04/o1_mf_1_1445_8ttx2q6j_.arc recid=1351 stamp=817214416
Crosschecked 1351 objects
RMAN> delete expired archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=244 devtype=DISK
specification does not match any archive log in the recovery catalog
RMAN>
So I try to back it up first by using the below command:
RMAN> backup archivelog all;
Starting backup at 04-JUN-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=592 recid=498 stamp=757252810
channel ORA_DISK_1: starting piece 1 at 04-JUN-13
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/04/2013 16:02:29
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 5797403648 bytes disk space from 107374182400 limit
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
I know that I have to extend the db_recovery_file_dest directory for "limit exceed" error but would anyone here show me how can I safely delete the archivelog in order to bring up the database?
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
