不備份上次已經備份的歸檔

paulyibinyi發表於2008-02-28

backup archivelog all not backed up 1 times;  不備份上次已經備份的歸檔

delete noprompt archivelog all completed before 'sysdate -7'; 在本地保留7天的歸檔日誌.

RMAN> backup archivelog all not backed up 1 times;

Starting backup at 28-FEB-08
current log archived
using channel ORA_DISK_1
skipping archive log file D:\ARCHPAUL\1_10.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_11.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_12.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_13.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_14.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_15.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_16.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_17.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_18.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_19.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_20.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_21.DBF; already backed up 2 time(s)
skipping archive log file D:\ARCHPAUL\1_22.DBF; already backed up 1 time(s)
skipping archive log file D:\ARCHPAUL\1_23.DBF; already backed up 1 time(s)
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=24 recid=1361 stamp=647891751
channel ORA_DISK_1: starting piece 1 at 28-FEB-08
channel ORA_DISK_1: finished piece 1 at 28-FEB-08
piece handle=D:\BACKUP\7RJ9S2P7_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 28-FEB-08

Starting Control File and SPFILE Autobackup at 28-FEB-08
piece handle=D:\BACKUP\C-1605165889-20080228-09 comment=NONE
Finished Control File and SPFILE Autobackup at 28-FEB-08

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-196160/,如需轉載,請註明出處,否則將追究法律責任。

相關文章