Here are the setting, do you want to change as given by you
Primary
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO ‘SBT_TAPE’;
secondary
CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;
select * from v$flash_recovery_area_usage;
CROSSCHECK ARCHIVELOG ALL;
LIST EXPIRED ARCHIVELOG ALL;
DELETE EXPIRED ARCHIVELOG ALL;
Archive log gap fix
cat restore.sh
BKUP_DATE=$(date +%m-%d-%y)
!/bin/bash
$ORACLE_HOME/bin/rman target / log=/home/oracle/scripts/restore.log @/home/oracle/scripts/restore.rman
cat restore.rman
run
{
ALLOCATE CHANNEL t1 DEVICE TYPE sbt PARMS=’SBT_LIBRARY=/opt/oracle/dcs/commonstore/oss/LINUX_phx1x9/libopc.so ENV=(OPC_PFILE=/opt/oracle/dcs/commonstore/oss/LINUX_phx1x9/42b6482e-f631-430c-87e5-fa155fcd4111/opc_LINUX_phx1x9.ora)’;
ALLOCATE CHANNEL t2 DEVICE TYPE sbt PARMS=’SBT_LIBRARY=/opt/oracle/dcs/commonstore/oss/LINUX_phx1x9/libopc.so ENV=(OPC_PFILE=/opt/oracle/dcs/commonstore/oss/LINUX_phx1x9/42b6482e-f631-430c-87e5-fa155fcd4111/opc_LINUX_phx1x9.ora)’;
ALLOCATE CHANNEL t3 DEVICE TYPE sbt PARMS=’SBT_LIBRARY=/opt/oracle/dcs/commonstore/oss/LINUX_phx1x9/libopc.so ENV=(OPC_PFILE=/opt/oracle/dcs/commonstore/oss/LINUX_phx1x9/42b6482e-f631-430c-87e5-fa155fcd4111/opc_LINUX_phx1x9.ora)’;
ALLOCATE CHANNEL t4 DEVICE TYPE sbt PARMS=’SBT_LIBRARY=/opt/oracle/dcs/commonstore/oss/LINUX_phx1x9/libopc.so ENV=(OPC_PFILE=/opt/oracle/dcs/commonstore/oss/LINUX_phx1x9/42b6482e-f631-430c-87e5-fa155fcd4111/opc_LINUX_phx1x9.ora)’;
set archivelog destination to ‘/u01/backups/dmp/rmanbackup’;
restore archivelog from sequence 3633 until sequence 3640;
release channel t1;
release channel t2;
release channel t3;
release channel t4;
}
