oracle plus archivelog,backup database plus archivelog; 命令的理解！

RMAN> backup database plus archivelog;命令的理解！

个人理解如下：

执行命令后系统切换redo log并归档à备份归档文件(scn：604010～609123)à备份数据文件(ckp scn：609130/609129)à切换redo log并归档à备份归档文件(scn：609123～609152)à备份spfile和control file(ckp scn：609158)

具体操作如下：

RMAN> backup database plus archivelog;

Starting backup at 30-JUL-09

current log archived //命令开始，切换redo log并归档！

using channel ORA_DISK_1

using channel ORA_DISK_2

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=7 recid=43 stamp=693543239

channel ORA_DISK_1: starting piece 1 at 30-JUL-09

channel ORA_DISK_1: finished piece 1 at 30-JUL-09

--开始备份归档日志(scn：604010～609123)

piece handle=/opt/oracle/flash_recovery_area/BOY/backupset/2009_07_30/o1_mf_annnn_TAG20090730T025359_5716pgom_.bkp tag=TAG20090730T025359 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:05

Finished backup at 30-JUL-09

Starting backup at 30-JUL-09

using channel ORA_DISK_1

using channel ORA_DISK_2

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00001 name=/opt/oracle/oradata/boy/system01.dbf

input datafile fno=00004 name=/opt/oracle/oradata/boy/users01.dbf

channel ORA_DISK_1: starting piece 1 at 30-JUL-09

channel ORA_DISK_2: starting full datafile backupset

channel ORA_DISK_2: specifying datafile(s) in backupset

input datafile fno=00003 name=/opt/oracle/oradata/boy/sysaux01.dbf

input datafile fno=00002 name=/opt/oracle/oradata/boy/undotbs01.dbf

input datafile fno=00005 name=/opt/oracle/oradata/boy/rman_ts.dbf

channel ORA_DISK_2: starting piece 1 at 30-JUL-09

channel ORA_DISK_2: finished piece 1 at 30-JUL-09

--开始备份数据文件(scn：609130)

piece handle=/opt/oracle/flash_recovery_area/BOY/backupset/2009_07_30/o1_mf_nnndf_TAG20090730T025407_5716pjdb_.bkp tag=TAG20090730T025407 comment=NONE

channel ORA_DISK_2: backup set complete, elapsed time: 00:00:26

channel ORA_DISK_1: finished piece 1 at 30-JUL-09

--开始备份数据文件(scn：609129)

piece handle=/opt/oracle/flash_recovery_area/BOY/backupset/2009_07_30/o1_mf_nnndf_TAG20090730T025407_5716pj5t_.bkp tag=TAG20090730T025407 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:42

Finished backup at 30-JUL-09

Starting backup at 30-JUL-09

current log archived--切换redo log并归档！

using channel ORA_DISK_1

using channel ORA_DISK_2

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=8 recid=44 stamp=693543290

channel ORA_DISK_1: starting piece 1 at 30-JUL-09

channel ORA_DISK_1: finished piece 1 at 30-JUL-09

--开始备份归档日志(scn：609123～609152)

piece handle=/opt/oracle/flash_recovery_area/BOY/backupset/2009_07_30/o1_mf_annnn_TAG20090730T025450_5716qvd3_.bkp tag=TAG20090730T025450 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02

Finished backup at 30-JUL-09

--开始备份控制文件和spfile(scn：609158)

Starting Control File and SPFILE Autobackup at 30-JUL-09

piece handle=/opt/oracle/flash_recovery_area/BOY/autobackup/2009_07_30/o1_mf_s_693543292_5716qws7_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 30-JUL-09

RMAN> list backup;

List of Backup Sets

===================

BS KeySizeDevice Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

492.79MDISK00:00:0430-JUL-09

BP Key: 48Status: AVAILABLECompressed: NOTag: TAG20090730T025359

Piece Name: /opt/oracle/flash_recovery_area/BOY/backupset/2009_07_30/o1_mf_annnn_TAG20090730T025359_5716pgom_.bkp

List of Archived Logsin backup set 49

Thrd SeqLow SCNLow TimeNext SCNNext Time

---- ------- ---------- --------- ---------- ---------

1760401030-JUL-09 60912330-JUL-09

BS KeyType LV SizeDevice Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

50Full183.75MDISK00:00:1930-JUL-09

BP Key: 49Status: AVAILABLECompressed: NOTag: TAG20090730T025407

Piece Name: /opt/oracle/flash_recovery_area/BOY/backupset/2009_07_30/o1_mf_nnndf_TAG20090730T025407_5716pjdb_.bkp

List of Datafiles in backup set 50

File LV Type Ckp SCNCkp TimeName

---- -- ---- ---------- --------- ----

2Full 60913030-JUL-09 /opt/oracle/oradata/boy/undotbs01.dbf

3Full 60913030-JUL-09 /opt/oracle/oradata/boy/sysaux01.dbf

5 Full 60913030-JUL-09 /opt/oracle/oradata/boy/rman_ts.dbf

BS KeyType LV SizeDevice Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

51Full358.00MDISK00:00:3930-JUL-09

BP Key: 50Status: AVAILABLECompressed: NOTag: TAG20090730T025407

Piece Name: /opt/oracle/flash_recovery_area/BOY/backupset/2009_07_30/o1_mf_nnndf_TAG20090730T025407_5716pj5t_.bkp

List of Datafilesin backup set 51

File LV Type Ckp SCNCkp TimeName

---- -- ---- ---------- --------- ----

1Full 60912930-JUL-09 /opt/oracle/oradata/boy/system01.dbf

4Full 60912930-JUL-09 /opt/oracle/oradata/boy/users01.dbf

BS KeySizeDevice Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

526.50KDISK00:00:0130-JUL-09

BP Key: 51Status: AVAILABLECompressed: NOTag: TAG20090730T025450

Piece Name: /opt/oracle/flash_recovery_area/BOY/backupset/2009_07_30/o1_mf_annnn_TAG20090730T025450_5716qvd3_.bkp

List of Archived Logsin backup set 52

Thrd SeqLow SCNLow TimeNext SCNNext Time

---- ------- ---------- --------- ---------- ---------

1860912330-JUL-09 60915230-JUL-09

BS KeyType LV SizeDevice Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

53Full6.92MDISK00:00:0030-JUL-09

BP Key: 52Status: AVAILABLECompressed: NOTag: TAG20090730T025452

Piece Name: /opt/oracle/flash_recovery_area/BOY/autobackup/2009_07_30/o1_mf_s_693543292_5716qws7_.bkp

Control File Included: Ckp SCN: 609158Ckp time: 30-JUL-09

SPFILE Included: Modification time: 29-JUL-09

疑问+灵感：

其实我没做copy备份，可是下面的命令能看到归档文件！那么是不是可以通过delete copy来删除归档文件呢？

答案：好像可以！

RMAN> list copy;

List of Archived Log Copies

KeyThrd SeqS Low TimeName

------- ---- ------- - --------- ----

4317A 30-JUL-09 /opt/oracle/flash_recovery_area/BOY/archivelog/2009_07_30/o1_mf_1_7_5716p7bz_.arc

4418A 30-JUL-09 /opt/oracle/flash_recovery_area/BOY/archivelog/2009_07_30/o1_mf_1_8_5716qt6y_.arc