Archive log mode

[maga2724]

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

[amirtai]

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;

[maga2724]

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