公司RMAN备份所用语句

简介:

[oracle@racdb6 ~]$ rman target / catalog rman/rman;

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/full_%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/280092,如需转载请自行联系原作者
目录
相关文章
|
16小时前
|
Oracle 关系型数据库 数据库
Oracle数据恢复—Oracle数据库误truncate table的数据恢复案例
北京某国企客户Oracle 11g R2数据库误truncate table CM_CHECK_ITEM_HIS,表数据丢失,业务查询到该表时报错,数据库的备份不可用,无法查询表数据。 Oracle数据库执行Truncate命令的原理:在执行Truncate命令后ORACLE会在数据字典和Segment Header中更新表的Data Object ID,但不会修改实际数据部分的块。由于数据字典与段头的DATA_OBJECT_ID与后续的数据块中的并不一致,所以ORACLE服务进程在读取全表数据时不会读取到已经被TRUNCATE的记录,但是实际数据未被覆盖。
Oracle数据恢复—Oracle数据库误truncate table的数据恢复案例
|
11月前
为什么有的备份归档日志用list backup of archivelog all查不到,但在第三方备份软件中可以查到
提问:为什么有的备份归档日志用list backup of archivelog all查不到,但在第三方备份软件中可以查到?
|
12月前
|
数据库 内存技术
rman 恢复数据库一个小时多了也没有动静 implicit crosscheck
The Problem After restoring a controlfile, the restore database can take a long time to restore due to implicit croscchecking and cataloging.
|
Oracle 关系型数据库 数据库管理
|
Oracle 关系型数据库 数据库
|
Oracle 关系型数据库 测试技术
|
Oracle 关系型数据库