Oracle Apps DBA

Change CDB name from DEVCDB to TESTCDB ********************************************* Backup database before performing this action ********************************************* SQL> SHUTDOWN IMMEDIATE; Database closed. Database dismounted. ORACLE instance shut down. SQL> STARTUP MOUNT ORACLE instance started. Total System Global Area 2.0133E+10 bytes Fixed Size 3721176 bytes Variable Size 2684356648 bytes Database Buffers 1.7381E+10 bytes Redo Buffers 63385600 bytes Database mounted. SQL> exit [oracle@hostname ~]$ nid TARGET=/ DBNAME=TESTCDB DBNEWID: Release 12.1.0.2.0 - Production on Fri Jul 1 12:44:48 2022 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. Connected to database DEVCDB (DBID=2721637057) Connected to server version 12.1.0 Control Files in database: /oradata/devcdb/oradata/DEVCDB/controlfile/o1_mf_kcx8zx9n_.ctl /oradata/devcdb/fast_recovery_area/DEVC...

=> SQL to fetch the log gap [oracle@hostname ~]$ cat /home/oracle/scripts/standby-lag.sql select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') WHEN,': DR is ' || trim(to_char(1440 * (sysdate - max (next_time)),99999.99) ||' minutes behind') LAG from v$archived_log where applied ='YES'; exit; [oracle@hostname ~]$ Copy => Shell script to email log gap every 4 hours [oracle@hostname ~]$ cat /home/oracle/scripts/standby-lag.sh #!/bin/bash ########################################################################################## # # Purpose : Script to email standby lag details # Created on : # Last Update : # ########################################################################################## echo -e "Please find the details below : " echo -e " " echo -e " " echo -e "Script Started at `date`" echo -e " " export PATH=/usr/loc...

#!/bin/bash #Declare your environment variables #export ORACLE_SID= #export ORACLE_HOME= #export PATH=$PATH:${ORACLE_HOME}/bin #export LD_LIBRARY_PATH=${ORACLE_HOME}/bin/lib dd=`date '+%d-%h-%Y'` mkdir -p /backup_location/$dd touch /backup_location/$dd/rmanbkup_$dd.log echo rman backup for PROD started `date` > /backup_location/$dd/rmanbkup_$dd.log /oracle/db_software/bin/rman target=/ > /backup_location/$dd/rmanbkup_$dd.log CONFIGURE CONTROLFILE AUTOBACKUP ON; allocate channel for maintenance type disk; CONFIGURE RETENTION POLICY TO REDUNDANCY 1; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup_location/$dd/autobackup_control_file%F'; run { ALLOCATE CHANNEL RMAN_BACK_CH01 TYPE DISK; ALLOCATE CHANNEL RMAN_BACK_CH02 TYPE DISK; ALLOCATE CHANNEL RMAN_BACK_CH03 TYPE DISK; ALLOCATE CHANNEL RMAN_BACK_CH04 TYPE DISK; ALLOCATE CHANNEL RMAN_BACK_CH05 TYPE DISK; ALLOCATE CHANNEL RMAN_BACK_CH06 TYPE DISK; ALLOCATE CHANNEL R...