ORACLE DBA BLOG

 In Oracle database, the Flash Recovery Area or FRA is a location on disk where the database can create and manage several kinds of backup and recovery-related files. Main file types are archivelog, flashback log, backups, as well as mirrors for your control files and redo log files. All files in the FRA are Oracle-managed files. Using a Flash Recovery Area simplifies the administration of your database by automatically retaining them for as long as they are needed for restore and recovery activities, and deleting them when they are no longer needed, because the space is needed for another backup and recovery-related purpose. Checking the current usage  You can check the configuration by looking at two parameters.The parameters are db_receovery_file_dest and second one db_recovery_file_dest_size .  db_receovery_file_dest point to location where the files will be located in Server . FOr normal single Databases this will be any directory for RAC this will b...

OBJECTIVE: Write a script is to monitor goldengate processes like extract and replicat, And in case extract or replicat is down, it will send alert to the respective email ids. cat gg_alert.sh #!/bin/bash EMAIL_LIST = "support@dbaclass.com"   OIFS = $ IFS IFS = " " NIFS = $ IFS   function status { OUTPUT = ` $ GG_HOME / ggsci << EOF info all exit EOF ` } function alert { for line in $ OUTPUT do if [ [ $ ( echo "${line}" | egrep 'STOP|ABEND' > / dev / null ; echo $ ? ) = 0 ] ] then GNAME = $ ( echo "${line}" | awk - F " " '{print $3}' ) GSTAT = $ ( echo "${line}" | awk - F " " '{print $2}' ) GTYPE = $ ( echo "${line}" | awk - F " " '{print $1}' ) case $ GTYPE in "MANAGER" ) cat $ GG_HOME / dirrpt / MGR . rpt | mailx - s "${HOSTNAME} - GoldenGate...