No Archive Log to Archive Log

— Change the Init.ora parameter

SQL> create pfile from spfile;
SQL> show parameter pfile;
SQL> show parameter spfile;

# *.log_archive_dest_1=’location=/u01/archive/ORATEST/’
# *.log_archive_format=’log%t_%s_%r.arc’

SQL> shutdown immediate

—-Backup spfile and pfile
SQL> create spfile from pfile;

SQL> connect / as sysdba

SQL> startup mount

SQL> archive log list;

SQL> ALTER DATABASE ARCHIVELOG;

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/archive/ORATEST/
Oldest online log sequence     35
Next log sequence to archive   37
Current log sequence           37
SQL> alter system switch logfile;

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/archive/ORATEST/
Oldest online log sequence     36
Next log sequence to archive   38
Current log sequence           38
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ORATEST dbs]$ cd /u01/archive/ORATEST/
[oracle@ORATEST ORATEST]$ pwd
/u01/archive/ORATEST
[oracle@ORATEST ORATEST]$ ls -ltr
total 24172
-rw-r—–  1 oracle dba 24722432 Jul 16 11:40 log1_37_692113689.arc
[oracle@ORATEST ORATEST]$