[oracle@aaaaaa ~]$ sqlplus / as sysdba
SQL> desc dba_data_files;
 Name                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 FILE_NAME                      VARCHAR2(513)
 FILE_ID                        NUMBER
 TABLESPACE_NAME                    VARCHAR2(30)
 BYTES                          NUMBER
 BLOCKS                         NUMBER
 STATUS                         VARCHAR2(9)
 RELATIVE_FNO                       NUMBER
 AUTOEXTENSIBLE                     VARCHAR2(3)
 MAXBYTES                       NUMBER
 MAXBLOCKS                      NUMBER
 INCREMENT_BY                       NUMBER
 USER_BYTES                     NUMBER
 USER_BLOCKS                        NUMBER
 ONLINE_STATUS                      VARCHAR2(7)

SQL> set linesize 200
SQL> col file_name for a55;
SQL> select TABLESPACE_NAME,file_name from dba_data_files

TABLESPACE_NAME            FILE_NAME
------------------------------ -------------------------------------------------------
SYSTEM                 /oracle/app/oracle/oradata/aaas/system01.dbf
SYSAUX                 /oracle/app/oracle/oradata/aaams/sysaux01.dbf
UNDOTBS1               /oracle/app/oracle/oradata/aaams/undotbs01.dbf
USERS                  /oracle/app/oracle/oradata/aaams/users01.dbf
SECURITY               /oracle/app/oracle/oradata/aaams/SECURITY001.dbf
PMS                /oracle/app/oracle/oradata/aaams/pms001.dbf
DATA_EPC               /oracle/app/oracle/oradata/aaams/data_epc001.dbf
INDX_EPC               /oracle/app/oracle/oradata/aaams/INDX_EPC001.DBF

8 rows selected.
SQL> archive log list;
Database log mode          Archive Mode
Automatic archival         Enabled
Archive destination        /oracle/app/oracle/arch/
Oldest online log sequence     27892
Next log sequence to archive   27894
Current log sequence           27894

rman target /
crosscheck archivelog all;  #检查归档日志
delete expired archivelog all;  #删除过期日志
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7'; #删除7天前的归档日志

[root@aaaa arch]# pwd
/oracle/app/oracle/arch
[root@aaaa arch]# find .  -mtime +7 -name "[0-9]*.dbf"  | wc -l
1719
[root@aaaa arch]# find .  -mtime +7 -name "[0-9]*.dbf"  -exec rm -f {}  \;

RMAN> BACKUP DATABASE FORMAT '/oracle/backup/pms202004210848.bak'; #重新进行全库备份