Here's the latest findings. I'm sure no one has moved those files into the /dbs directory.
Code:RMAN> change archivelog until time 'sysdate-1' delete; using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=130 device type=DISK List of Archived Log Copies for database with db_unique_name ORCL ===================================================================== Key Thrd Seq S Low Time ------- ---- ------- - --------- 96 1 38 A 26-APR-09 Name: /u01/app/oracle/product/11.1.0/db_1/dbs/arch1_38_682014240.dbf Do you really want to delete the above objects (enter YES or NO)? yes deleted archived log archived log file name=/u01/app/oracle/product/11.1.0/db_1/dbs/arch1_38_682014240.dbf RECID=96 STAMP=685550413 Deleted 1 objects




Reply With Quote