使用RMAN必须熟悉ORACLE的备份原理才行的。参考一下吧:用rman备份 noarchivelog下:(mounted database not open)
只能执行数据库完全备份(是指不能单独备份表空间、数据文件等),备份时候数据库必须关闭。恢复管理器脚本:
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup
( database include current controlfile );
}
一级,非积累
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup incremental level 1
( database include current controlfile );
}
三级,积累
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup incremental level 3 cumulative
( database include current controlfile );
} 恢复时候,在noarchive下,数据库必须mount才能恢复,open时候不能恢复
archivelog,and open 模式下1:整个库,包含archive log文件,full
恢复管理器脚本:
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup
( database include current controlfile );
backup ( archivelog all delete input );
} 恢复管理器脚本:
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup
( database include current controlfile );
backup ( archivelog from time 'Jun 12 2001 10:54:33' all delete input );
}
2:一级增量,不积累(默认为不积累)
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup incremental level 1
( database include current controlfile );
backup ( archivelog all delete input );
}
积累
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup incremental level 1 cumulative
( database include current controlfile );
backup ( archivelog all delete input );
}
3:表空间,增量,不积累,包含全部日志
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup incremental level 2
( tablespace 'CFW_DAT', 'TEMP' include current controlfile );
backup ( archivelog all delete input );
} 4:表空间完全备份,不含日志
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup
( tablespace 'CFW_DAT', 'TEMP' include current controlfile );
}
5:表空间增量,含所有日志,不积累
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup incremental level 2
( tablespace 'CFW_DAT', 'TEMP' include current controlfile );
backup ( archivelog all delete input );
}
6:数据文件,不含日志,完全背份
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup
( datafile 'D:\DATA\CFW_IDX2.ORA', 'E:\ORACLE\ORA81\DATABASE\CFW_IDX1.ORA' include current controlfile );
}
7:数据文件,含日志,增量背份
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup incremental level 2
( datafile 'D:\DATA\CFW_IDX2.ORA', 'E:\ORACLE\ORA81\DATABASE\CFW_IDX1.ORA' include current controlfile );
backup ( archivelog all delete input );
}
8:日志文件,所有,背份后删除
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p'; backup ( archivelog all delete input );
}
不删
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p'; backup ( archivelog all );
时间段
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p'; backup ( archivelog from time 'Jun 12 2001 10:54:33' until time 'Jun 12 2001 10:54:33' all delete input );
}
时间点
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p'; backup ( archivelog from time 'Jun 12 2001 10:54:33' all delete input );
}
只能执行数据库完全备份(是指不能单独备份表空间、数据文件等),备份时候数据库必须关闭。恢复管理器脚本:
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup
( database include current controlfile );
}
一级,非积累
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup incremental level 1
( database include current controlfile );
}
三级,积累
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup incremental level 3 cumulative
( database include current controlfile );
} 恢复时候,在noarchive下,数据库必须mount才能恢复,open时候不能恢复
archivelog,and open 模式下1:整个库,包含archive log文件,full
恢复管理器脚本:
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup
( database include current controlfile );
backup ( archivelog all delete input );
} 恢复管理器脚本:
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup
( database include current controlfile );
backup ( archivelog from time 'Jun 12 2001 10:54:33' all delete input );
}
2:一级增量,不积累(默认为不积累)
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup incremental level 1
( database include current controlfile );
backup ( archivelog all delete input );
}
积累
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup incremental level 1 cumulative
( database include current controlfile );
backup ( archivelog all delete input );
}
3:表空间,增量,不积累,包含全部日志
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup incremental level 2
( tablespace 'CFW_DAT', 'TEMP' include current controlfile );
backup ( archivelog all delete input );
} 4:表空间完全备份,不含日志
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup
( tablespace 'CFW_DAT', 'TEMP' include current controlfile );
}
5:表空间增量,含所有日志,不积累
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup incremental level 2
( tablespace 'CFW_DAT', 'TEMP' include current controlfile );
backup ( archivelog all delete input );
}
6:数据文件,不含日志,完全背份
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup
( datafile 'D:\DATA\CFW_IDX2.ORA', 'E:\ORACLE\ORA81\DATABASE\CFW_IDX1.ORA' include current controlfile );
}
7:数据文件,含日志,增量背份
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p';
backup incremental level 2
( datafile 'D:\DATA\CFW_IDX2.ORA', 'E:\ORACLE\ORA81\DATABASE\CFW_IDX1.ORA' include current controlfile );
backup ( archivelog all delete input );
}
8:日志文件,所有,背份后删除
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p'; backup ( archivelog all delete input );
}
不删
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p'; backup ( archivelog all );
时间段
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p'; backup ( archivelog from time 'Jun 12 2001 10:54:33' until time 'Jun 12 2001 10:54:33' all delete input );
}
时间点
run {
allocate channel DefaultChannel type disk format 'E:\ORACLE\ORADATA\MFX\b_%u_%s_%p'; backup ( archivelog from time 'Jun 12 2001 10:54:33' all delete input );
}
解决方案 »
- 关于insert效率的问题
- 请教一个proc连接oracle时使用at_link的问题
- 如何判断出一个表中的具体某条记录被操作
- 请教几个概念问题。Oracle会话(session)、连接数、并发用户连接数怎么区别?如何通过SQL查询得到?目前好像没有一个特定的答案。
- 请教高人 IMP-00057
- 如何把一个用户下的所有对象的所有权限一次性赋给另一个用户
- Oracle导出导入
- SQL语句中,需要将某一条数据单独提出置前,再加按主键排序的一组数据总排列,怎么用一条语句实现。
- ESCAPE 的奇怪问题
- 我要散分了,1.sqlplus屏幕缓冲区数据被截断???? 2.login.sql文件无效
- developer2000中文下载地址,急!
- 求图表工具(言者有分)
这些都是你执行过的是吗?我这就去做一下。给我发个短消息吧,不好意思,我还不会发,保持联系!