su - oracle
cd ./..../back
vi back_up_daily.sh
#!/bin/bash
if [ -f $ORACLE_HOME/bin/rman -a -d /u01/app/oracle/rman/ ]
then
$ORACLE_HOME/bin/rman target / >>/u01/app/oracle/rman/rman_log$(date +%F.%T).log <
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/rman/%F';
ALLOCATE CHANNEL CH1 DEVICE TYPE DISK FORMAT '/u01/app/oracle/rman/%U';
BACKUP DATABASE SKIP INACCESSIBLE FILESPERSET 10
PLUS ARCHIVELOG FILESPERSET 20
DELETE ALL INPUT;
RELEASE CHANNEL CH1;
}
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
CROSSCHECK BACKUPSET;
DELETE NOPROMPT OBSOLETE;
exit;
EOF
else
exit 1
fi
exit
chmod 755 back_up_daily.sh
su - root
crontab -u oracle -e
0 1 * * * /xxxx/back/back_up_daily.sh
这样 就能自动备份 ORACLE了
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/15116811/viewspace-488971/ ，如需转载，请注明出处，否则将追究法律责任。
