1.备份

备份包括2个脚本----------------------------------------1.备份脚本 backup_file.sql2.执行脚本 run_bak.bat--------------------------------------    backup_file.sql   run{configure retention policy to recovery window of 30 days;allocate channel ch1 type disk;allocate channel ch2 type disk;allocate channel ch3 type disk;allocate channel ch4 type disk;backup database  tag='full_bak' format 'E:\backup\orcl_dbbak\fullbak_%d_%s_%p';  sql 'alter system archive log current';backup archivelog all tag='arc_bak' format='E:\backup\orcl_dbbak\arch_%U_%T'  delete all input;backup current controlfile tag='bak_ctlfile' format='E:\backup\orcl_dbbak\ctl_file_%U_%T'; release channel ch1;                                   release channel ch2;release channel ch3;                                   release channel ch4; }report obsolete;crosscheck backup;                                               delete noprompt obsolete;delete noprompt expired backup;delete noprompt expired backup;delete noprompt obsolete recovery window of 30 days;delete noprompt archivelog until time 'SYSDAY-180';run_bak.bat    E:cd E:\backup\scriptset ORACLE_SID=orclrman target / cmdfile='E:\backup\script\backup_file.sql' log='E:\backup\dzjz_dbbak\dbbak_orcl_%date:~0,10%.log'