Oracle Database - How to change the Database Archiving Mode

> Database > Oracle Database

1 - About

Advertising

3 - 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>
db/oracle/archivelog_change_mode.txt · Last modified: 2017/09/06 19:27 by gerardnico