个人简介
偶尔有空上来看看
文章分类
文章存档
最近访客
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2009-06-15 09:13:28
测试：
run
{
allocate channel t1 device type disk format='db_%u.bak';
backup database plus archivelog delete all input;
release channel t1;
}
{
allocate channel t1 device type disk format='db_%u.bak';
backup database plus archivelog delete all input;
release channel t1;
}
全库备份加切换归档，并删除已备份归档：
configure maxsetsize to 295m;
configure maxsetsize to 295m;
|
|
-------------
starting backup at 11-jun-09
current log archived
using channel ora_disk_1
channel ora_disk_1: starting archive log backupset
channel ora_disk_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=5 recid=22 stamp=689273809
channel ora_disk_1: starting piece 1 at 11-jun-09
channel ora_disk_1: finished piece 1 at 11-jun-09
piece handle=/u04/app/oracle/product/9.2.0/dbs/05khauui_1_1 comment=none
channel ora_disk_1: backup set complete, elapsed time: 00:00:02
channel ora_disk_1: deleting archive log(s)
archive log filename=/u04/arch/1_5.dbf recid=22 stamp=689273809
finished backup at 11-jun-09
starting backup at 11-jun-09
using channel ora_disk_1
channel ora_disk_1: starting full datafile backupset
channel ora_disk_1: specifying datafile(s) in backupset
including current controlfile in backupset
input datafile fno=00001 name=/u04/app/oracle/oradata/test/system01.dbf
channel ora_disk_1: starting piece 1 at 11-jun-09
channel ora_disk_1: finished piece 1 at 11-jun-09
piece handle=/u04/app/oracle/product/9.2.0/dbs/db_06khauuk_1_1.bak comment=none
channel ora_disk_1: backup set complete, elapsed time: 00:01:56
channel ora_disk_1: starting full datafile backupset
channel ora_disk_1: specifying datafile(s) in backupset
input datafile fno=00006 name=/u04/app/oracle/oradata/test/test01.dbf
input datafile fno=00004 name=/u04/app/oracle/oradata/test/tools01.dbf
channel ora_disk_1: starting piece 1 at 11-jun-09
channel ora_disk_1: finished piece 1 at 11-jun-09
piece handle=/u04/app/oracle/product/9.2.0/dbs/db_07khav29_1_1.bak comment=none
channel ora_disk_1: backup set complete, elapsed time: 00:00:55
channel ora_disk_1: starting full datafile backupset
channel ora_disk_1: specifying datafile(s) in backupset
input datafile fno=00002 name=/u04/app/oracle/oradata/test/undotbs01.dbf
input datafile fno=00003 name=/u04/app/oracle/oradata/test/indx01.dbf
input datafile fno=00005 name=/u04/app/oracle/oradata/test/users01.dbf
channel ora_disk_1: starting piece 1 at 11-jun-09
channel ora_disk_1: finished piece 1 at 11-jun-09
piece handle=/u04/app/oracle/product/9.2.0/dbs/db_08khav40_1_1.bak comment=none
channel ora_disk_1: backup set complete, elapsed time: 00:01:05
finished backup at 11-jun-09
using channel ora_disk_1
channel ora_disk_1: starting full datafile backupset
channel ora_disk_1: specifying datafile(s) in backupset
including current controlfile in backupset
input datafile fno=00001 name=/u04/app/oracle/oradata/test/system01.dbf
channel ora_disk_1: starting piece 1 at 11-jun-09
channel ora_disk_1: finished piece 1 at 11-jun-09
piece handle=/u04/app/oracle/product/9.2.0/dbs/db_06khauuk_1_1.bak comment=none
channel ora_disk_1: backup set complete, elapsed time: 00:01:56
channel ora_disk_1: starting full datafile backupset
channel ora_disk_1: specifying datafile(s) in backupset
input datafile fno=00006 name=/u04/app/oracle/oradata/test/test01.dbf
input datafile fno=00004 name=/u04/app/oracle/oradata/test/tools01.dbf
channel ora_disk_1: starting piece 1 at 11-jun-09
channel ora_disk_1: finished piece 1 at 11-jun-09
piece handle=/u04/app/oracle/product/9.2.0/dbs/db_07khav29_1_1.bak comment=none
channel ora_disk_1: backup set complete, elapsed time: 00:00:55
channel ora_disk_1: starting full datafile backupset
channel ora_disk_1: specifying datafile(s) in backupset
input datafile fno=00002 name=/u04/app/oracle/oradata/test/undotbs01.dbf
input datafile fno=00003 name=/u04/app/oracle/oradata/test/indx01.dbf
input datafile fno=00005 name=/u04/app/oracle/oradata/test/users01.dbf
channel ora_disk_1: starting piece 1 at 11-jun-09
channel ora_disk_1: finished piece 1 at 11-jun-09
piece handle=/u04/app/oracle/product/9.2.0/dbs/db_08khav40_1_1.bak comment=none
channel ora_disk_1: backup set complete, elapsed time: 00:01:05
finished backup at 11-jun-09
starting backup at 11-jun-09
current log archived
using channel ora_disk_1
channel ora_disk_1: starting archive log backupset
channel ora_disk_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=6 recid=23 stamp=689274050
channel ora_disk_1: starting piece 1 at 11-jun-09
channel ora_disk_1: finished piece 1 at 11-jun-09
piece handle=/u04/app/oracle/product/9.2.0/dbs/09khav63_1_1 comment=none
channel ora_disk_1: backup set complete, elapsed time: 00:00:02
channel ora_disk_1: deleting archive log(s)
archive log filename=/u04/arch/1_6.dbf recid=23 stamp=689274050
finished backup at 11-jun-09
current log archived
using channel ora_disk_1
channel ora_disk_1: starting archive log backupset
channel ora_disk_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=6 recid=23 stamp=689274050
channel ora_disk_1: starting piece 1 at 11-jun-09
channel ora_disk_1: finished piece 1 at 11-jun-09
piece handle=/u04/app/oracle/product/9.2.0/dbs/09khav63_1_1 comment=none
channel ora_disk_1: backup set complete, elapsed time: 00:00:02
channel ora_disk_1: deleting archive log(s)
archive log filename=/u04/arch/1_6.dbf recid=23 stamp=689274050
finished backup at 11-jun-09
给主人留下些什么吧！~~