-
Archive log error in alert log
I was running out of space on my server so i deleted some archive log on the disk.
I have valid backups on tape.(cold backup + full exports)
But i see those errors in my alert file.
"Wed Oct 18 15:33:07 2006
Thread 1 advanced to log sequence 571
Current log# 1 seq# 571 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLASP\ONLINELOG\O1_MF_1_2CH74GXL_.LOG
Current log# 1 seq# 571 mem# 1: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCLASP\ONLINELOG\O1_MF_1_2CH74PFH_.LOG
Wed Oct 18 15:33:23 2006
WARNING: Cannot delete Oracle managed file D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCLASP\ARCHIVELOG\2006_08_17\O1_MF_1_122_2G91QLNX_.ARC
Wed Oct 18 15:33:23 2006
Errors in file d:\oracle\product\10.2.0\admin\orclasp\bdump\orclasp_arc1_4256.trc:
ORA-01265: Unable to delete ARCHIVED LOG D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCLASP\ARCHIVELOG\2006_08_17\O1_MF_1_122_2G91QLNX_.ARC
ORA-27056: could not delete file
OSD-04029: unable to get file attributes
O/S-Error: (OS 3) The system cannot find the path specified.
"
Wow can i tell oracle that i deleted archive logs?
Or is there a way to delete those files with Oracle Enterprise Manager 10g?
-
You should launch RMAN:
and run the following:
Code:
RMAN> CROSSCHECK ARCHIVELOG ALL;
RMAN> DELETE EXPIRED ARCHIVELOG ALL;
-
ebrian, I would agree...
and Steve123, for future references, use RMAN to remove backup and archivelogs and you shouldn't have this problem again.
smoothyc of NC.
-
Hi Friends,,,,thanks for the commands...iwas able to use it too
I'm just curious...what others "crosscheck" commands available?
I only only know....
crosscheck backup;
crosscheck archivelog all;
Is there also crosscheck controlfile? and any other crosschecks?
Thanks
Behind The Success And Failure Of A Man Is A Woman
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|