Archivelog Mode

How to Calculate the Capacity of Archive Destination in Days

Posted on
Do you know the space that the archived destination has in terms of days? Here is a sample shell script code to calculate the maximum days that the archived log files can retain in the destination.$ vi CalculateArchiveDestCapacity.sh#!/bin/bash# Fill DB Basic InformationDBNAME=ORCLARCHIVE_DEST=/arch/ORCL # The destination is the location of archived log files.MOUNT_POINT=arch # The mount […]
Archivelog Mode

How to Enable ARCHIVELOG Mode in Oracle 9i

Posted on
In this post, I will show you how to enable archivelog mode in 9i. For those who are using Oracle 10g onwards, you may take a look at my post for more: How to Enable Archivelog Mode in Oracle Create archive log destination directory and enter sqlplus [oracle@test ~]$ mkdir -p /u01/app/oracle/product/9.2.0/archivelog/oracle9i/ [oracle@test ~]$ sqlplus […]
Archivelog Mode

How to Enable ARCHIVELOG Mode in Oracle

Posted on
For 9i database or below, please refer to: How to Enable ARCHIVELOG Mode in Oracle 9i What is Archiving? The process of copying inactive redo log files into archived files is called archiving. Archiving is only effective on databases which enable ARCHIVELOG mode. It makes databases keep transaction history much longer than finite redo logs. […]