ERPstuff - Oracle EBS Community

Hi,
I am trying to put the archive mode. I am getting the message as disable. Plz give solution.

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Disabled
Archive destination D:\oracle\ora92\RDBMS
Oldest online log sequence 0
Next log sequence to archive 1
Current log sequence 1

I have made the changes in init.ora as well.

log_archive_start = true
log_archive_dest = D:\oracle\oradata\test\arch
log_archive_format = "%s.arch"

Awaiting the solution urgent
Thanks in advance

Mohammed AbdulGaffar

Hi

If you have changed your INIT file and bounced your DB it's suppose to be working. anyway try this one...if doesn't work send the output again.

SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> ARCHIVE LOG LIST;
SQL> ALTER DATABASE ARCHIVELOG;
SQL> ALTER SYSTEM ARCHIVE LOG START;
SQL> ARCHIVE LOG LIST;

Hi,

Thanks for replying, yah 2tay I got the solution.
Solution:
After connecting to the Oracle, I have made a command "create pfile from spfile" Oracle make the copy of spfile in the database directory. There I have edited Log_archive_start=true. Then I have started database with archive log mode.

Thanks Again.

Mohammed AbdulGaffar