Standby Settings for archive logs

0

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

[oracle@carliuatdb scripts]$ 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
[oracle@carliuatdb scripts]$ 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;
}

Share.

About Author

Leave A Reply