input datafile file number=00005 name=D:\ORACLE\ORADATA\LICS\DATAFILE\O1_MF_DMS
ACE_909KSRKZ_.DBF
input datafile file number=00006 name=D:\ORACLE\ORADATA\LICS\DATAFILE\O1_MF_DMS
ACE_909L45DL_.DBF
input datafile file number=00007 name=D:\ORACLE\ORADATA\LICS\DATAFILE\O1_MF_DMS
ACE_909L9MKP_.DBF
input datafile file number=00010 name=D:\ORACLE\ORADATA\LICS\DATAFILE\O1_MF_DMS
ACE_96L034K9_.DBF
input datafile file number=00011 name=D:\ORACLE\ORADATA\LICS\DATAFILE\O1_MF_DMS
ACE_9RTWV86G_.DBF
input datafile file number=00014 name=D:\ORACLE\ORADATA\LICS\DATAFILE\DMSPACE01
input datafile file number=00015 name=D:\ORACLE\ORADATA\LICS\DATAFILE\DMSPACE00
.DBF
input datafile file number=00016 name=D:\ORACLE\ORADATA\LICS\DATAFILE\DMSPACE00
.DBF
input datafile file number=00008 name=D:\ORACLE\ORADATA\LICS\DATAFILE\O1_MF_DMS
ACE_92YJFRMM_.DBF
input datafile file number=00009 name=D:\ORACLE\ORADATA\LICS\DATAFILE\O1_MF_DMS
ACE_92YK9N0F_.DBF
input datafile file number=00013 name=D:\ORACLE\ORADATA\LICS\DATAFILE\O1_MF_DMS
ACE_F34K8MYT_.DBF
input datafile file number=00012 name=D:\ORACLE\ORADATA\LICS\DATAFILE\O1_MF_DMS
ACE_DF1Q77VV_.DBF
input datafile file number=00017 name=D:\ORACLE\ORADATA\DMSPACE003.DBF
input datafile file number=00002 name=D:\ORACLE\ORADATA\LICS\DATAFILE\O1_MF_SYS
UX_909HJY3O_.DBF
input datafile file number=00001 name=D:\ORACLE\ORADATA\LICS\DATAFILE\O1_MF_SYS
EM_909HJY2P_.DBF
input datafile file number=00003 name=D:\ORACLE\ORADATA\LICS\DATAFILE\O1_MF_UND
TBS1_909HJY3O_.DBF
input datafile file number=00004 name=D:\ORACLE\ORADATA\LICS\DATAFILE\O1_MF_USE
S_909HJY4N_.DBF
channel ORA_DISK_1: starting piece 1 at 26-JUN-24
channel ORA_DISK_1: finished piece 1 at 26-JUN-24
piece handle=E:\ORACLE\BACKUP\RMAN\LICS\LICS_14297_20240626 tag=TAG20240626T143
36 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:11:05
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 26-JUN-24
channel ORA_DISK_1: finished piece 1 at 26-JUN-24
piece handle=E:\ORACLE\BACKUP\RMAN\LICS\LICS_14298_20240626 tag=TAG20240626T143
36 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 26-JUN-24

Starting backup at 26-JUN-24
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=89181 RECID=88790 STAMP=1172673943
channel ORA_DISK_1: starting piece 1 at 26-JUN-24
channel ORA_DISK_1: finished piece 1 at 26-JUN-24
piece handle=E:\ORACLE\BACKUP\RMAN\LICS\LICS_14299_20240626 tag=TAG20240626T144
44 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 26-JUN-24

RMAN>


select status, checkpoint_change#,
to_char(checkpoint_time, 'DD-MON-YYYY HH24:MI:SS') as checkpoint_time,
count(*)
from v$datafile_header
group by status, checkpoint_change#, checkpoint_time
order by status, checkpoint_change#, checkpoint_time;


ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\ORACLE\ORADATA\LICS\DATAFILE\O1_MF_TEMP.dbf' REUSE;