rman备份语句集合_llw

简介:

Recovery Manager: Release 10.2.0.4.0 - Production on Tue Mar 2 17:46:26 2010
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
connected to target database: RACWEB (DBID=94500565)
connected to recovery catalog database
run {
allocate channel cha1 type disk;
backup
incremental level 0
format '/orabak/full20100304four_%d_%T_%t'
tag fullbak
database;
release channel cha1;
}

run {
allocate channel cha1 type disk;
backup
incremental level 1
format '/orabak/fullzengliangbak_%t'
tag fullzengbak
database;
release channel cha1;
}

run {
allocate channel cha11 type disk;
backup
incremental level 0
format '/orabak/ts/tsfullbak_%t'
tag tsfullbak
tablespace ticket;
release channel cha11;
}

run {
allocate channel cha12 type disk;
backup
incremental level 1
format '/orabak/ts/tszengbak_%t'
tag tszengbak
tablespace ticket;
release channel cha12;
}
 
run {
allocate channel cha2 type disk;
sql "alter system archive log current";
backup
incremental level 0
format '/orabak/arch/arch_%t'
tag archbak
archivelog all;
release channel cha2;
}
run {
allocate channel cha2 type disk;
backup
incremental level 1
format '/orabak/arch/archzeng_%t'
tag archzengbak
archivelog all;
release channel cha2;
}
 
run {
allocate channel cha3 type disk;
copy datafile "+DATASTORE1/racweb/datafile/ticket.307.710587739" to "/orabak/df/ticket1.dbf";
copy datafile "+DATASTORE1/racweb/datafile/ticket.308.710587739" to "/orabak/df/ticket2.dbf";
release channel cha3;
}
 










本文转自 jxwpx 51CTO博客,原文链接:http://blog.51cto.com/jxwpx/334232,如需转载请自行联系原作者
目录
相关文章
RMAN备份及恢复归档日志的语法
RMAN备份及恢复归档日志的语法
1047 0
|
6月前
|
Oracle 关系型数据库 数据库
oracle误删除数据的恢复方法
oracle误删除数据的恢复方法
55 0
|
SQL Oracle 关系型数据库
Oracle rman备份保留策略,归档删除策略及delete命令的使用
oracle rman备份保留策略、归档策略的使用及对delete命令的影响
1962 0
|
监控 Oracle 关系型数据库
RMAN 配置归档日志删除策略
        Oracle 11g中对于归档日志的删除,除了遵循RMAN保留策略外,也可以通过RMAN来配置归档日志的删除策略,也就是归档日志何时可以被删除。
1496 0
|
存储 Oracle 关系型数据库
Oracle误删除存储过程快速恢复技巧
Oracle误删除存储过程快速恢复技巧
513 0
|
Oracle 关系型数据库 数据库
oracle 恢复表语句
oracle 恢复表语句
|
Oracle 关系型数据库