configure retention policy to redundancy 1; configure controlfile autobackup on; configure controlfile autobackup format for device type disk to 'e:\oracle-backup\oraback\%F'; allocate channel ch1 device type disk format 'e:\oracle-backup\oraback\%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; rman备份的脚本
[code=SQL] SQL> ho cat /tmp/tmphotbak.sql; set feedback off set heading off set verify off set trimspool off set pagesize 0 set linesize 200 define dir = '/u01/app/oracle/hotbak' define script = '/tmp/hotbak.sql' spool &script select 'ho cp ' ||name|| ' &dir' from v$datafile; spool off alter database begin backup; start &script alter database end backup; alter database backup controlfile to '&dir/controlbak.ctl'; create pfile = '&dir/initorcl.ora' from spfile; SQL> start /tmp/tmphotbak.sql; --执行该脚本即可对数据库进行热备更详细的参考: Oracle 热备份
----备份的脚本 rman 文件
run {
configure retention policy to redundancy 1;
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to 'e:\oracle-backup\oraback\%F';
allocate channel ch1 device type disk format 'e:\oracle-backup\oraback\%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;
rman备份的脚本
SQL> ho cat /tmp/tmphotbak.sql; set feedback off set heading off set verify off set trimspool off set pagesize 0 set linesize 200 define dir = '/u01/app/oracle/hotbak' define script = '/tmp/hotbak.sql' spool &script select 'ho cp ' ||name|| ' &dir' from v$datafile; spool off alter database begin backup; start &script alter database end backup; alter database backup controlfile to '&dir/controlbak.ctl'; create pfile = '&dir/initorcl.ora' from spfile; SQL> start /tmp/tmphotbak.sql; --执行该脚本即可对数据库进行热备更详细的参考:
Oracle 热备份