Oracle Backup knowledge: Daily backups, full backups, and seven-day backups

1. Keep for seven days

This is the only way to keep backups for seven days

Rman> Connect target/

Connected to target Database:dbsid (dbid=3100778490)

Rman> Configure retention Policy to recovery windows of 7 days;

2. Backup Scripts

vi/root/rmanbak.sh

#! /bin/bash

Su-oracle <<!

Rman Target/<<eof

Backup as Compressed Backupset database

Include current controlfile format '/orabak/db_%d_%t_%s '

Plus archivelog format '/orabak/arch_%d_%t_%s ';

#delete obsolete; (Use this script to prompt for Yes or no to cause automatic deletion to fail)

Delete NoPrompt obsolete;

# (No prompt to enter Yes or no)

Exit

Eof

3.2 o'clock in the morning daily backup

Crontab Set Value to

2 * * */root/rmanbak.sh

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/