Convert Database into Archivelog Mode

SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;

or

SQL> select log_mode from v$database;

NOARCHIVELOG

SQL> Create Pfile=’D:\Orcl3_Pfile.sql’ from Spfile;

SQL> Shutdown Immediate;

Update this Pfile.

log_archive_dest_1='location=’C:\archive'

log_archive_start=TRUE

SQL> Startup mount pfile=’D:\Orcl3_Pfile.sql’;

SQL>Alter database archivelog ;

SQL>Alter database open; 

To change the Destination of Archive log File

Archive log list;

Show Parameter Archive;

SQL> select DEST_NAME,STATUS,DESTINATION from V$ARCHIVE_DEST;

SQL> select * from v$parameter where name = 'log_archive_dest';

It will show the current destination of Archivelog

SQL>Alter system set log_archive_dest_1='location=C:\oracle1\oradata\SHAAN\Archive';

SQL>alter system archive log start;