Sunday, December 30, 2007

Oracle Recovery Manager - RMan

Connect: rman target system/manager@svc-name

Configuration:
  • Device:Configure Device Type To Disk;
  • Retention:Configure Policy To Redundancy 3;
  • Parallelism:Configure Device Type DISK Parallelism 2;
  • Controlfile:Configure ControlFile Autobackup on;
  • Controlfile Format:Configure ControlFile Autobaclup Format For Device Type Disk To 'D:\backup\ora_cf_%F';
  • Datafile:Configure Channel [CH#] Device Type Disk Format 'D:\oracle\backup\ora_df_%s_%p_#c_%U';
  • Optimization:Configure Backup Optimization;

Backup:
  • Backup all: Backup Database Plus Archivelog;
  • Incremental Backup: Backup Incremental Level 0 Database;
  • Testing Backup: Backup Validate Database Archivelog All;
  • Backup Object: Backup [Datafile #, Tablespace name]
  • Backup Since: Backup Database Not Backedup Since Time 'Sysdate-1';

No comments: