Table of Contents

About

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

Oracle Database - How to know the archivelog mode ?

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

sys@orcl>shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

Backup 

sys@orcl>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.
sys@orcl>ALTER DATABASE ARCHIVELOG;

Database altered.

sys@orcl>ALTER DATABASE OPEN;

Database altered.

sys@orcl>SHUTDOWN IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down.

Backup 

sys@orcl>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.
sys@orcl>