Category Archives: RMAN

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

Deleting the Archive log Using RMAN

Posted on February 6, 2017 by tosasan

Once you are connected, then you can use the following to delete archivelogs with one of the following commands. You can choose the commands depending on your situation. To delete all Archivelogs withou backing them up: delete archivelog all; To … Continue reading →

Posted in ORACLE, RMAN | Tagged | Leave a comment

RMAN Delete old archivelogs

Posted on February 6, 2017 by tosasan

delete force noprompt archivelog all completed before ‘sysdate-7′; If you want to delete archive logs older than few hours: Verify the time like how many hours older than you want to delete. SQL> alter session set nls_date_format=’MM/DD/YYYY HH24:MI:SS’; Session altered. … Continue reading →

Posted in ORACLE, RMAN | Tagged | Leave a comment

Oracle Rman Delete archivelog file older than N-day

Posted on February 6, 2017 by tosasan

rman target / run{ allocate channel D1 type disk; delete noprompt archivelog until time ‘SYSDATE-<N>‘; release channel D1; } ; Example 2 day run{ allocate channel D1 type disk; delete noprompt archivelog until time ‘SYSDATE-2’; release channel D1; } ;

Posted in ORACLE, RMAN | Tagged | Leave a comment