RMAN> run{
2> allocate channel c1 type disk;
3> backup full tag 'dbfull' format '/dbbak/full%u_%s_%p' database
4> include current controlfile;
5> sql 'alter system archive log current';
6> backup fileaperset 3 format '/dbbak/arch%u_%s_%p'RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "archivelog, as, backup, backupset, blocks, channel, check, copy, copies, controlfilecopy, cumulative, current, database, datafile, datafilecopy, device, diskratio, db_recovery_file_dest, db_file_name_convert, duration, filesperset, for, format, full, force, incremental, keep, (, maxsetsize, nochecksum, noexclude, nokeep, not, proxy, pool, reuse, recovery, skip, spfile, setsize, tablespace, tag, to, validate"
RMAN-01008: the bad identifier was: fileaperset
RMAN-01007: at line 6 column 8 file: standard input
2> allocate channel c1 type disk;
3> backup full tag 'dbfull' format '/dbbak/full%u_%s_%p' database
4> include current controlfile;
5> sql 'alter system archive log current';
6> backup fileaperset 3 format '/dbbak/arch%u_%s_%p'RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "archivelog, as, backup, backupset, blocks, channel, check, copy, copies, controlfilecopy, cumulative, current, database, datafile, datafilecopy, device, diskratio, db_recovery_file_dest, db_file_name_convert, duration, filesperset, for, format, full, force, incremental, keep, (, maxsetsize, nochecksum, noexclude, nokeep, not, proxy, pool, reuse, recovery, skip, spfile, setsize, tablespace, tag, to, validate"
RMAN-01008: the bad identifier was: fileaperset
RMAN-01007: at line 6 column 8 file: standard input
改成这样呢?RMAN> run{
allocate channel c1 type disk;
backup full tag 'dbfull' format '/dbbak/full%u_%s_%p' database
include current controlfile;
sql 'alter system archive log current';
backup format '/dbbak/arch%u_%s_%p' archivelog all delete input;
release channel c1;
}
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Productio
NLSRTL Version 10.2.0.3.0 - Production我想用下 fileaperset 3 ,因为不太明白 fileaperset 3 的意思,以及怎样去应用它?
--biti_rainy
filesperset =files per backupset
有10个datafiles,filesperset =4
10/4=2.5
你备份数据库的时候生成3个backupset----------------------------
--piner
filesperset是说每个备份集最多能备份几个数据文件或归档日志一个备份集可以有多个备份片
数据文件等备份是不能跨越备份集但是能跨越备份片
所以说备份集包含某数据文件是正确的
---------------------
-- husthxd
用FILESPERSET控制备份集的尺寸
当指定FILESPERSET参数时,rman比较FILESPERSET与自动计算出来的值(对每个已分配通道的文件数目)并取其中较小的那个值来保证所有的通道被使用。
如果指定或者通过组合backupSpec语句暗示的文件数目比FILESPERSET要大,那么rman创建多个备份集来维护正确的速率(ratio);
如果没有指定FILESPERSET,rman比较计算出来的值(文件数目除以已分配的通道)和默认值64,并取其中较小的那个值来保证所有通道可用。
Rman通常尝试创建足够的备份集以使所有已分配的通道有事可做。一个例外是通道比要备份的文件还要