关于中国_关于oracle 10g rman 全库备份脚本实例

更新时间:2019-12-02 来源:备份教程 点击:

【www.hzclsc.cn--备份教程】

全库备份加切换归档,并删除已备份归档:
CONFIGURE MAXSETSIZE to 295m;
backup database format="db_%U.bak" plus archivelog delete all input;

测试:
run
{
allocate channel t1 device type disk format="db_%U.bak";
backup database plus archivelog delete all input;
release channel t1;
}

 -------------
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
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

 

本文来源:http://www.hzclsc.cn/pingguo/42368.html

为您推荐

[杀戮尖塔手机版]杀戮尖塔存档位置在哪 杀戮尖塔存档位置一览

杀戮尖塔存档位置在哪?很多玩家朋友们在想备份或替换游戏存档时候,却不知道要在哪找到位置,为此很是苦恼,下面我们就来看一看杀戮尖塔存档位置一览,希望对各位有所帮助。杀戮尖塔存档位置一览:C: Users策略与战棋

2020-12-12 17:04:21   杀戮尖塔攻略   杀戮尖塔手游  

亿万僵尸存档位置_亿万僵尸存档在哪 亿万僵尸存档位置一览

亿万僵尸存档在哪?不少玩家朋友们在想替换或备份游戏存档的时候,不知道具体位置在哪,下面我们就来看一看亿万僵尸存档位置一览,希望对不知道的玩家朋友们有所参考和帮助。亿万僵尸存档位置一览:存档位置 C: 策略与战棋

2020-12-11 07:04:40   亿万僵尸怎么存档   亿万僵尸下载  

信长之野望15大志pk|信长之野望大志存档位置在哪 信长之野望15存档位置一览

信长之野望大志存档位置在哪?不少玩家朋友们再想备份或替换存档的时候不知道在什么位置,为此非常的苦恼,下面我们就来分享一下信长之野望15存档位置一览,希望对各位有所参考和帮助。信长之野望15存档位置:1策略与战棋

2020-12-11 07:04:40   信长之野望大志pk   信长之野望大志攻略  

【牧场物语希望之光攻略】牧场物语希望之光存档在哪 牧场物语希望之光存档位置一览

牧场物语希望之光存档在哪?不少玩家朋友们在想备份或替换游戏存档的时候不知道具体位置在哪,下面我们就来看一看牧场物语希望之光存档位置一览,希望对还不知道的玩家们有所参考。牧场物语希望之光存档位置一览:在模拟游戏

2020-12-09 17:04:22   牧场物语希望之光钓鱼   牧场物语希望之光挖矿  

【启用icloud云备份失败】icloud云备份失败怎么办 icloud云备份失败原因及解决方法

您的位置:首页 → 资讯 → 教你一招 → icloud云备份失败怎么办 icloud云备份失败原因及解决方法 icloud云备份失败怎么办 icloud云备份失败原因及解决方法时间:2017 11 教你一招

2020-12-06 17:04:20   iphone备份失败icloud空间不足