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

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

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2019

**********************************************************************************


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]


My Cloud Certifications:

AWS Certified Solutions Architect Associate

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

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: