rman备份
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/control_file_backup/sales_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/home/oracle/product/10g/dbs/snapcf_sales.f'; # default



$ cat back_db.sh
su - oracle -c "rman target / <<EOF
backup filesperset 5 format '/home/oracle/db_backup/sales_all_%p_%s_%T' database;
EOF" > /home/script/autorunlog/dbback_`date +%Y%m%d%H%M%S`



$ cat back_archivelog.sh
su - oracle -c "rman target / <<EOF
backup filesperset 20 format '/home/oracle/log_backup/saleslog_%p_%s_%T' archivelog all;
EOF" > /home/script/autorunlog/archivelog_`date +%Y%m%d%H%M%S`