Hello Everyone,
I have searched Oracle Documents and over the internet. It is really hard to get information on Archive Log management , so I thought of posting it here:
Now, our Database 9i ( EBS 11.5.x ) was in no archive mode , so I enabled it to archive mode.
edit the pfile $ORACLE_HOME/admin/SID/pfile which will be /oracle/proddb/9.2.0/dbs/initPROD.ora
############################
# Archive Log Destinations -benr(10/15/04)
############################
log_archive_dest_1='location=/yourlocation/archive'
log_archive_start=TRUE
then log in to Database
SQL> shutdown normal;
SQL> startup mount exclusive;
SQL> alter system set log_archive_start=TRUE scope=spfile;
SQL> alter
system set
log_archive_dest_1='LOCATION=
/oracle/archivelog'
scope=both;
SQL> alter database archivelog;
SQL> ALTER SYSTEM ARCHIVE LOG START;
SQL> alter database open;
SQL> alter system archive log all;
SQL> alter system archive log start;
SQL> archive log start;
Next day, I checked the archive location and it generated archives of 1 GB even though there is no activity on the Database.
root@test4:/oracle/archivelog>ls
1_844.dbf 1_862.dbf 1_880.dbf 1_898.dbf 1_916.dbf 1_934.dbf
1_845.dbf 1_863.dbf 1_881.dbf 1_899.dbf 1_917.dbf 1_935.dbf
1_846.dbf 1_864.dbf 1_882.dbf 1_900.dbf 1_918.dbf 1_936.dbf
1_847.dbf 1_865.dbf 1_883.dbf 1_901.dbf 1_919.dbf 1_937.dbf
1_848.dbf 1_866.dbf 1_884.dbf 1_902.dbf 1_920.dbf 1_938.dbf
1_849.dbf 1_867.dbf 1_885.dbf 1_903.dbf 1_921.dbf 1_939.dbf
1_850.dbf 1_868.dbf 1_886.dbf 1_904.dbf 1_922.dbf 1_940.dbf
1_851.dbf 1_869.dbf 1_887.dbf 1_905.dbf 1_923.dbf 1_941.dbf
1_852.dbf 1_870.dbf 1_888.dbf 1_906.dbf 1_924.dbf 1_942.dbf
1_853.dbf 1_871.dbf 1_889.dbf 1_907.dbf 1_925.dbf 1_943.dbf
1_854.dbf 1_872.dbf 1_890.dbf 1_908.dbf 1_926.dbf 1_944.dbf
1_855.dbf 1_873.dbf 1_891.dbf 1_909.dbf 1_927.dbf 1_945.dbf
1_856.dbf 1_874.dbf 1_892.dbf 1_910.dbf 1_928.dbf 1_946.dbf
1_857.dbf 1_875.dbf 1_893.dbf 1_911.dbf 1_929.dbf 1_947.dbf
1_858.dbf 1_876.dbf 1_894.dbf 1_912.dbf 1_930.dbf lost+found
1_859.dbf 1_877.dbf 1_895.dbf 1_913.dbf 1_931.dbf test.txt
1_860.dbf 1_878.dbf 1_896.dbf 1_914.dbf 1_932.dbf
1_861.dbf 1_879.dbf 1_897.dbf 1_915.dbf 1_933.dbf
Question
1. How can I delete old archive logs without using RMAN ?
2. How should I know which archive logs to keep and which ones to delete ?
3. Is there a way to know why the Database is generating so many archive logs ?