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
[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]>