Category Archives: Uncategorized

Backup Rman Incremental SCRIPTS Use Name days for tag

Posted on March 2, 2017 by tosasan

Set retention policy to recovery window to 7 days. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; Script for Backup Level 0 backup_0.sh ORACLE_BASE=/oracle ORACLE_HOME=$ORACLE_BASE/orahome ORACLE_SID=orcl export ORACLE_BASE ORACLE_HOME ORACLE_SID export PATH=$PATH:/$ORACLE_HOME/bin rman target=’system/bagbag’ cmdfile=’/oracle/rman_script/rman_backup0.cmd’ log=’/oracle/rman_script/backup-level0.log’ currentdate=`date ‘+%y%m%d_%H%M’` file_name=hr_db_DC$currentdate.dmp … Continue reading →

Posted in ORACLE, RMAN, Uncategorized | Tagged | Leave a comment

Containers Instead of Virtual Machines

Posted on January 26, 2017 by tosasan

The last couple of years have seen the rise of software products that leverage Linux Containers (LXC) to deploy many instances of an application on one operating system. Running applications in LXC is an alternative to running applications in a … Continue reading →

Posted in OS, Uncategorized | Leave a comment

Renaming or Moving Oracle Files

Posted on January 24, 2017 by tosasan

original page : https://oracle-base.com/articles/misc/renaming-or-moving-oracle-files Controlfiles The current location of the controlfiles can be queried from the V$CONTROLFILE view, as shown below. SQL> select name from v$controlfile; NAME ————————————————————- C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\CONTROL01.CTL C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\CONTROL02.CTL C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB10G\CONTROL03.CTL 3 rows selected. SQL> In order to rename or … Continue reading →

Posted in Uncategorized | Tagged | Leave a comment

Oracle DBA Daily Checklist

Posted on January 12, 2017 by tosasan

Oracle DBA Daily Checklist 1. Check that all instances are up. 2. Monitor alert log entries (using tail -f) 3. Check that dbsnmp(SNMP subagent for Oracle DB) is running. 4. Check all last night backups were successful. 5. Check all … Continue reading →

Posted in Uncategorized | Tagged | Leave a comment