oracle rman备份命令-备份恢复

下面的脚本备份在24小时内产生的归档日志，在备份完成后会自动删除归档日志。如果备份失败，归档日志不会被删除。

run {
allocate channel c1 type disk;
backup format '/export/home/oracle/oradata/bak_log/log_t%t_s%s_p%p'
(archivelog from time 'sysdate-1' all delete input);
release channel c1;
}
　　
run {
allocate channel c1 type disk;
backup archivelog low logseq 1143 high logseq 1147 thread 1 format 'aaarc%t.%s';
}

使用下面的命令显示恢复目录中的归档日志

list backupset of archivelog all;

备份联机日志

run {
allocate channel c1 type disk;
sql "alter system archive log current";
backup format '/export/home/oracle/oradata/bak_log/onlog_t%t_s%s_p%p'
(archivelog from time 'sysdate-1' all delete input);
release channel c1;
}

备份spfile

run {
allocate channel c1 type disk;
backup spfile tag 'ECOM_spfile' format '/export/home/oracle/oradata/bak_conf/spfile_%t.ora';
release channel c1;
}

清除联机日志备份

delete copy;

/* 如果物理文件被删除，用CROSSCHECK修复 */

crosscheck archivelog all;

delete noprompt obsolete;

列出对应物

list incarnation;

概述可用的备份

list backup summary;

按备份类型列出备份