- 論壇徽章:
- 0
|
<DIV>
<DIV>RMAN> backup database plus archivelog;命令的理解！</DIV>
<DIV> </DIV>
<DIV>個人理解如下:</DIV>
<DIV>執(zhí)行命令后系統(tǒng) </DIV>
<DIV>切換redo log并歸檔</DIV>
<DIV>備份歸檔文件(scn：604010～609123)</DIV>
<DIV>備份數(shù)據(jù)文件（ckp scn：609130/609129）</DIV>
<DIV>切換redo log并歸檔</DIV>
<DIV>備份歸檔文件（scn：609123～609152）</DIV>
<DIV>備份spfile和control file（ckp scn：609158）</DIV>
<DIV> </DIV>
<DIV>具體操作如下：</DIV>
<DIV>RMAN> backup database plus archivelog;</DIV>
<DIV>Starting backup at 30-JUL-09</DIV>
<DIV>current log archived //命令開始，切換redo log并歸檔！</DIV>
<DIV>using channel ORA_DISK_1</DIV>
<DIV>using channel ORA_DISK_2</DIV>
<DIV>channel ORA_DISK_1: starting archive log backupset</DIV>
<DIV>channel ORA_DISK_1: specifying archive log(s) in backup set</DIV>
<DIV>input archive log thread=1 sequence=7 recid=43 stamp=693543239</DIV>
<DIV>channel ORA_DISK_1: starting piece 1 at 30-JUL-09</DIV>
<DIV>channel ORA_DISK_1: finished piece 1 at 30-JUL-09</DIV>
<DIV>--開始備份歸檔日志（scn：604010～609123）</DIV>
<DIV>piece handle=/opt/oracle/flash_recovery_area/BOY/backupset/2009_07_30/o1_mf_annnn_TAG20090730T025359_5716pgom_.bkp tag=TAG20090730T025359 comment=NONE</DIV>
<DIV>channel ORA_DISK_1: backup set complete, elapsed time: 00:00:05</DIV>
<DIV>Finished backup at 30-JUL-09</DIV>
<DIV> </DIV>
<DIV>Starting backup at 30-JUL-09</DIV>
<DIV>using channel ORA_DISK_1</DIV>
<DIV>using channel ORA_DISK_2</DIV>
<DIV>channel ORA_DISK_1: starting full datafile backupset</DIV>
<DIV>channel ORA_DISK_1: specifying datafile(s) in backupset</DIV>
<DIV>input datafile fno=00001 name=/opt/oracle/oradata/boy/system01.dbf</DIV>
<DIV>input datafile fno=00004 name=/opt/oracle/oradata/boy/users01.dbf</DIV>
<DIV>channel ORA_DISK_1: starting piece 1 at 30-JUL-09</DIV>
<DIV>channel ORA_DISK_2: starting full datafile backupset</DIV>
<DIV>channel ORA_DISK_2: specifying datafile(s) in backupset</DIV>
<DIV>input datafile fno=00003 name=/opt/oracle/oradata/boy/sysaux01.dbf</DIV>
<DIV>input datafile fno=00002 name=/opt/oracle/oradata/boy/undotbs01.dbf</DIV>
<DIV>input datafile fno=00005 name=/opt/oracle/oradata/boy/rman_ts.dbf</DIV>
<DIV>channel ORA_DISK_2: starting piece 1 at 30-JUL-09</DIV>
<DIV>channel ORA_DISK_2: finished piece 1 at 30-JUL-09</DIV>
<DIV>--開始備份數(shù)據(jù)文件（scn：609130）</DIV>
<DIV>piece handle=/opt/oracle/flash_recovery_area/BOY/backupset/2009_07_30/o1_mf_nnndf_TAG20090730T025407_5716pjdb_.bkp tag=TAG20090730T025407 comment=NONE</DIV>
<DIV>channel ORA_DISK_2: backup set complete, elapsed time: 00:00:26</DIV>
<DIV>channel ORA_DISK_1: finished piece 1 at 30-JUL-09</DIV>
<DIV>--開始備份數(shù)據(jù)文件（scn：609129）</DIV>
<DIV>piece handle=/opt/oracle/flash_recovery_area/BOY/backupset/2009_07_30/o1_mf_nnndf_TAG20090730T025407_5716pj5t_.bkp tag=TAG20090730T025407 comment=NONE</DIV>
<DIV>channel ORA_DISK_1: backup set complete, elapsed time: 00:00:42</DIV>
<DIV>Finished backup at 30-JUL-09</DIV>
<DIV> </DIV>
<DIV>Starting backup at 30-JUL-09</DIV>
<DIV>current log archived --切換redo log并歸檔！</DIV>
<DIV>using channel ORA_DISK_1</DIV>
<DIV>using channel ORA_DISK_2</DIV>
<DIV>channel ORA_DISK_1: starting archive log backupset</DIV>
<DIV>channel ORA_DISK_1: specifying archive log(s) in backup set</DIV>
<DIV>input archive log thread=1 sequence=8 recid=44 stamp=693543290</DIV>
<DIV>channel ORA_DISK_1: starting piece 1 at 30-JUL-09</DIV>
<DIV>channel ORA_DISK_1: finished piece 1 at 30-JUL-09</DIV>
<DIV>--開始備份歸檔日志（scn：609123～609152）</DIV>
<DIV>piece handle=/opt/oracle/flash_recovery_area/BOY/backupset/2009_07_30/o1_mf_annnn_TAG20090730T025450_5716qvd3_.bkp tag=TAG20090730T025450 comment=NONE</DIV>
<DIV>channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02</DIV>
<DIV>Finished backup at 30-JUL-09</DIV>
<DIV> </DIV>
<DIV>--開始備份控制文件和spfile（scn：609158）</DIV>
<DIV>Starting Control File and SPFILE Autobackup at 30-JUL-09</DIV>
<DIV>piece handle=/opt/oracle/flash_recovery_area/BOY/autobackup/2009_07_30/o1_mf_s_693543292_5716qws7_.bkp comment=NONE</DIV>
<DIV>Finished Control File and SPFILE Autobackup at 30-JUL-09</DIV>
<DIV> </DIV>
<DIV>RMAN> list backup;</DIV>
<DIV> </DIV>
<DIV>List of Backup Sets</DIV>
<DIV>===================</DIV>
<DIV> </DIV>
<DIV>BS Key Size Device Type Elapsed Time Completion Time</DIV>
<DIV>------- ---------- ----------- ------------ ---------------</DIV>
<DIV>49 2.79M DISK 00:00:04 30-JUL-09 </DIV>
<DIV> BP Key: 48 Status: AVAILABLE Compressed: NO Tag: TAG20090730T025359</DIV>
<DIV> Piece Name: /opt/oracle/flash_recovery_area/BOY/backupset/2009_07_30/o1_mf_annnn_TAG20090730T025359_5716pgom_.bkp</DIV>
<DIV> </DIV>
<DIV> List ofArchived Logsin backup set 49</DIV>
<DIV> Thrd Seq Low SCN Low Time Next SCN Next Time</DIV>
<DIV> ---- ------- ---------- --------- ---------- ---------</DIV>
<DIV> 1 7 604010 30-JUL-09609123 30-JUL-09</DIV>
<DIV> </DIV>
<DIV>BS Key TypeLVSize Device Type Elapsed Time Completion Time</DIV>
<DIV>------- ---- -- ---------- ----------- ------------ ---------------</DIV>
<DIV>50 Full 183.75M DISK 00:00:19 30-JUL-09 </DIV>
<DIV> BP Key: 49 Status: AVAILABLE Compressed: NO Tag: TAG20090730T025407</DIV>
<DIV> Piece Name: /opt/oracle/flash_recovery_area/BOY/backupset/2009_07_30/o1_mf_nnndf_TAG20090730T025407_5716pjdb_.bkp</DIV>
<DIV> List ofDatafilesin backup set 50</DIV>
<DIV> FileLVTypeCkp SCN Ckp Time Name</DIV>
<DIV> ---- -- ---- ---------- --------- ----</DIV>
<DIV> 2 Full609130 30-JUL-09 /opt/oracle/oradata/boy/undotbs01.dbf</DIV>
<DIV> 3 Full609130 30-JUL-09 /opt/oracle/oradata/boy/sysaux01.dbf</DIV>
<DIV> 5 Full609130 30-JUL-09 /opt/oracle/oradata/boy/rman_ts.dbf</DIV>
<DIV> </DIV>
<DIV>BS Key TypeLVSize Device Type Elapsed Time Completion Time</DIV>
<DIV>------- ---- -- ---------- ----------- ------------ ---------------</DIV>
<DIV>51 Full 358.00M DISK 00:00:39 30-JUL-09 </DIV>
<DIV> BP Key: 50 Status: AVAILABLE Compressed: NO Tag: TAG20090730T025407</DIV>
<DIV> Piece Name: /opt/oracle/flash_recovery_area/BOY/backupset/2009_07_30/o1_mf_nnndf_TAG20090730T025407_5716pj5t_.bkp</DIV>
<DIV> List ofDatafilesin backup set 51</DIV>
<DIV> FileLVTypeCkp SCN Ckp Time Name</DIV>
<DIV> ---- -- ---- ---------- --------- ----</DIV>
<DIV> 1 Full609129 30-JUL-09 /opt/oracle/oradata/boy/system01.dbf</DIV>
<DIV> 4 Full609129 30-JUL-09 /opt/oracle/oradata/boy/users01.dbf</DIV>
<DIV> </DIV>
<DIV>BS Key Size Device Type Elapsed Time Completion Time</DIV>
<DIV>------- ---------- ----------- ------------ ---------------</DIV>
<DIV>52 6.50K DISK 00:00:01 30-JUL-09 </DIV>
<DIV> BP Key: 51 Status: AVAILABLE Compressed: NO Tag: TAG20090730T025450</DIV>
<DIV> Piece Name: /opt/oracle/flash_recovery_area/BOY/backupset/2009_07_30/o1_mf_annnn_TAG20090730T025450_5716qvd3_.bkp</DIV>
<DIV> </DIV>
<DIV> List ofArchived Logsin backup set 52</DIV>
<DIV> Thrd Seq Low SCN Low Time Next SCN Next Time</DIV>
<DIV> ---- ------- ---------- --------- ---------- ---------</DIV>
<DIV> 1 8 609123 30-JUL-09 609152 30-JUL-09</DIV>
<DIV> </DIV>
<DIV>BS Key TypeLVSize Device Type Elapsed Time Completion Time</DIV>
<DIV>------- ---- -- ---------- ----------- ------------ ---------------</DIV>
<DIV>53 Full 6.92M DISK 00:00:00 30-JUL-09 </DIV>
<DIV> BP Key: 52 Status: AVAILABLE Compressed: NO Tag: TAG20090730T025452</DIV>
<DIV> Piece Name: /opt/oracle/flash_recovery_area/BOY/autobackup/2009_07_30/o1_mf_s_693543292_5716qws7_.bkp</DIV>
<DIV> Control FileIncluded:Ckp SCN: 609158 Ckp time: 30-JUL-09</DIV>
<DIV> SPFILE Included: Modification time: 29-JUL-09</DIV>
<DIV> </DIV>
<DIV>疑問+靈感：</DIV>
<DIV>其實我沒做copy備份，可是下面的命令能看到歸檔文件！那么是不是可以通過delete copy來刪除歸檔文件呢？</DIV>
<DIV>答案：好像可以！</DIV>
<DIV>RMAN> list copy; </DIV>
<DIV> </DIV>
<DIV>List of Archived Log Copies</DIV>
<DIV>Key Thrd Seq S Low Time Name</DIV>
<DIV>------- ---- ------- - --------- ----</DIV>
<DIV>43 1 7 A30-JUL-09 /opt/oracle/flash_recovery_area/BOY/archivelog/2009_07_30/o1_mf_1_7_5716p7bz_.arc</DIV>
<DIV>44 1 8 A30-JUL-09 /opt/oracle/flash_recovery_area/BOY/archivelog/2009_07_30/o1_mf_1_8_5716qt6y_.arc</DIV></DIV> |
|
免費注冊
發(fā)表于 2011-12-20 09:48