国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 開發 > 綜合 > 正文

使用Rman的Plus archvielog選項簡化數據庫備份操作

2024-07-21 02:39:47
字體:
來源:轉載
供稿:網友
Oracle9i開始Rman提供plus archivelog選項,極大的簡化了Rman備份的操作。當你定義plus archivelog語句時,RMAN執行如下步驟的操作:
1。運行一個ALTER SYSTEM ARCHIVELOG CURRENT命令
2。運行BACKUP ARCHIVELOG ALL命令。注重假如備份優化被啟用,RMAN只會備份未備份過的日志
3。備份BACKUP命令中定義的文件
4。運行ALTER SYSTEM ARCHIVELOG CURRENT命令
5。備份所有的剩下的歸檔日志測試備份腳本:
backup database format '/opt/oracle/orabak/full_%d_%T_%s'plus archivelog format '/opt/oracle/orabak/arch_%d_%T_%s'delete all input;
測試日志:
 [oracle@jumper oracle]$ rman target /Recovery Manager: Release 9.2.0.4.0 - PRodUCtionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.connected to target database: CONNER (DBID=3152029224)RMAN> run {2> backup database 3> format '/opt/oracle/orabak/full%d_%T_%s'4> plus archivelog 5> format '/opt/oracle/orabak/arch_%d_%T_%s'6> delete all input; }Starting backup at 04-NOV-04current log archivedusing target database controlfile instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=12 devtype=DISKchannel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=163 recid=6 stamp=541351580channel ORA_DISK_1: starting piece 1 at 04-NOV-04channel ORA_DISK_1: finished piece 1 at 04-NOV-04piece handle=/opt/oracle/orabak/arch_CONNER_20041104_7 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02channel ORA_DISK_1: deleting archive log(s)archive log filename=/opt/oracle/oradata/conner/archive/1_163.dbf recid=6 stamp=541351580Finished backup at 04-NOV-04Starting backup at 04-NOV-04using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetincluding current SPFILE in backupsetincluding current controlfile in backupsetinput datafile fno=00004 name=/opt/oracle/oradata/conner/eygle01.dbfinput datafile fno=00001 name=/opt/oracle/oradata/conner/system01.dbfinput datafile fno=00002 name=/opt/oracle/oradata/conner/undotbs01.dbfinput datafile fno=00003 name=/opt/oracle/oradata/conner/users01.dbfchannel ORA_DISK_1: starting piece 1 at 04-NOV-04aaaachannel ORA_DISK_1: finished piece 1 at 04-NOV-04piece handle=/opt/oracle/orabak/full_CONNER_20041104_8 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:04:04Finished backup at 04-NOV-04Starting backup at 04-NOV-04current log archivedusing channel ORA_DISK_1channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=164 recid=7 stamp=541351832channel ORA_DISK_1: starting piece 1 at 04-NOV-04channel ORA_DISK_1: finished piece 1 at 04-NOV-04piece handle=/opt/oracle/orabak/arch_CONNER_20041104_9 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02channel ORA_DISK_1: deleting archive log(s)archive log filename=/opt/oracle/oradata/conner/archive/1_164.dbf recid=7 stamp=541351832Finished backup at 04-NOV-04RMAN>

通過plus archivelog,簡化了備份操作,同時確保需要的日志都被備份。
 [oracle@jumper orabak]$ ls -ltotal 751628-rw-r----- 1 oracle dba 156160 Nov 4 15:26 arch_CONNER_20041104_7-rw-r----- 1 oracle dba 60928 Nov 4 15:30 arch_CONNER_20041104_9-rw-r----- 1 oracle dba 768679936 Nov 4 15:30 full_CONNER_20041104_8
本文作者:
eygle,Oracle技術關注者,來自中國最大的Oracle技術論壇itpub.
www.eygle.com是作者的個人站點.你可通過Guoqiang.Gai@Gmail.com來聯系作者.歡迎技術探討交流以及鏈接交換.
原文出處:http://www.eygle.com/ha/Use.Rman.Plus.Archivelog.Option.htm


發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 隆化县| 正蓝旗| 侯马市| 玛曲县| 张北县| 虎林市| 舒城县| 什邡市| 九江市| 清涧县| 涿州市| 天台县| 宾川县| 芜湖县| 无为县| 阿城市| 泾阳县| 芦山县| 顺昌县| 阿拉善盟| 雅江县| 离岛区| 张掖市| 新泰市| 寻甸| 大渡口区| 遂昌县| 封丘县| 永州市| 汉阴县| 江孜县| 北川| 永清县| 都江堰市| 漳浦县| 阿尔山市| 应城市| 县级市| 怀远县| 黑龙江省| 万荣县|