[20130502]rman的set nocfau表示什么.txt

[20130502]rman的set nocfau表示什么.txt

今天在论坛发贴问rman的set nocfau表示什么?
http://www.itpub.net/thread-1784962-1-1.html

按照bluemoon0083表示:估计是隐藏选项,no controlfile autobackup的意思

自己不做测试了,摘录如下:

RMAN> configure controlfile autobackup on;

new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

RMAN> show controlfile autobackup;

RMAN configuration parameters for database with db_unique_name XXXXX are:
CONFIGURE CONTROLFILE AUTOBACKUP ON;

RMAN> backup archivelog sequence 1;

Starting backup at 02-MAY-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=10 STAMP=813636057
channel ORA_DISK_1: starting piece 1 at 02-MAY-13
channel ORA_DISK_1: finished piece 1 at 02-MAY-13
piece handle=/oracle/XXXXX/archive/flashback/XXXXX/backupset/2013_05_02/o1_mf_annnn_TAG20130502T014027_8r49mvr1_.bkp tag=TAG20130502T014027 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 02-MAY-13

Starting Control File Autobackup at 02-MAY-13
piece handle=/oracle/XXXXX/archive/flashback/XXXXX/autobackup/2013_05_02/o1_mf_n_814326043_8r49ndl7_.bkp comment=NONE
Finished Control File Autobackup at 02-MAY-13

RMAN> run {
   set nocfau;
   backup archivelog sequence 1;
}2> 3> 4>

executing command: SET NOCFAU

Starting backup at 02-MAY-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=10 STAMP=813636057
channel ORA_DISK_1: starting piece 1 at 02-MAY-13
channel ORA_DISK_1: finished piece 1 at 02-MAY-13
piece handle=/oracle/XXXXX/archive/flashback/XXXXX/backupset/2013_05_02/o1_mf_annnn_TAG20130502T014109_8r49o5nh_.bkp tag=TAG20130502T014109 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 02-MAY-13

时间: 2024-07-30 15:48:20

[20130502]rman的set nocfau表示什么.txt的相关文章

[20171128]rman Input or output Memory Buffers.txt

[20171128]rman Input or output Memory Buffers.txt --//Input Memory Buffers如何测试,不清楚.不过找到一本电子书.摘要如下: Oracle RMAN 11g Backup and Recovery.pdf 作者:Robert G. Freeman Matthew Hart 页数:689 出版社:Mc graw hill 出版号: ISBN: 978-0-07-162861-7         MHID: 0-07-16286

[20160721]rman与undo表空间备份.txt

[20160721]rman与undo表空间备份.txt --//UNDO表空间主要用于存储前镜像数据,这些数据在回滚以及恢复过程中可能被用到. --//一般生产数据库的UNDO表空间可能会变得非常巨大,甚至包括多个数据文件,而备份完整的UNDO数据文件在恢复时一般可能用到的比 --//例很小.所以UNDO的很大一部分备份是多余的,在Oracle11g中,Oracle引入了一个新的特性RMAN UNDO备份优化. --//在RMAN备份UNDO表空间时,提交事务的UNDO信息将不再备份,这个特性

[20160112]rman会备份空块吗.txt

[20160112]rman会备份空块吗.txt -- 论坛上有人问的问题,我认为会的,那些delete完所有数据的block会备份的: http://www.itpub.net/thread-2050864-1-1.html 如果是从未被使用过的block,rman不会备份.但那些delete完所有数据的block,rman会备份吗? --我以前做过测试关于truncate的情况: http://blog.itpub.net/267265/viewspace-750049/ 1.测试环境: S

[20121127]rman备份数据文件大小与truncate.txt

[20121127]rman备份数据文件大小与truncate.txt 记得以前看rman的书,rman仅仅备份已经格式话的块,如果这样一个表被truncate后,即使空间回收了.但是在rman备份时,备份大小不会变画太多,这些前面使用的块一定会备份. 自己做一个测试看看. 1.建立测试环境:SQL> select * from v$version where rownumBANNER--------------------------------------------------------

[20171122]rman filesystemio_options.txt

[20171122]rman备份与参数filesystemio_options设置.txt --//这几天写了几篇filesystemio_options参数设置的文章,单独测试这个参数对rman备份以及os缓存的影响. 1.测试环境: SYS@book> @ &r/ver1 PORT_STRING                    VERSION        BANNER ------------------------------ -------------- ----------

[20151111]跟踪调试rman.txt

[20151111]跟踪调试rman.txt -- 上午查找在rman下执行list backup慢的问题,总结收集一些调试技巧,顺便在查看问题: 1.方法1,使用debug trace 参数: --执行如下: $ rman target / debug trace /tmp/aaa.txt --为了显示的好看,我格式化其中一行. DBGMISC:          EXITED krmkgal with status Done [10:52:04.659] elapsed time [00:0

[20160720]rman set newname for datafile

[20160720]rman set newname for datafile本质.txt --前几天在恢复历史数据库,因为生产系统数据库是asm,恢复必须要转成文件类型. --一般脚本执行如下: run { allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3 type disk; set until time '2015-03-01 18:00:00'; set newname fo

[20160718]rman恢复与filesystemio_options

[20160718]rman恢复与参数filesystemio_options=setall.txt --今天在测试环境恢复数据库,遇到许多诡异的问题,做一个记录. 1.恢复环境. SYS@dbcn1> @ &r/ver BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11

1128rman Input or output Memory Buffers

[20171128]rman Input or output Memory Buffers.txt --//做一个简单测试rman 的Input or output Memory Buffers. 1.环境: SCOTT@book> @ &r/ver1 PORT_STRING                    VERSION        BANNER ------------------------------ -------------- ----------------------