To bring the database in the ARCHIVELOG mode from the NOARCHIVELOG mode, you should edit your init.ora / spfile with the following information:
1og_archi ve_dest='/uOl/oradata/archlog'
(for example)
log„archive_format=,%t_%s.dbf' (for example)
log_archive_start=true
-- for versions lower than lOg
sql>shutdown;
sql>startup mount
sql>alter database archivelog;
sql>alter database open;
It is preferable to backup the database before switching to the ARCHIVELOG mode.
1og_archi ve_dest='/uOl/oradata/archlog'
(for example)
log„archive_format=,%t_%s.dbf' (for example)
log_archive_start=true
-- for versions lower than lOg
sql>shutdown;
sql>startup mount
sql>alter database archivelog;
sql>alter database open;
It is preferable to backup the database before switching to the ARCHIVELOG mode.