[i=s] 本帖最后由 tolywang 于 2012-3-24 17:36 编辑
Oracle 11.2.0.2 非归档测试库 , 应用 EBS R12.1.3
需要备份此数据库, 但是磁盘空间不足, 只能划分到两个磁盘上 。 100多个文件, 不知道怎么写 。
共 580G 左右, /data/d2 空间约为 60G , 只能放最后约 7,8个文件 。 文件号一个个写出来,太
多了 。 或者还有没有其他方式 ?
顺便问问,压缩比是 5:1 ?
RMAN >
run{
allocate channel c1 device type disk format '/data/d3/rmanbak/full_%d_%s_%p_%u.bak' maxpiecesize=10G;
allocate channel c2 device type disk format '/data/d3/rmanbak/full_%d_%s_%p_%u.bak' maxpiecesize=10G;
allocate channel c3 device type disk format '/data/d3/rmanbak/full_%d_%s_%p_%u.bak' maxpiecesize=10G;
allocate channel c4 device type disk format '/data/d3/rmanbak/full_%d_%s_%p_%u.bak' maxpiecesize=10G;
allocate channel c5 device type disk format '/data/ d2/rmanbak/full_%d_%s_%p_%u.bak' maxpiecesize=10G;
backup as compressed backupset database
( datafile 1~25 channel c1)
(datafile 26~50 channel c2)
(datafile 51~75 channel c3)
(datafile 76~94 channel c4)
( datafile 95~100 channel c5);
release channel c1;
release channel c2;
release channel c3;
release channel c4;
release channel c5;
}
Oracle 11.2.0.2 非归档测试库 , 应用 EBS R12.1.3
需要备份此数据库, 但是磁盘空间不足, 只能划分到两个磁盘上 。 100多个文件, 不知道怎么写 。
共 580G 左右, /data/d2 空间约为 60G , 只能放最后约 7,8个文件 。 文件号一个个写出来,太
多了 。 或者还有没有其他方式 ?
顺便问问,压缩比是 5:1 ?
RMAN >
run{
allocate channel c1 device type disk format '/data/d3/rmanbak/full_%d_%s_%p_%u.bak' maxpiecesize=10G;
allocate channel c2 device type disk format '/data/d3/rmanbak/full_%d_%s_%p_%u.bak' maxpiecesize=10G;
allocate channel c3 device type disk format '/data/d3/rmanbak/full_%d_%s_%p_%u.bak' maxpiecesize=10G;
allocate channel c4 device type disk format '/data/d3/rmanbak/full_%d_%s_%p_%u.bak' maxpiecesize=10G;
allocate channel c5 device type disk format '/data/ d2/rmanbak/full_%d_%s_%p_%u.bak' maxpiecesize=10G;
backup as compressed backupset database
( datafile 1~25 channel c1)
(datafile 26~50 channel c2)
(datafile 51~75 channel c3)
(datafile 76~94 channel c4)
( datafile 95~100 channel c5);
release channel c1;
release channel c2;
release channel c3;
release channel c4;
release channel c5;
}
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-719453/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-719453/