1. 0级全备
- backup incremental level 0 database;
2. 1级增备
backup incremental level 1 database;
3. 日志备份
- backup archivelog all delete input;
- run {
- allocate channel c1 type disk;
- restore database;
- recover database;
- sql 'alter database open';
- }
5. 不完全恢复(按时间点)
run {
allocate channel c1 type disk;
SET UNTIL TIME "to_date('2015-07-09 02:37:28','yyyy-mm-dd hh24:mi:ss')";
restore database;
recover database;
sql 'alter database open resetlogs';
}