Oracle Database - How to change the Database Archiving Mode

About

To change the default mode from Oracle Database - NOARCHIVELOG to Oracle Database - ARCHIVELOG

Oracle Database - How to know the archivelog mode ?

Articles Related

Procedure

C:\Documents and Settings\Nicolas>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Sep 22 12:13:57 2009

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[email protected]>shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

Backup

[email protected]>STARTUP MOUNT
ORACLE instance started.

Total System Global Area  838860800 bytes
Fixed Size                  1299508 bytes
Variable Size             587205580 bytes
Database Buffers          243269632 bytes
Redo Buffers                7086080 bytes
Database mounted.
[email protected]>ALTER DATABASE ARCHIVELOG;

Database altered.

[email protected]>ALTER DATABASE OPEN;

Database altered.

[email protected]>SHUTDOWN IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down.

Backup

[email protected]>STARTUP
ORACLE instance started.

Total System Global Area  838860800 bytes
Fixed Size                  1299508 bytes
Variable Size             587205580 bytes
Database Buffers          243269632 bytes
Redo Buffers                7086080 bytes
Database mounted.
Database opened.
[email protected]>