Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Database Archive Logs

User_7L9DTSep 4 2013 — edited Oct 3 2013

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 ?

This post has been answered by DK2010 on Sep 4 2013
Jump to Answer

Comments

Christian Berg-0racle

Shortest answer: No.

If your client wants to use Excel and not the Oracle product they pay for, then contact Microsoft.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 31 2013
Added on Sep 4 2013
17 comments
2,889 views