基于件复制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.

(责任编辑：数据库)