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
Archive log mode
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;
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
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
Who is online
Users browsing this forum: No registered users and 1 guest