Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Tuesday, August 11, 2015

Oracle configure archivelog

configure archivelog:


Connect to the database:

[oracle@collabn1 config]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 4 14:42:42 2015

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
ORCL      READ WRITE

Set the recovery area if you haven’t already done:

SQL> alter system set db_recovery_file_dest='+DATA2';

System altered.

SQL> alter system set db_recovery_file_dest_size=12g;

System altered.


SQL> show parameter db_recovery_file_dest_size

NAME                    TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size         big integer 3882M

SQL> show parameter recovery

NAME                    TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest            string     +FRA
db_recovery_file_dest_size         big integer 3882M
recovery_parallelism            integer     0


Archivelog is currently disabled:

SQL> archive log list;
Database log mode           No Archive Mode
Automatic archival           Disabled
Archive destination           USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     5
Current log sequence           7

To enable the archivelog DB must be in mount state:

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount;
ORACLE instance started.

Total System Global Area  430075904 bytes
Fixed Size           2214056 bytes
Variable Size         385877848 bytes
Database Buffers       37748736 bytes
Redo Buffers           4235264 bytes
Database mounted.

Enable Archivelog

SQL> alter database archivelog;

Database altered.

Verify the archivelog setting:

SQL> archive log list;
Database log mode           Archive Mode
Automatic archival           Enabled
Archive destination           USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     5
Next log sequence to archive   7
Current log sequence           7

Open the database:

SQL> alter database open;

Database altered.

No comments: