Skip to Main Content

Oracle Database Discussions

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!

Archive files not getting generated

442562Nov 20 2006 — edited Nov 23 2006
Hello,
I have just set one of my branches databases in an test environment and changed it from a NoArchivelog Mode to an Archive Log mode.
For doing the same I have followed the stated steps:
1) Changes the entries in my ini file :

log_archive_start = true
log_archive_dest = ORAWORK:\OraHome1\oradata\btxis\archive
log_archive_format = "ARC%S.%T"

2) execute the syntax
Shutdown immediate;
Startup mount;
Alter database archivelog;
alter database open;

On Saturday I made some entries using my application and noticed that the archive files did not get generated .Then I did a shutdown and started the database again and agin passes few more entries.After which I saw 1 file generated.
Today I came in and continued making fresh entries but again I do not see any new archive files getting generated .The only file present is the one generated on Saturday.I tried shutting and starting the database and passing the entries again but the result is the same.
Please can you tell me as to where I am going wrong.

Thanx in advance
Sapna
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 21 2006
Added on Nov 20 2006
18 comments
1,647 views