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 […]
Articles Tagged: archivelog
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. […]
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 […]