Oracle: Backupset keep until


  -- get backup handle and backup pieces select d.name,        b.bs_key,S.HANDLE,        decode(b.incremental_level,null,decode(b.backup_type,'D','Ctrl','I','Inc','L','Arch','n/k'),         'Inc'||b.incremental_level) backup_type,        decode(b.status,'A','Avail.','O','Obsolete',b.status) status,        b.pieces,        b.start_time,        decode(b.controlfile_included,'NONE','No','BACKUP','Yes','STANDBY','Standby','n/k') controlfile_included,        b.keep,b.keep_options,        b.keep_until from rc_database d,      rc_backup_set b,      rc_backup_piece s where d.db_key=b.db_key and d.db_key=s.db_key       and B.SET_COUNT=S.SET_COUNT and B.SET_STAMP=S.SET_STAMP       and upper(d.name) like upper('ADMP01')      ... Continue Reading →

Advertisements

Blog at WordPress.com.

Up ↑