backup简介
来源:互联网 发布:ug曲面刻字编程 编辑:程序博客网 时间:2024/06/05 08:33
RMAN> backup database;
RMAN> configure backup optimization on;
RMAN> backup database;
RMAN> backup database force; /* 在开启备份优化的情况下,强制备份只读的数据文件 */
备份优化会使RMAN默认不备份没有发生变化的表空间(例如只读表空间)。但要执行一个忽略这个配置的特定备份操作,可以使用force参数来确保备份所有数据文件。
RMAN> configure exclude for tablespace ts; /* 配置备份时不备份表空间 ts */
RMAN> backup database;
RMAN> backup database noexclude; /* 在开启exclude设置时,仍然备份被exclude的表空间 */
RMAN> backup database force noexclude; /* 确保完整备份数据库 */
在开启备份优化的情况下,备份包括只读数据文件;在开启exclude表空间的情况下,备份包括exclude的表空间。
RMAN> backup database plus archivelog; /* 备份数据库和所有日志 */
RMAN> backup database plus archivelog delete input; /* 同上,并将已备份的日志删除 */
RMAN> backup database archivelog all;
RMAN> backup database archivelog all delete input;
关于plus archivelog 与 archivelog all的区别,参考下边的:备份数据文件的同时备份归档文件,其区别是一样的。
RMAN> backup tablespace system, users;
RMAN> backup tablespace system plus archivelog ;
RMAN> backup tablespace system archivelog all;
RMAN> backup validate database; /* 坏块记录到v$database_block_corruption */
RMAN> backup validate tablespace system;
RMAN> backup validate database archivelog all;
RMAN> backup as compressed backupset database; /* 压缩备份 */
RMAN> backup as copy … /* Image Cpoy */
Image Copy备份database的方法:
RMAN> backup as copy database;
Image Copy备份datafile的方法:
RMAN> backup as copy
2> datafile '/u02/oradata/zydev/users01.dbf'
3> format '/u01/BACKUP/users01.dbf';
/* 备份时不检查坏块 */
RMAN> backup as copy nochecksum
2> datafile '/u02/oradata/zydev/users01.dbf'
3> format '/u01/BACKUP/users01.dbf';
/* 重写已经存在的备份集或映像拷贝 */
RMAN> backup as copy reuse
2> datafile '/u02/oradata/zydev/users01.dbf'
3> format '/u01/BACKUP/users01.dbf';
RMAN> delete copy of datafile 4;
RMAN> delete copy of datafile '/u02/oradata/zydev/users01.dbf';
Image Copy备份archivelog的方法:
RMAN> backup as copy
2> archivelog like '/FRA_PATH/o1_mf_1_26_5t0mp0q6_.arc'
3> format '/u01/BACKUP/o1_mf_1_26_5t0mp0q6_.bak';
RMAN> delete copy of archivelog like '/u01/BACKUP/o1_mf_1_26_5t0mp0q6_.bak';
Image Copy同时备份datafile和archivelog的方法:
RMAN> run {
2> allocate channel c1 type disk;
3> copy
4> datafile '/u02/oradata/zydev/users01.dbf'
5> to '/u01/BACKUP/users01.dbf',
6> archivelog '/FRA_PATH/o1_mf_1_26_5t0mp0q6_.arc'
7> to '/u01/BACKUP/o1_mf_1_26_5t0mp0q6_.bak';
8> }
备份数据文件的同时备份归档文件:
RMAN> report schema;
RMAN> backup datafile 1 plus archivelog;
RMAN> backup datafile 1 plus archivelog delete input;
RMAN> backup datafile 1 archivelog all;
RMAN> backup datafile 1 archivelog all delete input;
注意:plus archivelog 与 archivelog all的区别,plus archivelog 在备份时先备份归档文件且对当前redo进行了归档,然后再备份数据文件,接下来是控制文件和spfile,最后是再对当然redo进行归档并进行备份。而archivelog all则是先备份数据文件,然后再备份归档(有时也是先备份归档,然后再备份数据文件),且不对当前的redo进行归档,最后备份控制文件和spfile。当使用archvielog all时,如果归档目录中没有归档文件时,将报错。
备份controlfile和spfile:
RMAN> backup current controlfile;
RMAN> backup current controlfile plus archivelog;
RMAN> backup current controlfile archivelog all;
RMAN> backup spfile;
RMAN> backup spfile plus archivelog;
RMAN> backup spfile archivelog all;
备份数据库同时备份controlfile、spfile和archivelog:
RMAN> backup database include current controlfile;
RMAN> backup database spfile;
RMAN> backup database include current controlfile spfile;
RMAN> backup database spfile include current controlfile;
RMAN> backup database spfile include current controlfile plus archivelog;
RMAN> backup database spfile include current controlfile archivelog all;
单独备份归档:
RMAN> backup archivelog all;
RMAN> backup archivelog all force; /* 有关信息Backup Optimization */
RMAN> backup archivelog all delete input;
RMAN> backup archivelog all delete all input;
注意:单独备份日志时,会首先对当前日志进行归档(归档目录当前可以没有归档日志),然后备份,不备份spfile和controlfile。 delete input 选项的意思是归档备份后删除已备份的归档。在存在多个归档路径时, dete all input 用于备份后删除归档目录中的所有的归档(9i引入的选项)。
只备份新添加数据文件:
SQL> create tablespace ts datafile '/u02/oradata/zydev/ts01.dbf' size 10m;
RMAN> backup database not backed up;
备份在限定时间内没有备份的文件:
RMAN> backup database not backed up since time='sysdate-2';
- backup简介
- Azure Backup 简介
- backup
- BACKUP
- backup
- backup
- backup
- backup
- backup
- Backup
- Backup
- Backup
- backup
- backup
- Backup
- backup
- backup
- backup
- flex
- MFC的内部过程
- tomcat改用log4j
- BizTalk Server 2010 + SQL Server 2008 R2 - 通过集成创造更大价值 [ 下篇 ]
- poj 3468 lazy
- backup简介
- ASM Fast Rebalance
- Flock官方宣布,对其浏览器产品支持已经结束,请支持者使用Chrome或Firefox
- 【转】如何关闭 Chrome 的自动升级
- 查找数据库中表空间信息
- 简洁高效CSS原则
- ExtJs之grid使用详解(转帖)
- EXTJS gridpanel中的checkbox列 根据数据库值 来初始化是否被选
- CentOS 5.5升级内核到2.6.35.4