ssion altered.
SQL> col name for a100
SQL> set lines 132
SQL> alter system switch logfile;
System altered.
SQL> select name,completion_time from v$archived_log;
NAME COMPLETION_TIME
---------------------------------------------------------------------------------------------------- -----------------
/ora10g/flash_recovery_area/EBANK/archivelog/2008_12_18/o1_mf_1_1_4no7w6tg_.arc 20081218 14:07:50
/ora10g/arch/1_2_673797803.dbf 20081218 14:21:01
/ora10g/flash_recovery_area/EBANK/archivelog/2008_12_18/o1_mf_1_2_4no8nwq9_.arc 20081218 14:21:01
/ora10g/arch/1_3_673797803.dbf 20081218 14:22:15
/ora10g/arch/1_4_673797803.dbf 20081218 14:23:03
SQL> alter system switch logfile;
System altered.
SQL> select name,completion_time from v$archived_log;
NAME COMPLETION_TIME
---------------------------------------------------------------------------------------------------- -----------------
/ora10g/flash_recovery_area/EBANK/archivelog/2008_12_18/o1_mf_1_1_4no7w6tg_.arc 20081218 14:07:50
/ora10g/arch/1_2_673797803.dbf 20081218 14:21:01
/ora10g/flash_recovery_area/EBANK/archivelog/2008_12_18/o1_mf_1_2_4no8nwq9_.arc 20081218 14:21:01
/ora10g/arch/1_3_673797803.dbf 20081218 14:22:15
/ora10g/arch/1_4_673797803.dbf 20081218 14:23:03
/ora10g/arch/1_5_673797803.dbf 20081218 14:23:36
6 rows selected.
3.log_archive_desc和db_recovery_file_desc参数被同时设置
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> alter system switch logfile;
System altered.
SQL> select name,completion_time from v$archived_log;
NAME COMPLETIO
---------------------------------------------------------------------------------------------------- ---------
/ora10g/flash_recovery_area/EBANK/archivelog/2008_12_18/o1_mf_1_1_4no7w6tg_.arc 18-DEC-08
/ora10g/arch/1_2_673797803.dbf 18-DEC-08
/ora10g/flash_recovery_area/EBANK/archivelog/2008_12_18/o1_mf_1_2_4no8nwq9_.arc 18-DEC-08
/ora10g/arch/1_3_673797803.dbf 18-DEC-08
/ora10g/arch/1_4_673797803.dbf 18-DEC-08
/ora10g/arc