rman全庫備份備份歸檔日誌檔案
用rman全庫備份,包括歸檔歸檔日誌檔案備份,控制檔案與引數檔案自動備份:
[oracle@oracle ~]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Oct 16 17:22:56 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORA11GR2 (DBID=238796283)
RMAN> backup database plus archivelog;
Starting backup at 16-OCT-16
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=44 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=59 RECID=37 STAMP=924897627
input archived log thread=1 sequence=60 RECID=38 STAMP=924968778
input archived log thread=1 sequence=61 RECID=39 STAMP=925156048
input archived log thread=1 sequence=62 RECID=40 STAMP=925157378
input archived log thread=1 sequence=63 RECID=41 STAMP=925157838
input archived log thread=1 sequence=64 RECID=42 STAMP=925164026
input archived log thread=1 sequence=65 RECID=43 STAMP=925166147
input archived log thread=1 sequence=66 RECID=44 STAMP=925168784
input archived log thread=1 sequence=67 RECID=45 STAMP=925169035
input archived log thread=1 sequence=68 RECID=46 STAMP=925205840
input archived log thread=1 sequence=69 RECID=47 STAMP=925224968
input archived log thread=1 sequence=70 RECID=48 STAMP=925230868
input archived log thread=1 sequence=71 RECID=49 STAMP=925253889
input archived log thread=1 sequence=72 RECID=50 STAMP=925255635
input archived log thread=1 sequence=73 RECID=51 STAMP=925257078
input archived log thread=1 sequence=74 RECID=52 STAMP=925257134
input archived log thread=1 sequence=75 RECID=53 STAMP=925257135
input archived log thread=1 sequence=76 RECID=54 STAMP=925257169
input archived log thread=1 sequence=77 RECID=55 STAMP=925257203
input archived log thread=1 sequence=78 RECID=56 STAMP=925257242
input archived log thread=1 sequence=79 RECID=57 STAMP=925257291
input archived log thread=1 sequence=80 RECID=58 STAMP=925399179
input archived log thread=1 sequence=81 RECID=59 STAMP=925406620
channel ORA_DISK_1: starting piece 1 at 16-OCT-16
channel ORA_DISK_1: finished piece 1 at 16-OCT-16
piece handle=/u01/app/backup/db_0irih5ct_1_1.rmn tag=TAG20161016T172340 comment=NONE #歸檔日誌檔案備份集
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
Finished backup at 16-OCT-16
Starting backup at 16-OCT-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ORA11GR2/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/ORA11GR2/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/ORA11GR2/example01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ORA11GR2/users01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/ORA11GR2/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 16-OCT-16
channel ORA_DISK_1: finished piece 1 at 16-OCT-16
piece handle=/u01/app/backup/db_0jrih5eu_1_1.rmn tag=TAG20161016T172446 comment=NONE #資料檔案備份集
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:58
Finished backup at 16-OCT-16
Starting backup at 16-OCT-16
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=82 RECID=60 STAMP=925406865
channel ORA_DISK_1: starting piece 1 at 16-OCT-16
channel ORA_DISK_1: finished piece 1 at 16-OCT-16
piece handle=/u01/app/backup/db_0krih5kh_1_1.rmn tag=TAG20161016T172745 comment=NONE #最新歸檔日誌檔案備份集
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 16-OCT-16
Starting Control File and SPFILE Autobackup at 16-OCT-16
piece handle=/u01/app/FRA/ORA11GR2/autobackup/2016_10_16/o1_mf_s_925406866_d06l0mmn_.bkp comment=NONE #引數檔案與控制檔案備份集
Finished Control File and SPFILE Autobackup at 16-OCT-16
備份完成。
[oracle@oracle ~]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Oct 16 17:22:56 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORA11GR2 (DBID=238796283)
RMAN> backup database plus archivelog;
Starting backup at 16-OCT-16
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=44 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=59 RECID=37 STAMP=924897627
input archived log thread=1 sequence=60 RECID=38 STAMP=924968778
input archived log thread=1 sequence=61 RECID=39 STAMP=925156048
input archived log thread=1 sequence=62 RECID=40 STAMP=925157378
input archived log thread=1 sequence=63 RECID=41 STAMP=925157838
input archived log thread=1 sequence=64 RECID=42 STAMP=925164026
input archived log thread=1 sequence=65 RECID=43 STAMP=925166147
input archived log thread=1 sequence=66 RECID=44 STAMP=925168784
input archived log thread=1 sequence=67 RECID=45 STAMP=925169035
input archived log thread=1 sequence=68 RECID=46 STAMP=925205840
input archived log thread=1 sequence=69 RECID=47 STAMP=925224968
input archived log thread=1 sequence=70 RECID=48 STAMP=925230868
input archived log thread=1 sequence=71 RECID=49 STAMP=925253889
input archived log thread=1 sequence=72 RECID=50 STAMP=925255635
input archived log thread=1 sequence=73 RECID=51 STAMP=925257078
input archived log thread=1 sequence=74 RECID=52 STAMP=925257134
input archived log thread=1 sequence=75 RECID=53 STAMP=925257135
input archived log thread=1 sequence=76 RECID=54 STAMP=925257169
input archived log thread=1 sequence=77 RECID=55 STAMP=925257203
input archived log thread=1 sequence=78 RECID=56 STAMP=925257242
input archived log thread=1 sequence=79 RECID=57 STAMP=925257291
input archived log thread=1 sequence=80 RECID=58 STAMP=925399179
input archived log thread=1 sequence=81 RECID=59 STAMP=925406620
channel ORA_DISK_1: starting piece 1 at 16-OCT-16
channel ORA_DISK_1: finished piece 1 at 16-OCT-16
piece handle=/u01/app/backup/db_0irih5ct_1_1.rmn tag=TAG20161016T172340 comment=NONE #歸檔日誌檔案備份集
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
Finished backup at 16-OCT-16
Starting backup at 16-OCT-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ORA11GR2/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/ORA11GR2/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/ORA11GR2/example01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ORA11GR2/users01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/ORA11GR2/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 16-OCT-16
channel ORA_DISK_1: finished piece 1 at 16-OCT-16
piece handle=/u01/app/backup/db_0jrih5eu_1_1.rmn tag=TAG20161016T172446 comment=NONE #資料檔案備份集
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:58
Finished backup at 16-OCT-16
Starting backup at 16-OCT-16
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=82 RECID=60 STAMP=925406865
channel ORA_DISK_1: starting piece 1 at 16-OCT-16
channel ORA_DISK_1: finished piece 1 at 16-OCT-16
piece handle=/u01/app/backup/db_0krih5kh_1_1.rmn tag=TAG20161016T172745 comment=NONE #最新歸檔日誌檔案備份集
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 16-OCT-16
Starting Control File and SPFILE Autobackup at 16-OCT-16
piece handle=/u01/app/FRA/ORA11GR2/autobackup/2016_10_16/o1_mf_s_925406866_d06l0mmn_.bkp comment=NONE #引數檔案與控制檔案備份集
Finished Control File and SPFILE Autobackup at 16-OCT-16
備份完成。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31392094/viewspace-2127105/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- RMAN備份歸檔日誌多份 %c
- 備份歸檔日誌檔案
- RMAN備份資料檔案+控制檔案+歸檔日誌
- RMAN備份歸檔日誌指令碼指令碼
- 備份歸檔日誌
- RMAN備份整庫和歸檔日誌的方法
- 備份之歸檔重做日誌備份
- RMAN說,我能備份(5)--RMAN備份歸檔檔案
- rman備份後為什麼要同時備份歸檔日誌
- 用RMAN備份歸檔日誌時檢查歸檔日誌是否存在
- Oracle設定多個歸檔路徑生成多份歸檔日誌,Rman備份時也只備份其中的一份歸檔日誌Oracle
- 使用logmnr,在RMAN備份檔案中恢復備份的歸檔日誌檔案進行分析
- Oracle RMAN 不完全恢復(只有資料檔案備份,丟失歸檔日誌備份)Oracle
- 歸檔日誌大小 與使用rman 備份後的歸檔日誌產生的備份集大小的關係
- oracle rman備份歸檔日誌需要先切換日誌嗎Oracle
- Backup And Recovery User's Guide-備份資料庫-備份歸檔重做日誌檔案GUIIDE資料庫
- Backup And Recovery User's Guide-備份資料庫-使用RMAN備份歸檔重做日誌GUIIDE資料庫
- RMAN備份及恢復歸檔日誌的語法
- Oracle使用備份檔案集恢復歸檔日誌Oracle
- 非歸檔資料庫RMAN備份資料庫
- RMAN備份與恢復(新舊控制檔案及歸檔日誌)測試
- rman備份但丟失一個資料檔案,但有歸檔備份
- 不完全恢復(資料檔案備份--新建表空間--控制檔案備份--日誌歸檔檔案)
- 冷備份+歸檔日誌的恢復
- RMAN備份與恢復(新舊控制檔案及歸檔日誌)測試(敘)
- Backup And Recovery User's Guide-只備份需要備份的歸檔重做日誌檔案GUIIDE
- 第5章:從開啟的資料庫備份與恢復之備份歸檔日誌檔案資料庫
- 誤刪歸檔日誌除導致備份歸檔日誌失敗
- 使用_allow_resetlogs_corruption開啟無歸檔日誌rman備份庫
- RMAN備份檔案格式
- oracle rman不能自動刪除歸檔日誌備份解決Oracle
- RMAN備份恢復之歸檔日誌對BLOCKRECOVER的影響BloC
- 手工rm刪除歸檔日誌對備份歸檔日誌的影響
- rman 備份 全庫
- RAC環境備份歸檔日誌和RMAN恢復啟動資料庫資料庫
- standby全庫rman備份檔案恢復到異機
- RMAN說,我能備份(4)--RMAN備份資料檔案和控制檔案
- 【備份恢復】恢復 丟失已歸檔重做日誌檔案