How to disable and enable archive log in Oracle RAC

After the core DBA, continue our journey towards RAC environment. Today we are going to explore the steps use for “How to disable and enable archive log in oracle RAC“ Let’s follow the steps. Hopefully, you will feel the difference in RAC. Step1: First we need to stop database instance on node1 using sqlplus. [oracle@rac-node1 […]

Read More

Cold Backup and Recovery From Archivelog

Let’s have look on the steps used for Cold Backup and Recovery From Archivelog. Check the archive log status SQL> archive log list; Database log mode              No Archive Mode Automatic archival             Disabled Archive destination            USE_DB_RECOVERY_FILE_DEST Oldest online log sequence     6 Current log sequence           8 Enable the archive logs SQL> shutdown immediate; Database closed. Database dismounted. […]

Read More

Delete applied archivelog script

We need to delete archivelogs which are applied on standby servers. Following script will do the job for you. vi /home/oracle/crons/remove_applied_archivelog.sh #!/bin/ksh # # # Remove applied archivelog all; # # ORACLE_SID=ORCL; export ORACLE_SID ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/12.2.0/db_1; export ORACLE_HOME tmpfile=/tmp/arch_id.tmp $ORACLE_HOME/bin/sqlplus -S /nolog <<EOF > $tmpfile connect / as sysdba set head off set […]

Read More