We can enable archive log mode in mount state by issuing the command
sql>Shut immediate
sql>startup mount
sql>alter database archivelog;
sql>alter database open;
sql>archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination d:/archive
Oldest online log sequence 81
Next log sequence to archive 83
Current log sequence 83
After enabled to archive log mode you can verify using 'archive log list' command in sql prompt, It will display automatic archival -- enabled and archive destination -- destination where archive logs are storing.
How to change archive log destination:
To change the archive log location from default to customized you can change the parameter log_archive_dest. If database is running in pfile you need to create spfile from pfile and bounce the database it will start automatically with spfile. Then you can change archive log location.
sql>archive log list;
sql>alter system set log_archive_dest='location='/u01/archive' scope=both;
Now you can check archive log location.
sql> archive log list;
How to find archive log sequence# number:
sql> select max(sequence#) from v$archived_log;
sql>Shut immediate
sql>startup mount
sql>alter database archivelog;
sql>alter database open;
sql>archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination d:/archive
Oldest online log sequence 81
Next log sequence to archive 83
Current log sequence 83
After enabled to archive log mode you can verify using 'archive log list' command in sql prompt, It will display automatic archival -- enabled and archive destination -- destination where archive logs are storing.
How to change archive log destination:
To change the archive log location from default to customized you can change the parameter log_archive_dest. If database is running in pfile you need to create spfile from pfile and bounce the database it will start automatically with spfile. Then you can change archive log location.
sql>archive log list;
sql>alter system set log_archive_dest='location='/u01/archive' scope=both;
Now you can check archive log location.
sql> archive log list;
How to find archive log sequence# number:
sql> select max(sequence#) from v$archived_log;