About
To change the default mode from Oracle Database - NOARCHIVELOG to Oracle Database - ARCHIVELOG
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
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>