Oracle Database - How to change the Database Archiving Mode

Card Puncher Data Processing

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>





Discover More
Odi Jkm Oracle
ODI - Setting up Journalizing/CDC

This is the basic process for setting up CDC on an Oracle Data Integrator data model. Each of these steps is described in more detail below. Set the CDC parameters Add the datastores to the CDC ...
Card Puncher Data Processing
Oracle Database - Mode Archive Log / Archiving

Oracle Database lets you save filled groups of files to one or more offline destinations, known collectively as the archived , or more simply thearchive log. The process of turning redo log files into...



Share this page:
Follow us:
Task Runner