基于件复制SQL> select name from v$archived_log where dest_id=1 and first_time>=sysdate-1; NAME ------------------------------------------------------------------------------------------------------------------------ /oracle/10g/oracle/log/archive_log/archive_1_23_757801926.arclog /oracle/10g/oracle/log/archive_log/archive_1_24_757801926.arclog SQL> select name from v$archived_log where dest_id=10 and first_time>=sysdate-1; NAME ------------------------------------------------------------------------------------------------------------------------ /oracle/10g/oracle/product/10.2.0/db_1/flash_recovery_area/ORALIFE/archivelog/2011_08_01/o1_mf_1_23_73fljh3f_.arc /oracle/10g/oracle/product/10.2.0/db_1/flash_recovery_area/ORALIFE/archivelog/2011_08_02/o1_mf_1_24_73hwlry6_.arc SQL> select destination from v$archive_dest; DESTINATION ------------------------------------------------------------------------------------------------------------------------ /oracle/10g/oracle/log/archive_log /oracle/10g/oracle/log/archive_log2 USE_DB_RECOVERY_FILE_DEST 10 rows selected. 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.