select * from v$archive_log where to_date('2020-05-07 18:32:20','yyyy-mm-dd hh24:mi:ss') between first_time and next_time;
rman> catalog backuppiece '/../../...arc';
rman> restore archivelog from logseq ... until logseq ...;
rman> catalog archivelog '/../../...arc';
rman> list backup of archivelog from logseq ... until logseq ...;
rman>
run{
allocate channel d1 type 'sbt_type' parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ynsicp,OB2BARLIST=YNSICP_full_weekly)';
set archivelog destination to '/../';
restore archivelog from logseq ... until logseq ... thread ...;
release channel d1;
}
run{
allocate channel dev_7 type 'sbt_tape' parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ynsicp,OB2BARLIST=YNSICP_full_weekly)';
restore archivelog from logseq 37539 until logseq 37567 thread 2;
release channel dev_7;
}
allocate channel 'dev_7' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ynsicp,OB2BARLIST=YNSICP_arch_daily)';
sql 'alter system archive log current';
backup
format 'YNSICP_arch_daily<ynsicp_%s:%t:%p>.dbf'
archivelog all;
delete noprompt archivelog until time 'sysdate-3';
release channel 'dev_0';